A question about TADOQuery(error occurs when the component ADOQuery returns an empty result)

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

Article #3708

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

#3708

From: Anffernee Hadaway
Date: Wed, 26 Jun 2002 05:40

17 lines
1630 bytes

Firstly, I should say that I am new to the ADO.
And I try to use ADOQuery do some SQL selections for me, it goes like the
following:
...
ADOQuery1->Close();
ADOQuery1->SQL->Text = "select * from extbl where field0 = ''"
ADOQuery1->Open();
ADOQuery1->Close();// the error occurs here.
ADOQuery1->SQL->Text = "select * from extble where field1 = ''"
ADOQuery1->Open();
...
----------------------------------------------------------------
And when there was no record matched the first SQL sentence, an exception
occured with message like "BOF or EOF is true, or current record has been
deleted..."

Please give me a hand, thanks.

Technical Details

Message-ID: <3d1953df_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!news3.cnt.ru!srcc!newsfeed.gamma.ru!Gamma.RU!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,f80d3ea637ab7626,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-06-25 23:05:57 PST
Reply-To: "Anffernee Hadaway" <anffernee@21cn.com>
From: "Anffernee Hadaway" <anffernee@21cn.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: A question about TADOQuery(error occurs when the component ADOQuery returns an empty result)
Date: Wed, 26 Jun 2002 13:40:46 +0800
Lines: 19
Organization: NMC
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 61.140.188.152
Message-ID: <3d1953df_2@dnews>
X-Trace: dnews 1025070047 61.140.188.152 (25 Jun 2002 22:40:47 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!news3.cnt.ru!srcc!newsfeed.gamma.ru!Gamma.RU!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews