|
From: Sebastiaan T. <st...@et...> - 2002-02-17 05:09:12
|
It would appear that altering a field by adding a DEFAULT clause causes an error. Example: ALTER TABLE UnitPkgDetail ALTER MarkUp DEFAULT 0.00 The error message: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 40 DEFAULT I have tried re-defining the field as follows: ALTER TABLE UnitPkgDetail ALTER MarkUp TYPE NUMERIC (15,8) DEFAULT 0.00 same error (different position) I have noticed the NOT NULL constraint also causes the same failure. I am working with LI-T6.2.681 Firebird RC 2 on Mandrake linux 8.0 server. Any feedback (positive please ;) would be appreciated. Sebastiaan |