🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: ADO Express Problem

#5965
From: Paul Machiaverna
Date: Mon, 04 Dec 2000 14:48
78 lines
2934 bytes
Ivan:
CodeCentral is in a limited access mode until tomorrow.  I'll check it out
then.
Thanks, Paul

"Ivan" <iradev@mail.vega.bg> wrote in message
news:90bt0q$a317@bornews.inprise.com...
> Hi Paul,
>
> This is a bug of ADO Express.
> There is a patch for ADO Express in CodeCentral  that fixses this one and
> some other
> bugs.
>
> Ivan
>
>
>
> "Paul Machiaverna" <machiave@i-stat.com> wrote in message
> news:908fug$apf7@bornews.inprise.com...
> > In testing the performance of Borland ADOExpress for C++ Builder 5, I
> wrote
> > a simple test application.
> >
> > An ADO object point is declared:
> >
> > TADOQuery* iptQuery;
> >
> > After it is created and the connection to the database is made, the
> > following code is executed:
> >
> > try
> > {
> >     // Perform the query.
> >     iptQuery->Close();
> >     iptQuery->SQL->Clear();
> >     iptQuery->SQL->Add( "SELECT KeyValue FROM TestRecord" );
> >     iptQuery->Prepared = true;
> >     iptQuery->Open();
> >
> >     // While there are records to process,
> >     while ( !iptQuery->Eof )
> >     {
> >         // Get the data and display it.
> >         liData = iptQuery->FieldByName( "KeyValue" )->AsInteger;
> >         MemoDisplay->Lines->Add( IntToStr( liData ) );
> >
> >         // Go to the next record.
> >         iptQuery->Next();
> >     }
> > }
> > catch( Exception& E )
> > {
> >     ShowMessage( E.Message );
> > }
> >
> > // Close the query.
> > iptQuery->Close();
> >
> >
> > This all works fine until it hits the last line (iptQuery->Close()).
> That's
> > when an exception is throw and it reports:
> >
> > "Either BOF or EOF is True, or the current record has been deleted.
> > Requested operation requires a current record."
> >
> > Why does this happen?  Is there a way to suppress this?  Since I just
want
> > to simply close the query, I really don't want an exception thrown and
> > displayed.
> >
> > Paul
> >
> >
> >
>
>
Technical Details
Message-ID: <90gari$46p6@bornews.inprise.com>
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!xfer13.netnews.com!netnews.com!newspeer1.nac.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!not-for-mail
References: <908fug$apf7@bornews.inprise.com> <90bt0q$a317@bornews.inprise.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,6b9268797125d6bc
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2000-12-04 06:49:26 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!xfer13.netnews.com!netnews.com!newspeer1.nac.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!not-for-mail
From: "Paul Machiaverna" <machiave@i-stat.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: ADO Express Problem
Date: Mon, 4 Dec 2000 09:48:08 -0500
Organization: i-STAT Corporation
Lines: 80
Message-ID: <90gari$46p6@bornews.inprise.com>
References: <908fug$apf7@bornews.inprise.com> <90bt0q$a317@bornews.inprise.com>
Reply-To: "Paul Machiaverna" <machiave@i-stat.com>
NNTP-Posting-Host: ftp.i-stat.com
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400