Running Stored Procedure without parameters

Classic Servoy
1

I’m having trouble getting my head around the syntax of running a stored procedure and getting that dataset in servoy.

Tha database is sql server 2000

The stored procedure returns the whole dataset so there are no input parameters.

I then want to loop through the whole dataset with all the fields.

I have been trying various permutations without success.

Can anyone suggest the correct syntax?

Thanks

2

All I want is to run a stored procedure without any parameters.

it cant be that difficult surely?

3

try “move sample code” on databaseManager.executeStoredProcedure and see for yourself

4

Hi jan,

I dont have problems with stored procedures with parameters, I have them working fine.

I have looked at the code and searched forum etc.

all i want to do is run a procedure called spjob to get a dataset.

As a registered user I have emailed your support as well.

Thanks

5

if your stored procedure returns something you can use it like:
var dataset = databaseManager.executeStoredProcedure(…)
//see dataset obj methods for handling dataset.

this is also in the sample code, not exactly sure if I fully understand your question