please help with strange error message

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
lifeform
Posts: 21
Joined: Wed 02 Jan 2008 05:34

please help with strange error message

Post by lifeform » Sat 31 Jan 2009 12:35

hello,
i have an error "Connection is busy with results for another command"
i do not know where is the wrong with my code. cause i have parent object for this update process. this is message show just for 1 child. i have 5 different child for this process.
the another strange is, it show up when update only. the process update just update table set blabla blaabl where id = @id
i use cache update and updateSQL to prepare it

what is the meaning of that message? please describe briefly...
i have difficulty to find the source of error :(

i use SDAC version 4.50.39 and delphi 2007 december update

please help me for the strange that i do not understand.
thx before

lifeform
Posts: 21
Joined: Wed 02 Jan 2008 05:34

SOLVED but maybe it's a bug

Post by lifeform » Sun 01 Feb 2009 05:36

Hello, sorry but i have found the error. strange but it's work
the error occur cause of i set fetch all to false. when the query run in the server, the component access with the other connection that is not connection that establish with tMSConnection. i do not know how it;s happened but when i set it to true the problem solved. may be it's a bug or maybe this is the SDAC behavior...
if you understand the SDAC source please explain this problem thx

Dimon
Devart Team
Posts: 2888
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Mon 02 Feb 2009 12:25

You can find detailed information on this problem in the description to the TCustomMSDataSet.FetchAll property of SDAC Help.

Post Reply