ADO Sort error

[AHF]

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?

[Rick Lipkin]

Antonio

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

Code: Select all  Expand view

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

Rick Lipkin

[nageswaragunupudi]

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

[AHF]

Thanks!