hello

i am using a view to view/edit data in a datagrid in vb.

because the view is made up of more than one table, i am using an INSTEAD OF UPDATE trigger on my view, to update the table i want to update. Which is working great, But i get an error when i try to delete a record. I know that I can write an INSTEAD OF DELETE trigger, but can a view have more than one trigger?

for instance, if I needed to append, update and delete using this view, would I have to write a trigger, so that would be three in total, or could i use one trigger to do it all? and if I could use one trigger, how could i make it see which action it needs to perform, ie add, update, delete?

I would be grateful for any answers, or any links to information on the net, I've been surfing for this for the past few days, and cant find a page that deals with all three eventualities. Many Thanks, Debbie

I'm pretty sure you can have multiple triggers fire on the same view. you can absolutely do it on a table. A potential problem there is that you can't specify which order the triggers fire in when you have more than one. However if you specify one On Insert, one On Update, and one On Delete trigger you won't have this problem as different events will fire each one.

In your case you should be able to write an additional instead of trigger for Deletes that will fire only when you delete a row from the view.

Great, Thank You