Text; //additional fields here Post; end; end; end; procedure Tfrm Edit Click(Sender: TObject); begin with frm Coin, tbl Main do begin if Show Modal = mr OK then begin Edit; Field By Name('Title')String:= edt Title. If yes, set the Cursor Location=cl Use Server With best regards, Mike Shkolnik Mike, That works..only if I comment this line out //tbl Main.
Text; //additional fields here Post; end; end; end; Sorry, this is the code for the add procedure procedure Tfrm Add Click(Sender: TObject); begin //************************* with frm Coin, tbl Main do //************************* begin if Show Modal = mr OK then begin Insert; Field By Name('Title')String:= edt Title. Sort := 'Title, Year, Version, Finish'; using sort and or Index Field Names to sort the table, wont work on Server Side Cursors Anyway to sort my table in my grid using your suggestion? procedure Tfrm Main After Open(Data Set: TData Set); begin tbl Main.
This happens because ADO needs to find the record you are editing in your database to make a change to it.
If it can't find the record this error is generated.
Any server-side locks or cursor features used to create the recordset are freed up immediately.
I get this error message "Row cannot be located for updating.
Some values may have been changed since it was last read." When I add a record, Copy a record, Then edit the record.
I'm going to present only what happens with client-side cursors, such as when Cursor Location is set to ad Use Client, because the server-side mechanism varies from provider to provider.
The client-side mechanism, however, requires only that the database supports SQL.
In this article I'll explain how ADO's client cursor service generates SQL statements for recordset updatesnot just for the usual "SELECT * FROM authors" query, but for real-life scenarios involving joins and common cases where you retrieve only columns from a table, rather than all (*) of them.