Triggers "instead of" for View with "joins"
Sorry for the next message, but my problem was with Oracle -> MySQL and wasn't SQL server to MYSQL:
Hi! I'm trying to insert into view but this view is made of "join":
return the error:
"Cannot insert into join view 'v12.vista1' without fields list"
The solution for this problems is using trigger "INSTEAD OF" but in MySQL doesn't appear this type of TRIGGER.
What's the real solution ?
I forced to use views.
Thanks.
Subject
Views
Written By
Posted
Triggers "instead of" for View with "joins"
7224
May 10, 2006 11:13AM
2801
May 10, 2006 06:19PM
2874
May 19, 2006 05:08PM
2510
June 11, 2006 03:42PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.