getDataSetByQuery still limited to 1000 records?

Classic Servoy
1

I have read on this board that there used to be limits to the records returned when a SQL query is run using this method (200 and then it was raised to 1000).

Is the 1000 still a limitation in Servoy 3.5.2? If so, why? I am specifying my own max records returned and I expect the correct results, not something different. :shock:

I can not use the load records by query, as I need to select specific columns that are being loaded into a JGrid (dataset must contain only the columns I am loading into the JGrid).

2

Hi Gary,

can you show us your SQL-query?
Must be something in there.

3

I just wanted to confirm that 3.5.2 no longer has any limitations. I take it from your response that it no longer does and will always return the full dataset if maxReturnRows = -1.

4

yes indeed! :)