limit inserted to sql

[mkrellenstein]

Hello,

Using smart gwt pro

How do I stop a "limit" being inserted on my SQL associated with a listgrid? I tried using custom sql but the limit still gets inserted ...

Thanks,
Marc

[Isomorphic]

"limit" is not inserted for <customSQL> but will be inserted for clause-by-clause customizations.

To avoid it, you can set the operationBinding.sqlPaging to something other than "sqlLimit", or you can avoid startRow/endRow being sent in the request (such as by setting a grid's dataFetchMode to "basic".