problem with smartfetch and order by

pincopallino · Post by **pincopallino** » Tue 30 Dec 2014 13:19

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.

AlexP · Post by **AlexP** » Tue 30 Dec 2014 15:05

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.

pincopallino · Post by **pincopallino** » Wed 31 Dec 2014 12:20

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

AlexP · Post by **AlexP** » Sun 04 Jan 2015 07:31

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

Devart Forums

problem with smartfetch and order by

problem with smartfetch and order by

Re: problem with smartfetch and order by

Re: problem with smartfetch and order by

Re: problem with smartfetch and order by