Insufficient key column information for updating dating agency brighton uk
I am not sure if this helps, but try to build your view with option WITH VIEW_METADATA, for example: CREATE VIEW All Customers WITH VIEW_METADATA AS SELECT * FROM dbo. Keith I am not sure if this helps, but try to build your view with option WITH VIEW_METADATA, for example: CREATE VIEW All Customers WITH VIEW_METADATA AS SELECT * FROM dbo. 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. If that does not help, remove the trigger and run the update again. Edit; Now edit the Client registrer Post the register with the command: ADOTable1. -- Erland Sommarskog, SQL Server MVP, so****@Books Online for SQL Server SP3 at Leonardo, Your trigger doesn't look correct to me! In order to update Contratos table using new values in Clients, you need to use inserted table not Clients. ID_Client In your current trigger, you are dealing with 3 tables (Contratos, Clients & inserted) without joining them correctly. Good Luck, Shervin Leonardo Almeida This is the case....I would expect in such case that you get the error anyway. *** Sent via Developersdex Don't just participate in USENET..rewarded for it! The SET NOCOUNT ON command should be added to your trigger. Something like this: create trigger Update_Clients on Clients for update as update Contratos set Client = inserted. So when you try to update Client field of Contratos table, it finds more than one value in inserted table which causes that problem. I would like to learn the statement that make the relation between these tables. Cos these are separated in two different databases and if a user make an update in a table from database X these changes must to be applied in the other table in the another database: The tables are : Principal Database Name : Server Information 2004 Table Name : Clients Fields : ID_Client, Client Secondary Database Name : Index2003 Table Name : Contratos Fields : ID_Con, ID_Client, Client I need to write a Trigger for Update the table Contratos everytime a user change the values in Clients.The tables are as such; Appts Appts Index int NOT_NULL IDENTITY PRIMARY KEY .... Emp Appts Emp Appts Index int NOT_NULL IDENTITY PRIMARY KEY Appts Index int NOT_NULL The relationship I created was; Appts. This is the code for the stored procedure that gets called to supply the recordset.
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. Joost what is this error on ADO Query when I try to refresh... "Insufficient base table information for updating or refre" Ado Query: object q Campanha: TADOQuery Connection = dm Wytron Dir Cursor Type = ct Static Param Check = False Parameters = 0' ' ') Left = 176 Top = 208 end ADO Connection: object cnt Wytron Dir: TADOConnection Connected = True Connection String = 'Provider=MSDASQL.1; Password=Dragon Ball65; Persist Security Info=T' 'rue; Data Source=Camp Atual' Login Prompt = False Mode = cm Read Write Left = 16 Top = 20 end Could somebody help me again? PP Hi, I think I am dealing with a bug in the ADO technology. I have two tables using a join that return the result set I want of appts to be displayed in a calendar. Appt Index Whenever I try to delete an appt from the Appts table I get the infamous, "Insufficient key column information for updating or deleting".
If I'm only updating existing rows (no deletes or inserts), I usually prefer to use Refresh when I can.