At 10:31 PM 28-05-01 -0700, you wrote:

>The problem is that ISQL should put the DDL for the creating the stored
>procedure **after** the triggers for the view have been defined. Then and
>only then is this view updatable. You can see for yourself by running the
>script as is. you'll get the same error. Then try moving the code for
>altering the procedure top the end of the script and it works just fine.
>
>Is that more clear?

Yes, thanks. Actually, this problem of metadata regenerating in the wrong order exists in 5.x version of ISQL also. Since you have a test case, how about reporting it to the bug tracker on sourceforge.net/projects/firebird?

Thks,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________