topic-30779

Posts: 838

Joined: Fri Feb 10, 2006 12:14 PM

ADO Sort error
Posted: Thu May 28, 2015 03:24 PM

I using ors:sort := "field1,field2" but I get a error.

DB Mysql CursorLocation = adUseClient.

Does anyone knows what might be the cause and how to solve it?

Regards

Antonio H Ferreira

Posts: 2706

Joined: Fri Oct 07, 2005 01:50 PM

Re: ADO Sort error
Posted: Fri May 29, 2015 12:45 PM

Antonio

I always put my sort values as parameters within parenthesis .. Try it this way:

oRs:sort( "[field1],[field2]" )

Rick Lipkin

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: ADO Sort error
Posted: Sat May 30, 2015 04:59 PM

oRs:Sort := "field1,field2" is perfectly valid.
But oRs:Sort works only on client side recordsets

Regards

G. N. Rao.

Hyderabad, India

Posts: 838

Joined: Fri Feb 10, 2006 12:14 PM

Re: ADO Sort error
Posted: Mon Jun 01, 2015 05:52 PM

Thanks!

Regards

Antonio H Ferreira

FiveTech Support Forums