>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