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 

Cannot perform this operation on a closed dataset ?!

 
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> C++ Builder Databases (ADO)
View previous topic :: View next topic  
Author Message
Vladimir Stefanovic
Guest





PostPosted: Thu Feb 17, 2005 9:53 pm    Post subject: Cannot perform this operation on a closed dataset ?! Reply with quote



Hi,

There is a weird thing happened to me today with opening
ADO connections in the most simpliest example I have shown
in my previous post. I made many ADO programs so far and
never had such problem.

For example:

ADOConnection1->Connected = true;
ADOTable1->Open();
ADOTable2->Open();

if ( ADOTable1->Active )
{
ADOTable1->...do something ...
// Cannot perform this operation on a closed dataset ???!!!
}

That means ADOTable1 *is* active but system thinks it's closed!
When 'Active' is set at design-time everything went OK. Why?




Best regards,
Vladimir Stefanovic


Back to top
Viatcheslav V. Vassiliev
Guest





PostPosted: Sat Feb 19, 2005 2:36 pm    Post subject: Re: Cannot perform this operation on a closed dataset ?! Reply with quote



Completely rebuild your project, not just recompile. This could help.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Vladimir Stefanovic" <antivari (AT) po (DOT) sbb.co.yu> сообщил/сообщила в новостях
следующее: news:42151246 (AT) newsgroups (DOT) borland.com...
Quote:
Hi,

There is a weird thing happened to me today with opening
ADO connections in the most simpliest example I have shown
in my previous post. I made many ADO programs so far and
never had such problem.

For example:

ADOConnection1->Connected = true;
ADOTable1->Open();
ADOTable2->Open();

if ( ADOTable1->Active )
{
ADOTable1->...do something ...
// Cannot perform this operation on a closed dataset ???!!!
}

That means ADOTable1 *is* active but system thinks it's closed!
When 'Active' is set at design-time everything went OK. Why?




Best regards,
Vladimir Stefanovic




Back to top
Jochen Reichenberg
Guest





PostPosted: Tue Feb 22, 2005 8:40 am    Post subject: Re: Cannot perform this operation on a closed dataset ?! Reply with quote



Getting rid of the TADOTable components might solve your problems
AFAIK TADOTable is only for quick and dirty conversions of old applications
that used TTable. It should not be used in new projects.

"Vladimir Stefanovic" <antivari (AT) po (DOT) sbb.co.yu> schrieb im Newsbeitrag
news:42151246 (AT) newsgroups (DOT) borland.com...
Quote:
Hi,

There is a weird thing happened to me today with opening
ADO connections in the most simpliest example I have shown
in my previous post. I made many ADO programs so far and
never had such problem.

For example:

ADOConnection1->Connected = true;
ADOTable1->Open();
ADOTable2->Open();

if ( ADOTable1->Active )
{
ADOTable1->...do something ...
// Cannot perform this operation on a closed dataset ???!!!
}

That means ADOTable1 *is* active but system thinks it's closed!
When 'Active' is set at design-time everything went OK. Why?




Best regards,
Vladimir Stefanovic





Back to top
Display posts from previous:   
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> C++ Builder 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.