Geneve chatsex grautuit - Row cannot be located for updating delphi
I am only modify the table by using the Data controls. Trey, You may want to read these to understand the essence of the problem: And you might want to download this for an easy Delphi solution: news:[email protected] (TBetter ADOData Set) HTH -- Vassil Nazarov IT Manager, Sofia Cable SA For some information on how ADO works, take a look at some sample chapters of this nice book Programming ADO by David Sceppa. -- Sunil Furtado New Mangalore Port Trust As has been explained in this forum ad nauseum, the default value is the problem. I looked for your article on Tamarak and Deja News but could not find it.I do not have a single line of code that I have written in this test. It invalidates the WHERE clause of the action query ADO generates to implement your updates. Trey Weaver I have not seen any message where the problem with default fields has been explained well.The bottom line is that ADO implements updates by action queries it generates both from data in the row and the dataset's metadata it gathers from the OLE DB Provider.
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.
I'm sometimes surprised by their reaction to that question.
The most common response is, "Why should I care what ADO is doing? In Xbase, it's easy to tell that the record you're accessing programmatically is the actual record in the actual table in the actual database file. The Jet engine keeps its own copy of the results of your query.
This error can also occur if the table lacks a primary key or a unique index, or if there is an optimistic update conflict.