row cannot be located for updating. some values have been change....

[parv2k]

hi guys,

i'm really stuck the following problem "row cannot be located for updating. some values have been change since it was last read"

the detail is as follow

i have two table, one got part no and name and 2nd one got reorder level, max level

on table 1 i wrote the query like select * from item where name<>'' (i'm using ADO Query)

and table 2 named level is tado table...which got datasource of above said query and linked on partno.

there is situation where in item table there are 1000 record and level table got 500....so i show the grid (which filled from query) and also show on the screen two dbedit field link to level table....so when user scroll thru the grid it show the level again the item in dbedit field.

i also put button, like add, edit and save, so if someone want to change the level of a item, it click edit button and change the value dbedit field....and once done, click save button, now in some cases i get the above message...sometime i edit or add new in level table...things work fine.

can someone help on it? I'm stuck wiht it and unable to find out the solution. it is very simpel master detail form.

thanks in advance.

 

[strucnjak79]

I can't realy help you but I can say I had same problem when I used a DataSet, no such problems with TTable in my case... Maby you should try!

 

[strucnjak79]

sorry, my bad, I had problems when I was using ADOQuery, no problems with ADOTable...

 

[parv2k]

hi guys,

thanks for reply but i thnk i found the solution. it happen in case of update and if you set parametere update criteria to update key, it will solve the problem. actually by default ado use different method to update the table (when you use client side cursor)

it looks like changing update criteria propery to update key
solve the problem. i tested on few tables but will see if it work fine all the time.

thanks