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


Hope you can help

Regards
Steven