Devart Forums

Update Failed, Found 2 Records.

Alway show the Error Message when the dataset in Edit model and after post,such as:

Try

MSQ.Edit;
MSQ.FieldByName('Fields1').asstring:='Some String';
...
MSQ.Post;

Except Showmessage('Some MSG');
end;

Sometimes,the data was post successed,but it still show the error message to me: " Update Failed, Found 2 Records. ".

My gOd...
wHat's WronG with my COde or mE ?

This error takes place when server is unable to determine what record to modify or delete. In other words, there are either many or no records that suit UPDATE criteria. Such situation can happen when you omit unique field in SELECT statement (TCustomDADataSet.SQL) or when another user modifies the table simultaneously. This exception can be suppressed. Please refer to TCustomMSDataSet.Options.StrictUpdate topic in SDAC help for more information.