[Firebird-devel] ALTER COLUMN RC2 problem.

[Sebastiaan T. <st...@et...>]

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