Posted by: Jason Carter
CTD2005 PTF1/XP/SQL Server 2000
The following causes the above error:
SqlPrepareAndExecute( hSql, 'SELECT statement1')
SqlFetchNext( hSql, nReturn ) - no records exist
SqlPrepareAndExecute( hSql, 'SELECT statement2' )
While SqlFetchNext( hSql, nReturn ) - fails on second row
! do something
Using same cursor for both selects.