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
VARCHAR(1000).

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

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