Detect deleted records

[mohamad]

How do I detect deleted record when dataset(TMSQuery) in CachedUpdates mode?
Is it possible to identify the attributes(fields) deleted records?

[AlexP]

Hello,

To define the deleted record in the CachedUpdates mode, you can use the UpdateRecordTypes and UpdateStatus properties, for example:

Code: Select all

  MSQuery1.Delete;
  MSQuery1.UpdateRecordTypes := [rtDeleted, rtUnmodified];
  MSQuery1.First;
  while not MSQuery1.Eof do begin
    if MSQuery1.UpdateStatus = usDeleted then
      ShowMessage('Deleted');
    MSQuery1.Next;
  end;