You can't change it in this way.

Every field has a domain and you have to alter the domain to have a default.
The domain will be something like RDB$1234. The best way to do this is in a
tool like Marathon, it makes it much easier.

JAC.

----- Original Message -----
From: Paulo Albuquerque <paulo.albuquerque@...>
To: <IBDI@egroups.com>
Sent: 08/mm/2000 3:16 PM
Subject: [IBDI] Defining a default value to an existing column


> What is the command syntax for defining a default value to an
> existing column on a Interbase 6.0 table on WISQL ?
> I tried something like:
>
> ALTER TABLE ORDERS ALTER COLUMN OR_SITUATION TYPE VARCHAR(8)
> DEFAULT '10000000';
>
> but it always returns a SQL error.
>
> Thank you in advance,
>
> Paulo
>
>
>
> ------------------------------------------------------------------------
> Take your development to new heights. Work with clients like Dell and
> pcOrder. Submit your resume to jobs@.... Visit us at
> http://click.egroups.com/1/4358/4/_/679568/_/960473816/
> ------------------------------------------------------------------------
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI
>