isaka
asked on
ADOTable erro message: The specified row could not be located for updating; Some values may have been changed since it was last read.
Hi there,
I'm working with ADO tables, and when I update the row, I get a message:
The specified row could not be located for updating; Some values may have been changed since it was last read.
I readed some "help" for the same problem at Visual Basic and how to solve it with Resync method, but the same method I can't call on Delphi.
Thanks
I'm working with ADO tables, and when I update the row, I get a message:
The specified row could not be located for updating; Some values may have been changed since it was last read.
I readed some "help" for the same problem at Visual Basic and how to solve it with Resync method, but the same method I can't call on Delphi.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Adjusted points from 100 to 150
ASKER
If I use the bookmark than I have very ofen message that the bookmark is invalid.
Any suggestions?
Any suggestions?
I take it another user hasn't updated the record?
Do you move off the record in any way from any other event?
Do you move off the record in any way from any other event?
Try This:
procedure TForm1.ADOTable1AfterPost
DataSet: TDataSet);
begin
TCustomAdoDataSet(dataset)
end;
This will stop your error, however the downside is that the current record is reset to the first record. Solve that by using bookmarks etc and logic that is particular to your app.