dataset returned from Rawsql Plugin and getDataSetByQuery

Classic Servoy
1

Hello,

I am executing sql statements and procedure calls via the Rawsql plugin and the databaseManager.getDataSetByQuery.

The resulting dataset is limited to 1000 rows? Is this correct? Can we get a larger resultset back?

I am passing in -1 for maxnumberofrows parameter.

I have tested 5.1.4, 5.2.6, 6.0.2

sample:

var data_server=‘data’
var maxReturnedRows = -1
var query = ‘select * from (call AR_HISTORYINFOBYCUSTOMER(?))’
var args = new Array();
args[0] = ‘CUST01’
var dataset = databaseManager.getDataSetByQuery(data_server, query, args, maxReturnedRows);

2

Hello again,

I am replying to my own post due to the fact the queries do return all the results.

It it the debugger that limits the display to 1000 rows.

In Servoy 6.0 in the command console it limits to 100 rows, but dataset.getMaxRowIndex() shows a total over 3000.

All is good, in all versions.

thx
Lach