Devart Forums

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

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

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