Data Corrupt/Error in TMSQuery

Gerrit Knoetze · 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.4.35.1.15 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?

Dimon · 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.