Article View: borland.public.cppbuilder.database.ado
Article #2389Re: Either BOF or EOF is True, or the current record has been deleted...
From: Max Kielland
Date: Sun, 06 Jul 2003 20:01
Date: Sun, 06 Jul 2003 20:01
54 lines
2780 bytes
2780 bytes
Tanks a lot, it solved all my problems. How can I bee so stupid to not check for updates?!? // Max "sharon oknin" <sharon@benarit.com> wrote in message news:3f080e7f$1@newsgroups.borland.com... > You need to update bcb. > You can find it in http://info.borland.com/devsupport/bcppbuilder/patches/ > first install Update #1 and then 'BCB5ADOUpgrade1.exe' . > > sharon oknin > > > "Max Kielland" <max.kielland@swecoin.se> wrote in message > news:3f080d39@newsgroups.borland.com... > > Hi everyone, > > > > I'm using The C++ Builder 5 DAO Express and when I try to close an empty > > recordset I always get this error: "Either BOF or EOF is True, or the > > current record has been deleted..." > > > > this is my code: > > > > > > // Close the current recordset > > CD_DataModule->Result_ADODataSet->Active = false; > > > > // Set a new SQL Question > > CD_DataModule->Result_ADODataSet->CommandText = "SELECT SongNames.Name AS > > Expr1, Songs.Remix, Songs.Time, CDBase.SongID FROM (CDBase INNER JOIN > Songs > > ON CDBase.SongID = Songs.ID) INNER JOIN SongNames ON Songs.SongNameID = > > SongNames.ID WHERE CDBase.ArtistID="+String(ArtistID)+";"; > > > > // Open the new recordset > > CD_DataModule->Result_ADODataSet->Active = true; > > > > > > If the recordset is empty (RecordCount = 0) I always get the above error > > message when I try to close. I cant close the record set to set a new > Query. > > > > I did downloaded the MDAC 2.7 from the Microsoft site, but it didn't help. > > Ohh, I'm running Win XP Professional. > > > > Regards, > > Max Kielland > > > > > >
Technical Details
Message-ID:
<3f087f9b$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!cyclone.bc.net!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<3f080d39@newsgroups.borland.com> <3f080e7f$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,a197c87f332f929a,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-07-06 13:07:02 PST Reply-To: "Max Kielland" <max.kielland@swecoin.se> From: "Max Kielland" <max.kielland@swecoin.se> Newsgroups: borland.public.cppbuilder.database.ado References: <3f080d39@newsgroups.borland.com> <3f080e7f$1@newsgroups.borland.com> Subject: Re: Either BOF or EOF is True, or the current record has been deleted... Date: Sun, 6 Jul 2003 22:01:00 +0200 Lines: 56 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 NNTP-Posting-Host: 213.66.1.25 Message-ID: <3f087f9b$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1057521563 213.66.1.25 (6 Jul 2003 12:59:23 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!cyclone.bc.net!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail