Delphi dbgrid row cannot be located for updating
Delphi offers a native solution: The TClient Data Set component -- located on the "Data Access" tab of the component palette -- represents an in-memory database-independent dataset.
I understand that ADO match the "before edit field values" before updating the database.
I have a Strange problem : In my database (SQL 2000), I have a simple View : CREATE VIEW dbo.
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.
For example, the Join Data example is built around an ADODataset component that uses the previous SQL join.
If you run it, you can edit one of the fields and save the changes (by moving off the record).