help, demo tomorrow, questions piling up....

Classic Servoy
1

Why, o why, does the INT field numchildren result in the proper integer in the below but not in the second snippet of code below? It’s not the stored procedure – it’s working fine and results in data. Debugger shows the step going by with nothing set in numchildren in the second one, but works perfectly (debugger or no) in the first one:

forms.BudgetCostMgmt.controller.deleteAllRecords()
var maxReturnedRows = 20
var procedure_declaration = '{call ud_BudgetSelect()}'
var args = new Array()
var typesArray = new Array()
var dataset = databaseManager.executeStoredProcedure(controller.getServerName(), procedure_declaration, args, typesArray,maxReturnedRows);
var z = controller.getSelectedIndex()
numchildren = dataset.getMaxRowIndex();

But not here:

var maxReturnedRows = 1000;
var procedure_declaration = '{call ud_BudgetLineSelect(?,?)}';
var args = new Array(2); 
args[0] = globals.gProject;
args[1] = globals.gTier1ID;
var directionArray = new Array(2);
directionArray[0]=0;
directionArray[1]=0;
var dataset = databaseManager.executeStoredProcedure(controller.getServerName(), procedure_declaration, args, directionArray, maxReturnedRows);
var z = controller.getSelectedIndex()
numchildren = dataset.getMaxRowIndex();

It’s not the stored procedure calls, they’re working perfectly. Successful rowsets and no errors.

2

if you really add things like:

application.output(dataset.getMaxRowIndex());
and
application.output(numchildren);

as last 2 lines
does it print those lines? And what does it print?