Subject | Altering view |
---|---|
Author | dosinovsky |
Post date | 2005-08-13T13:18:30Z |
Hi!
I need to alter view from my program, but I have a problem: there are
stored procedures that uses that view. It would not let me commit
transaction where I drop the view, even if I recreate it in the same
transaction. What should I do? Maybe in Firebird there is something
like "create or replace view"?
TIA.
Regards,
Dmitry
I need to alter view from my program, but I have a problem: there are
stored procedures that uses that view. It would not let me commit
transaction where I drop the view, even if I recreate it in the same
transaction. What should I do? Maybe in Firebird there is something
like "create or replace view"?
TIA.
Regards,
Dmitry