I am using NOCOUNT because of multiple "Select"s!

Example:

Code:
          Handle hoConnection hoStmt
          String[][] sQueryData
          String[][] sQueryData2
          Integer iNextSet      
              
          Get SQLConnectionId of ghoConnection "CCWSA" to hoConnection
              
          Get SQLOpen of hoConnection to hoStmt 
//          Send SQLExecDirect of hoStmt "Select Count(*) from Tempcc; Delete from Tempcc; Select @@ROWCOUNT;"  // Generates "Invalid Cursor State" on Fetching Next Result Set
//          Send SQLExecDirect of hoStmt "Set NOCOUNT ON; Select Count(*) from Tempcc; Delete from Tempcc; Select @@ROWCOUNT;"  // Locks Up on Saverecord
          Send SQLExecDirect of hoStmt "Set NOCOUNT ON; Select Count(*) from Tempcc; Delete from Tempcc; Select @@ROWCOUNT; Set NOCOUNT OFF;"  // Works Fine!!

          Get SQLFetchResultsetValues of hoStmt to sQueryData

          Get SQLNextResultSet of hoStmt to iNextSet
          If (iNextSet > 0) Begin
             Get SQLFetchResultsetValues of hoStmt to sQueryData2
          End
                    
          Send SQLClose of hoStmt
          Send SQLDisconnect of hoConnection
          
          Open Tempcc          
          Clear Tempcc
          Move "Test" to TEMPCC.ACC_NUMBER
          SaveRecord Tempcc  // Locks Up here