Data Corrupt/Error in TMSQuery

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Gerrit Knoetze
Posts: 1
Joined: Wed 10 Sep 2008 12:26

Data Corrupt/Error in TMSQuery

Post by Gerrit Knoetze » Wed 10 Sep 2008 12:52

Hi, I am having problems with TMSQuery objects. The errors and problems indicated in the topic - Data shifted in TMSQuery, describes my exact problem.
Data corruption when record is edited in only 1 field and error when applyupdate is done on the query. AddRefStr failed (D:\Projects\Delphi\Dac\Source\MemData.pas, line 7538).

Using Delphi 7 with SDAC version. for Delphi 7

Little detail of my project:
Quote system where a user edits the quote, quote line items are added (all fine) and when the user edits 1 of the line items the “product code” field gets corrupted.

CachedUpdates are used for Quote query and QuoteItems query with SQL Master/Details link. When saved the Quotes and QuoteItems gets posted using ApplyUpdates. O yes and GUID’s are used for unique id’s.

Any ideas why this is happening with this version?

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

Post by Dimon » Thu 11 Sep 2008 08:12

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

Post Reply