Page 1 of 1

Major Issue with Clientdataset

Posted: Wed 11 Feb 2009 20:20
by krimson
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

Posted: Thu 12 Feb 2009 09:56
by Dimon
I can not reproduce the problem. Please try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.

Posted: Fri 13 Feb 2009 17:50
by krimson
I have sent you a sample program!

Posted: Tue 17 Feb 2009 12:50
by Dimon
In order to solve this problem you should include the poRetainServerOrder option into TDataSetProvider.Options.