Data Corrupt/Error in TMSQuery
Posted: 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?
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?