Dbgrid row cannot be located for updating
rs.update rs.close set rs = nothing Can anyone offer any suggestions as to why this is happening?
If valuein Planifie or record 5 has changed, then i am right.bye, Helmut Post by Christian Dubois I am using a client-side cursors and I cannot use a server side cursor.Hi, I am getting this error message in VB6 with My SQL 4.1. Most of the rows update fine but some give the error below. The table has a field called inv ID that is defined as the primary key and is of the type int(11). Some values may have been changed since it was last read. View_Estim Prod ASSELECT *,(SELECT SUM(Cmd Sous Total) FROM cmd WITH (NOLOCK) WHERE Cmd Type = 20 And Cmd Date Livraison Estim Prod. Estim Prod Here is an example of the result Esp UID Esp Date Fin Esp Prod Max Planifie4 2006-03-24 300000 518169,3555 2006-03-31 30000 386288,926 2006-04-07 300000 472065,177 2006-04-14 30000 486509,3625When I am updating this View (I want to change Esp Prod Max), I am obtainingthe error message (related in the topic) for records 5 and 7. I tried to Add a trigger (instead of update) to avoid updating the aggregatefield Planifie : no change. I am Using Delphi 7 with a TADOData Set component with SQL 2000. see my reply to the post of Dan R made on the 21st April regarding "MSAccess boolean fields"--Best regards :)Guillem Vicens Meier Dep. clubgreenoasis.com--Contribute to the Indy Docs project: order to contact me remove the -nospam I am using a client-side cursors and I cannot use a server side cursor.I tried to change my dataset's properties ['Update Criteria']. I understand that ADO match the "before edit field values" before updatingthe database.