How to Query in files

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

Article #2808

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

#2808

From: HuangC
Date: Sat, 22 Mar 2003 08:43

23 lines
1628 bytes

Hi all, I have selected some records and backup it to file,
now i load it to a dataset,
but how can query this dataset, the following is my code:
Save:
TADOQuery *AQNormal;
...
// the connected is correct
AQNormal->Close();
AQNormal->SQL->Clear();
// Select all the record that age is more than 20
// the Age is a field of my access database
AQNormal->SQL->Add("Select * form mytable where Age > 20");
AQNormal->Open();
AQNormal->SaveToFile("C:\\temp.dat");
...

Read:
AQNormal->LoadFromFile("C:\\temp.dat");
// now I want query the record that age is more than 50
// How can i do?
// Any hint? TIA!

Sky

Technical Details

Message-ID: <3e7c223d@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-09!supernews.com!newsfeed.gamma.ru!Gamma.RU!newsfeed.online.be!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,a73292e9d8e21483,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-03-22 00:55:41 PST
Reply-To: "HuangC" <akeehuang@163.net>
From: "HuangC" <akeehuang@163.net>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: How to Query in files
Date: Sat, 22 Mar 2003 16:43:37 +0800
Lines: 25
Organization: CK
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
NNTP-Posting-Host: 210.14.178.241
Message-ID: <3e7c223d@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1048322621 210.14.178.241 (22 Mar 2003 00:43:41 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-09!supernews.com!newsfeed.gamma.ru!Gamma.RU!newsfeed.online.be!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail