| Subject | Why do I recompile all the stored procedure after drop a irrelevant field? |
|---|---|
| Author | william_yuwei |
| Post date | 2011-10-15T22:13:40Z |
HI, All
Using Firebird 2.1.3, I have a table, called, Order, which have a not null field POSTED with default source 'N'. Later, I removed this field, but all my stored procedures that having UPDATE ORDER SET ...., need to be recomple again, even though there is NO POSTED field involved in the UPDATE statements. If I won't re-compile these stored procedures, I will get '.... column 'unknown', values *** null*** ....' error.
Regards,
William
Using Firebird 2.1.3, I have a table, called, Order, which have a not null field POSTED with default source 'N'. Later, I removed this field, but all my stored procedures that having UPDATE ORDER SET ...., need to be recomple again, even though there is NO POSTED field involved in the UPDATE statements. If I won't re-compile these stored procedures, I will get '.... column 'unknown', values *** null*** ....' error.
Regards,
William