OpenDataSets

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
garry
Posts: 7
Joined: Mon 02 Nov 2009 13:24
Location: India
Contact:

OpenDataSets

Post by garry » Sat 10 Jul 2010 12:01

I am trying to use the Opendatasets with almost 25 Queries.

I hv following errors
"Object was open.
Cannot execute command in current transaction context until previous opened DataSet (CursorType is ctDefaultResultSet) is fetched to end"

and
"Query does not return next result set"

I guess these error are because of
"Note, that when this operation is performed, each one of the opened datasets should return only one resultset" as mentioned in help.

What is the meaning of "One Resultset"? I never use Go statement in my queries there is always a single Query without GO.

Can you please suggest me some workaround where i can optimise the time significantly at Remote connection.

Regards

garry
Posts: 7
Joined: Mon 02 Nov 2009 13:24
Location: India
Contact:

opendatasets

Post by garry » Mon 12 Jul 2010 10:40

ok
these errors gone when i used NonBlocking = False + latest Sdac version.

Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Mon 12 Jul 2010 11:39

You can not have several datasets underfetched if you do not use MARS.

Post Reply