Row cannot be located for updating delphi
This sample chapter from David Sceppa's "Programming ADO" book will help youunderstand why the error can occur: MVP - ASP/ASP. This email account is my spam trap so Idon't check it very often.If you must reply off-line, then remove the"NO SPAM"Selstar is not a good programming practice. Cursor Location = ad Use Client "Select * from inv_inv where inv ID = p_inv ID, my CN, ad Open Static, ad Lock Optimistic rs! I have read some stuff about this happening when a table does not have a primary key etc. rs.update rs.close set rs = nothing Can anyone offer any suggestions as to why this is happening?
In general, if you are opening acursor, making immediate modifications and closing the cursor, you mightas well use either a server or client-side static cursor, or use SQL DML(preferably in a stored procedure) to make the changes.
These issues are onesyou would need tohandle yourself if you resorted to a stored procedure. No, I mean you need to keep track of the state of the field values whenthey were originally retrieved and before performing the update, comparethem to the current field values to see if they've changed in themeantime.--Microsoft MVP -- ASP/ASP. The email account listed in my Fromheader is my spam trap, so I don't check it very often.
You will get aquicker response by posting to the newsgroup.
That chapter Ilinked to also covers this topic.--Microsoft MVP -- ASP/ASP. The email account listed in my Fromheader is my spam trap, so I don't check it very often.
You will get aquicker response by posting to the newsgroup. I have changed the query to explicitly naming the columns in the selectclause. The error that I got is causeed because in between executing the query"select [Order], Status, Price, Location from my Table where [order] = '" &(s Order) & "' and calling the .I am using Lock Typead Lock Optimistic and cursor Type ad Open Keyset. The table it tries to update has an Identity column. This is usually due to a lack of a primary key on the table.