Problems with SDAC ver 4.50 and above

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
matjazu
Posts: 4
Joined: Fri 18 Mar 2005 10:53

Problems with SDAC ver 4.50 and above

Post by matjazu » Fri 06 Feb 2009 09:41

Hi,

I have a DataSnap application (using RemObjects) that uses TMSQuery components on server and TClientDataSet on the client. I didn't have any problem with application when using SDAC 4.30 version (Delphi 2007). When I have upgraded to 4.70 version one of more complex querys is returning only first record to client data set. The query on server is working ok, for example TMSQuery record count shows 50 record, but client data set record count is 1. The same problem is with version 4.50, only 4.30 works fine. One more thing: when I set TMSQuery.ReadOnly = True, then everything works fine with versions 4.50 and 4.70.

Any ideas which changes in newer versions could produce this behaviour.

Thanks, Matjaz

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

Post by Dimon » Fri 06 Feb 2009 12:00

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

Post Reply