🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Either BOF or EOF is True, or the current record has been deleted...

#2389
From: Max Kielland
Date: Sun, 06 Jul 2003 20:01
54 lines
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-mail
References: <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