General information
Category:
COM/DCOM and OLE Automation
>Hi
>
>I have created an application which builds a SQL statement which firstly creates a temp table, then iterates through the temp table, calling a stored proc for each record in the temp table.
>
>This SQL statement is then passed to a Sybase server via ADO.
>
>If I run this sq. statement in an application like DBArtisan the code works well and finishes.
>
>When I run it via ADO.. and then try to execute another SQL statement I get the following error
>
>"This routine can only be called if the command structure is idle"
>
>I know that I am getting this error because me first SQL statement has not finished, so really I am asking is there a way to check that the command structure is busy ?
>
>I have tried to use the ado with events, but this does not work
Check out the State property of Command or Recordet objects. When command is still executing, the adStateExecuting flag will be set.
Alexander
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only