🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #1032

Re: MS Access databases and SQL insert

#1032
From: Matt Jacobs
Date: Wed, 15 Dec 2004 19:05
7 lines
1328 bytes
"Stefano Bonifazi" <stefboombastic@tele2.it> wrote:

> ADOQuery1->Open();

You need to use ADOQuery1->ExecSQL().

Only Open() for SQL SELECT statements.
Technical Details
Message-ID: <lk21s01m3nkubv72qb6sh7brvmr8dujn7o@4ax.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!proxad.net!easynet-quince!easynet.net!feed4.jnfs.ja.net!jnfs.ja.net!hamilton.zen.co.uk!zen.net.uk!dedekind.zen.co.uk!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail
References: <41bf77e4@newsgroups.borland.com> <41c008d4@newsgroups.borland.com> <41c01d2c@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,616038963bb3e51
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: Matt Jacobs <noyb@noyb.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: MS Access databases and SQL insert
Date: Wed, 15 Dec 2004 11:05:59 -0800
Reply-To: __noyb@noyb.com
Message-ID: <lk21s01m3nkubv72qb6sh7brvmr8dujn7o@4ax.com>
References: <41bf77e4@newsgroups.borland.com> <41c008d4@newsgroups.borland.com> <41c01d2c@newsgroups.borland.com>
X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 24.23.153.114
X-Trace: newsgroups.borland.com 1103137513 24.23.153.114 (15 Dec 2004 11:05:13 -0800)
Lines: 8
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!proxad.net!easynet-quince!easynet.net!feed4.jnfs.ja.net!jnfs.ja.net!hamilton.zen.co.uk!zen.net.uk!dedekind.zen.co.uk!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail