🚀 go-pugleaf

Ran the below sql's:

CREATE DOMAIN D_VARCHARDEFAULTN VARCHAR(1) DEFAULT 'N';

ALTER TABLE PRODSTORE
ALTER ISRANGED TYPE D_VARCHARDEFAULTN;

insert into prodstore
( storeid, plu )
values
( '1', '1' );


select *
from prodstore
where storeid =  '1'

result

ISRANGED field defaults to 'Y'

Therefore it did not work.

Sad.

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
>