🚀 go-pugleaf

Thank you for the solutions, thats great.
By the way, We have been using default values for a long time successfully 
in IB6 and above without ever specifying NOT NULL
I wonder where you got the idea that you had to specify NOT NULL?

Kind Regards,

Robert.

"Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> wrote in message 
news:4670989e$1@newsgroups.borland.com...
> Bob wrote:
>> current definition of a column is :
>>
>> ISRANGED VARCHAR(1) DEFAULT 'Y'
>>
>> how could we change this to
>>
>> ISRANGED VARCHAR(1) DEFAULT 'N'
>
> Create a domain:
>
> CREATE DOMAIN D_ISRANGED CHAR(1) NOT NULL DEFAULT 'N';
>
> Now you can assign the domain:
>
> ALTER MYTABLE
> ALTER ISRANGED TYPE D_ISRANGED;
>
> Some notes:
>
> 1) While using Varchar for this field won;t cause a problem, it is a waste 
> for a single char field, you should use CHAR.
>
> 2) Default values do not work if you do not specify not null also.
>
>
> -- 
> Wayne Niddery - Winwright, Inc (www.winwright.ca)
> "The only reason some people get lost in thought is because it's
> unfamiliar territory." - Paul Fix
>