Servoy not looping through Cursors - Sql Server 2000

Classic Servoy
1

Servoy Developer
Version 3.5 rc3-build 508
Java version 1.6.0_01-b06 (Windows XP)
Sql Server 2000

I am having an issue with stored procedures. I am executing a stored procedure from databasemanager.executeStoredProcedure.
The stored procedure it executes uses a cursor to loop through another table and update it. In servoy the cursor is only executing one time and I only get the first row selected by the cursor to update. I can execute the procedure from SQL Query Analyzer and it will update all of the rows selected by the cursor. This is a major issue for our company and a show stopper for a project that I am about to release. Has anyone else had this issue?

2

I have seen this problem in all the previous versions

The problem is that servoy has sent to sql server a query like “SET ROWCOUNT 1” before you execute your stored procedure so your stored procedure will stop after one record.

just put SET ROWCOUNT 0 (to disable previous servoy query) at the top of your procedure.

3

That solved the issue. Thanks for the quick response…