PB10 / SQL Server 2005 Standard. I'm trying to execute a embedded SQL statement INSERT INTO ..... and I get the error
"connection is busy with results for another hstmt"
The SQL that is erring is inside a Cursor Loop. I changed the SQL to a simple UPDATE of the same table no error. I changed to an INSERT INTO that was using a different table and the error returned. I have found many references and fixes in Google but most pertain to stored procedures and/or SLQ Server 2000.
"connection is busy with results for another hstmt"
The SQL that is erring is inside a Cursor Loop. I changed the SQL to a simple UPDATE of the same table no error. I changed to an INSERT INTO that was using a different table and the error returned. I have found many references and fixes in Google but most pertain to stored procedures and/or SLQ Server 2000.