Hello,

There is view which is selected from seven different tables, Now the application tries to update the views and it gets an error that Cannot Update Multiple Base tables, so we are trying to create a Instead of Update Trigger, which would update the multiple base table(3 tables involoved). The application uses RDO and issues an edit statement to retrieve information about the table(view) and then it modifies the information and issues a save statement. the update is assigned the values by parameters

eg: exec sp_executesql N'update [Act_Sync] SET COMPANYNAME=@P1 , MIDDLEINITIAL=@P2 , LASTNAME=@P3
WHERE "RADIO" = @P4 AND "COUNTRY" IS NULL AND "PHONE2EXT" = @P5
Act_SYNC is the view
I'm not getting a good example of update triggers
and how would I assign the parameters to update statements

Thanks