Insufficient key column information for updating or refreshing

Cheers,

I have a view which joins 4 tables, and im doing insert/updates on just one
of the tables. 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).

what am i missing here?

TIA
Randy.


.

Relevant Pages

  • Re: Insufficient key column information for updating or refreshing
    ... >I have a view which joins 4 tables, and im doing insert/updates on just one ... >this, this seems to work for the insert but not on the updates, in delphi it ... but but when i do it on the sql query analyser it works ... Query Analyzer uses a serverside cursor. ...
    (borland.public.delphi.database.ado)
  • How to create a trigger to update another table?
    ... Hi All,How can i create something like a trigger or procedure when i insert ... a record in a table it updates a specific field of its parent record in the ... Prev by Date: ...
    (microsoft.public.access.formscoding)