🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: TADOQuery

#3322
From: Mike Ruskai
Date: Tue, 17 Sep 2002 21:56
29 lines
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-mail
References: <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