ClientDataset reordens table from Datasetprovider in datasnap,on strings that starts with '

Question

On my Datasnap server I query some records and order them by a stringfield. Strings that start with ' are in front, this is default behaviour. (the database is interbase)

'Aaa
'Bbb
Aaa
Bbb

When i use a tClientdataset and a TDSProviderConnection on the client and connect to the TSQLDataset trough a TDatasetProvider the table on the client looks like this:

'Aaa
aaa
'Bbb
bbb

How to stop this? I am sure the order is correct in the TSQLdataset on the server.

score 3 · Accepted Answer · answered Mar 25 '13 at 09:46

3

I found the answer right after posting, but ill leave it here.

It is an option of the TDatasetProvider

poRetainServerOrder : True

very strange that this is not the default behaviour.

answered Mar 25 '13 at 09:46

r_j

1,348
15
35

ClientDataset reordens table from Datasetprovider in datasnap,on strings that starts with '

1 Answers1