From: "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>
Subject: Re: Interface between Ada (AdaCore 6.1) and Microsoft Access Database (PC/XP)
Date: Wed, 3 Dec 2008 20:35:34 +0100
Date: 2008-12-03T20:35:34+01:00 [thread overview]
Message-ID: <lhfj4545b3pp$.1uyhcvuw41dk8.dlg@40tude.net> (raw)
In-Reply-To: 9c8ac924-a393-4c85-9051-afe08409e05d@a26g2000prf.googlegroups.com
On Wed, 3 Dec 2008 07:33:41 -0800 (PST), shulamith.sarfaty@baesystems.com
wrote:
> Please show me an example how to manipulate record sets from
> Microsoft Access Database. We need to open a connection,
> execute an SQL statement to UPDATE, INSERT, DELETE and/or SELECT
> records from the database.
Take a look at GNADE ODBC, which is Ada binding to ODBC.
> Also, I dynamically create a
> variable string containing my SQL statement. I want to
> execute an SQL string which is variable in length. How do I free
> the pointer to that string?
Create it on the stack and you will need not to care about freeing it. It
is also recommended to use precompiled (so-called "prepared") statements
rather than reinterpret it each time.
--
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de
prev parent reply other threads:[~2008-12-03 19:35 UTC|newest]
Thread overview: 3+ messages / expand[flat|nested] mbox.gz Atom feed top
2008-12-03 15:33 Interface between Ada (AdaCore 6.1) and Microsoft Access Database (PC/XP) shulamith.sarfaty
2008-12-03 18:30 ` Jeffrey R. Carter
2008-12-03 19:35 ` Dmitry A. Kazakov [this message]
replies disabled
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox