Major Issue with Clientdataset

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
krimson
Posts: 13
Joined: Sun 24 Sep 2006 08:56

Major Issue with Clientdataset

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
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

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
Posts: 13
Joined: Sun 24 Sep 2006 08:56

Post by krimson » Fri 13 Feb 2009 17:50

I have sent you a sample program!

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 17 Feb 2009 12:50

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

Post Reply