How to retrieve data from an ADO query

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

Article #514

Back to borland.public.cppbuilder.database.ado Previous Next

#514

From: George Nakos
Date: Tue, 30 Aug 2005 13:00

31 lines
1692 bytes

Greetings,

I know that this topic should tire you as I suspect that it has been  
answered a lot of times, but the answers I read didn't cover my needs.

My situation is this: I am using a TADOQuery to do some SQL queries to an  
MS Access database. This works fine, and I can even put the results in a  
dataset and display them using TDBText objects on screen.

My problem is that I don't want to display the data on screen, just store  
them in arrays and use them whenever necessary.

If someone could provide a step-by-step process on how to do this, and  
providing a few lines of sample code, I would be most grateful.



Thanks,
George Nakos

-- 
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Technical Details

Message-ID: <op.swbnqgj9qf2fxd@promitheas.metron.internal>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed.inode.at!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,8fb1b60fd2dcc362,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Newsgroups: borland.public.cppbuilder.database.ado
Subject: How to retrieve data from an ADO query
Date: Tue, 30 Aug 2005 16:00:06 +0300
From: "George Nakos" <gnakos@metronco.gr>
Organization: Metron LTD
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-7
MIME-Version: 1.0
Content-Transfer-Encoding: Quoted-Printable
Message-ID: <op.swbnqgj9qf2fxd@promitheas.metron.internal>
User-Agent: Opera M2/8.10 (Win32, build 7685)
NNTP-Posting-Host: 83.235.222.66
X-Trace: newsgroups.borland.com 1125406702 83.235.222.66 (30 Aug 2005 05:58:22 -0700)
Lines: 31
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed.inode.at!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail