Subject Disconnect dependencies
I'm trying to work out how I can easily disable dependencies in my Firebird
database design to allow for a change in the system. For example, I have a
column in a table that is a VARCHAR(500) but I need to make it larger to

But I have a number of stored procedures that refer to this column. I can
change the stored procedures to accommodate the column change, but when I go
to change the actual table column and expand it to this size, it gives an
error stating that the SPs are referring to this field.

Clearly there won't be a problem with this change, but I can't get passed
the FB dependency checks in order to make this change.

What is the best way to handle this scenario?


Myles Wakeham
Director of Engineering
Tech Solutions US, Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440