Devart Forums

Hi,
I have a query with a parameter. For a mistake I enabled the SmartFetch and from that moment I was not able to change the order of records (by clicking in the CRGrid or by code).
Found that the parameter value was appended at end of SQL text and for this tha server reported an error.
After disabling SmartFetch the program returned to work correctly.

Hello,

Yes, this is a restriction on using the SmartFetch mode. You can't change sort order in this mode. Sorting is available only when the LiveBlock option is disabled.

Thanks!
I need to better read the documentation...

You are welcome. Feel free to contact us if you have any further questions.