Article View: borland.public.cppbuilder.database.ado
Article #3322Re: TADOQuery
From: Mike Ruskai
Date: Tue, 17 Sep 2002 21:56
Date: Tue, 17 Sep 2002 21:56
29 lines
2022 bytes
2022 bytes
On Tue, 17 Sep 2002 16:58:08 +0200, Christoffer Christoffersen wrote: >Hello! > >I have a small cgi-application that´s connect to an MSAccess database using >ODBC. I want to make an SQL-query to the >database but I don´t know how to get the dataset from the TADOQuery. If >someone could give me som direction on this.. TADOQuery is a descendent of TCustomADODataSet (as well as TDataSet). It *is* a dataset. You use First()/Next()/Eof/FieldByName()/etc. just like with any other TDataSet descendent. You can also use the underlying Recordset object, which will be much faster, but require you to manually duplicate any features of the VCL classes you might be using (OnCalcFields, OnGetText, etc.). -- - Mike Remove 'spambegone.net' and reverse to send e-mail.
Technical Details
Message-ID:
<gunaalargpneevrepbz.h2lrle0.pminews@207.105.83.65>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!telocity-west!TELOCITY!news-out.spamkiller.net!propagator2-maxim!news-in.spamkiller.net!feed.newsfeeds.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<3d8742e0$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,803d94b36fc9e0f4 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-09-17 19:01:18 PST Newsgroups: borland.public.cppbuilder.database.ado From: "Mike Ruskai" <spammoc.reirracten@begoneynnaht.net> Message-ID: <gunaalargpneevrepbz.h2lrle0.pminews@207.105.83.65> References: <3d8742e0$1@newsgroups.borland.com> Date: Tue, 17 Sep 2002 17:56:02 -0400 (EDT) Reply-To: "Mike Ruskai" <spammoc.reirracten@begoneynnaht.net> X-Newsreader: PMINews 2.00.1205 For OS/2 Organization: TLF MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Re: TADOQuery NNTP-Posting-Host: 207.207.231.205 X-Trace: newsgroups.borland.com 1032299727 207.207.231.205 (17 Sep 2002 14:55:27 -0700) Lines: 31 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!telocity-west!TELOCITY!news-out.spamkiller.net!propagator2-maxim!news-in.spamkiller.net!feed.newsfeeds.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail