search

zedalaye / fbclone

A wonderful tool to take care of your Firebird databases
33 stars 19 forks source link

Triggers & Views Create order #2

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
If View-Triggers are not created before updating View in stored Procs or 
other Triggers, an update error is fired.

example: 
----- exception -----
cannot update read-only view VRIBCLI
The object of the insert, delete or update statement is a view for which 
the requested operation is not permitted.
Error Code: 42
---------------------

Firebird 2.1 windows XP/7

Original issue reported on code.google.com by don.jose...@gmail.com on 21 Apr 2010 at 1:46

GoogleCodeExporter commented 9 years ago 
Does that mean I only have to recreate view triggers before table triggers and 
procedures ?

Original comment by pierr...@gmail.com on 9 Nov 2012 at 12:05

GoogleCodeExporter commented 9 years ago 
I changed creation order between view triggers and table triggers. Can you 
check ?

Original comment by pierr...@gmail.com on 9 Nov 2012 at 3:05