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
