Row cannot be located for updating delphi ado dating a 25 year old

I have been getting this "Row cannot be located for updating" error for a long time.I tried hard to reproduce it to be able to track it but couldnt.You can get this message if another user changes the record you need to modify or if a field is modified by the database like when you use a trigger. COM When I want to Post I received often this Message Any idea Why ? Exception: ------------------------------------------------------------------------------------------------------------ 2.1 Date : Sat, -0400 2.2 Address: 4033E94C 2.3 Module : dbrtl702.4 Type : EDatabase Error 2.5 Message: Row cannot be located for updating. create view v Otbor WITH VIEW_METADATA as select p.*, act_date = act.date, act_nomer = act.nomer from pdoc p(nolock) left outer join pdoc act(nolock) on p.act_code = act.vcode where = '' ( ). it almost seems random, but happens when inserting or updating data.I always use an integer field with auto_increment even if I dont need it Please help R / / M "The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years.Always Run-time error '3197' The Microsoft Office Access database engine stopped the process because you and another user are attempting to change the same data at the same time. .update works fine when it runs for the first time. If you omit this, you'll just end up with updates really failing cause Access tried to exact-match floats, blob's and so on.

pf In Update: if true, this field is updated in UPDATE sql statements. So I set pf In Key and pf In Where to be true ONLY for the primary key. Post; sometimes I get that message but havent been able to reproduce it can happen also even if I am not updating via code but using a TDBEdit object to edit a database field and a TDBNavigator Post button to confirm update it seems to be something between the My SQL and Delphi The problem is possibly that the client code has no idea what the primary key value is after the insert, because it was allocated on the server side as an autoincrement.

In TAdoquery I query fields from clietmaster,companymaser. For instance, this happens after I have inserted a new record, saved it to the database and then try to edit it.

Some values may have been changed since it was last read. Sometimes editing my data in a grid, I get an error described above: "Row cannot be located for updating.

Daniel Fagnan When I want to Post I received often this Message Any idea Why ? Exception: -------------------------------------------------------------------------- ---------------------------------- 2.1 Date : Sat, -0400 2.2 Address: 4033E94C 2.3 Module : dbrtl702.4 Type : EDatabase Error 2.5 Message: Row cannot be located for updating.

Daniel Fagnan When you use clientside cursors ADO needs to be able to find the record you are editing in your database.

Leave a Reply