ClientDataSet wrong order results |
|
I have a Datasnap server application to read from an MySql database and
I have a Firemonkey App (ios and android) that connects to that datasnap app server.
I'm using a a TDSProviderConnection, a SQLConnection (TDSProviderConnection is linked to this SQLConnection) and a ClientDataSet
that is linked to the TDSProviderConnection component. The ClientDataSet ProviderName property is linked to the server DataSetProvider.
So the problem is that when, from client side, I do a SELECT statetment to oder by an alphanumeric column that contains record in lower and upper case,
the result set of the ClientDataSet is not correct.
For instance if I have this records and when I do a select like SELECT COLUMN FROM TABLE ORDER BY COLUMN:
ARS
Academia
ANABELA
Agromax
The Result is:
ANABELA
ARS
Academia
Agromax
And it result shoud be:
Academia
Agromax
ANABELA
ARS
If I run the application on windows the result set will be ok, but bot on IOS.
I can I solve this?
Thanks
|