Which events did you try? I have used RecordSet.FetchComplete() and it works fine. Here is a VB example,
Private Sub rsCustomer_FetchComplete(ByVal jError AS ADODB.Error,jStatus AS ADODB.EventStatusEnum,ByVal jRecordSet AS ADODB.Recordset)
if jStatus = adStatusOK then
Debug.Print "All Rows have been retrieved !!!"
end if
End Sub
>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
- Jayesh