Row cannot be located for updating some values delphi Cam free feet chat no log n
I'm stuck wiht it and unable to find out the solution.it is very simpel master detail form.thanks in advance.Does anybody have a clue of why this is happening and how it can be easily solved ?Is this a setting or any option in the TADOConnection ?The error occurs will editing a record in a grid , if the user creates a new record moves onto the next record and at some point decides to come back the the first record , if any values are changed on the post the user will recive a error "Row cannot be located for updating , some values may have changed" .The strange thing is this only happens on the two users machines , if they log onto another machine with there username & password they dont recieve this error .Looking at the inserting process a bit closer My auto increment field "REP_ID" next value should be 55435 .After my post of the new record , if i evalute the datasets "REP_ID" value it is 6467 but looking at the database tables - it shows the "actual" 55435 . Our Application is writen in Delphi and we use a ADO connection with ADOQuerys , i Have tried setting the ADOQuery's "Properties['Update Criteria'].value :=ad Criteria Key" .
some values have been change since it was last read"the detail is as followi have two table, one got part no and name and 2nd one got reorder level, max levelon 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...i show the grid (which filled from query) and also show on the screen two dbedit field link to level table...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...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 someone help on it?
I had a similar problem - Updating a row where all values were the same would result in the error you're getting. my tables were tbl_Floor,tbl_Floor Parts,tbl_Seat which tbl_Floor was master of tbl_Floor Parts and tbl_Floor Parts was master of tbl_Seat.
I added the flag "Option=2" to the end of my ado connection and this fixed the issue.
Despite the usual minor errors in the code which occur with any new software, the system is solid, effective, and meets the business objectives---were it not for his error.
The error occurs in different modules at different times.
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 keysolve the problem.