Insufficient base table information for updating
Customers And then if you use INSTEAD-OF-Triggers together with your view you can even directly insert/update/delete data. Customers And then if you use INSTEAD-OF-Triggers together with your view you can even directly insert/update/delete data.
bye, Helmut Keith, I don't know if this will help or not but would the Update Criteria property help here? Just trying to help, brian -- Got a big event coming up? For more visit and of I fine my easily Thanks Brian. I was trying to avoid that because it means that I also have to run several lines of code to reposition the selected grid row and such on that grid and then on the 2 detail grids.
Both tables have primary, table A has one field primary key, but table B has 4 fields composite key. Too many rows were affected by update" The only way to recover (try except does not work), is to shut down the app and restart. I have a simple ADO Delphi app that reads one table record and splits it into two other tables. Then I get the following message: "Key column information in insufficient or incorrect.I only update one field of table B, should I update all the table B primary key, even I do not need update those fields? so i made a instead of trigger (insert/update) to accomplish this, this seems to work for the insert but not on the updates, in delphi it gives me this error, but but when i do it on the sql query analyser it works (updateing the view). The grid is not editable of course because the data source is too complex. There are a couple of instances on this form where I need to refresh the dataset.