Major Issue with Clientdataset

krimson · Post by **krimson** » Wed 11 Feb 2009 20:20

Hello,

After upgrading from 4.3 to 4.7 my applications experience problems while retrieving data using TMSQuery combined with TClientdataset!

In a sample database the following occurs:

- Running the TMSQuery retrieves 3000 records
- Running the Clientdataset which is connected through a dataprovider to the same TMSQuery only returns 2 records!!!!

In 4.3.x this worked as it should and returned the equal amount of records in both situations.

Please advise in case any settings should be altered. In case this is a BUG, will you provide a fix asap?!

Regards,

M. van Rijn

Dimon · Post by **Dimon** » Thu 12 Feb 2009 09:56

I can not reproduce the problem. Please try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.

krimson · Post by **krimson** » Fri 13 Feb 2009 17:50

I have sent you a sample program!

Dimon · Post by **Dimon** » Tue 17 Feb 2009 12:50

In order to solve this problem you should include the poRetainServerOrder option into TDataSetProvider.Options.