From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-0.3 required=5.0 tests=BAYES_00, REPLYTO_WITHOUT_TO_CC autolearn=no autolearn_force=no version=3.4.4 X-Google-Thread: 103376,7dd8b6756e477a8d X-Google-Attributes: gid103376,domainid0,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit Path: g2news2.google.com!news1.google.com!news.glorb.com!feeder.erje.net!fdn.fr!usenet-fr.net!nospam.fr.eu.org!nntpfeed.proxad.net!proxad.net!feeder2-2.proxad.net!newsfeed.arcor.de!newsspool3.arcor-online.net!news.arcor.de.POSTED!not-for-mail From: "Dmitry A. Kazakov" Subject: Re: Interface between Ada (AdaCore 6.1) and Microsoft Access Database (PC/XP) Newsgroups: comp.lang.ada User-Agent: 40tude_Dialog/2.0.15.1 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Reply-To: mailbox@dmitry-kazakov.de Organization: cbb software GmbH References: <9c8ac924-a393-4c85-9051-afe08409e05d@a26g2000prf.googlegroups.com> Date: Wed, 3 Dec 2008 20:35:34 +0100 Message-ID: NNTP-Posting-Date: 03 Dec 2008 20:35:34 CET NNTP-Posting-Host: 07468552.newsspool2.arcor-online.net X-Trace: DXC=57^PXmNCNL\AX0F2i> 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