BorlandTalk.com Forum Index BorlandTalk.com
Borland discussion newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Open close Tado Query with msSql

 
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (ADO)
View previous topic :: View next topic  
Author Message
Stefan Tchigik
Guest
PostPosted: Fri Mar 05, 2004 10:40 am    Post subject: Open close Tado Query with msSql Reply with quote


Hello alls,

I developp an app with:
- Ms Sql 2000.
- TAdo components.
- Delphi 5.
- Windows XP Professional.

When I open and close a TadoQuery containing a single request like:
Select * from Table1.
When this request returns empty records I have an exception when each time I
close the TAdoQuery:
"BOF or EOF is equal to true, or the actual record have been deleted. The
requested operation needs a record".

This exception appends even if I'm in design mode (set active to true and
then set active to false).
I tries a lot of thing with the TADo components property without success.
Anybody have an idea ?

Thanks,


Back to top
Dan
Guest
PostPosted: Fri Mar 05, 2004 12:18 pm    Post subject: Re: Open close Tado Query with msSql Reply with quote


Try installing the Delphi 5 update pack 2, if you haven't already done so

http://info.borland.com/devsupport/delphi/mdac26.html

Cheers

Dan


"Stefan Tchigik" <mamouth3 (AT) libertysurf (DOT) fr> wrote

Quote:
Hello alls,

I developp an app with:
- Ms Sql 2000.
- TAdo components.
- Delphi 5.
- Windows XP Professional.

When I open and close a TadoQuery containing a single request like:
Select * from Table1.
When this request returns empty records I have an exception when each time
I
close the TAdoQuery:
"BOF or EOF is equal to true, or the actual record have been deleted. The
requested operation needs a record".

This exception appends even if I'm in design mode (set active to true and
then set active to false).
I tries a lot of thing with the TADo components property without success.
Anybody have an idea ?

Thanks,





Back to top
Stefan Tchigik
Guest
PostPosted: Fri Mar 05, 2004 2:05 pm    Post subject: Re: Open close Tado Query with msSql Reply with quote


Thanks a lot it's working fine now,
Have an happy good day, bye

"Dan" <x> a écrit dans le message de news:
404870a3$1 (AT) newsgroups (DOT) borland.com...
Quote:
Try installing the Delphi 5 update pack 2, if you haven't already done so

http://info.borland.com/devsupport/delphi/mdac26.html

Cheers

Dan


"Stefan Tchigik" <mamouth3 (AT) libertysurf (DOT) fr> wrote in message
news:404858f5 (AT) newsgroups (DOT) borland.com...
Hello alls,

I developp an app with:
- Ms Sql 2000.
- TAdo components.
- Delphi 5.
- Windows XP Professional.

When I open and close a TadoQuery containing a single request like:
Select * from Table1.
When this request returns empty records I have an exception when each
time
I
close the TAdoQuery:
"BOF or EOF is equal to true, or the actual record have been deleted.
The
requested operation needs a record".

This exception appends even if I'm in design mode (set active to true
and
then set active to false).
I tries a lot of thing with the TADo components property without
success.
Anybody have an idea ?

Thanks,







Back to top
Display posts from previous:   
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (ADO) All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.