🚀 go-pugleaf

Hi Gelein

The syntax taken from "View Metadata" in ibc (ie the full db metadata) is 
like this:

CREATE DOMAIN "DOM_FIRSTNAME" AS VARCHAR(20) DEFAULT NULL COLLATE DB_US437;

Interestingly, the syntax taken from the "Metadata" tab of the domain 
definition reads:

CREATE DOMAIN "DOM_FIRSTNAME" AS VARCHAR(20) CHARACTER SET DOS437  DEFAULT 
'NULL' COLLATE DB_US437;

ie the default NULL value is enclosed in single quotes, which would explain 
the result I observe. I re-checked the original script I used to declare the 
domains, and it did not include any quotes at all - in fact it was:

CREATE DOMAIN DOM_FIRSTNAME AS VARCHAR(20) CHARACTER SET DOS437 DEFAULT NULL 
COLLATE DB_US437;

-- 
Brent Rose
Whats On Report
brent@whatson.co.nz


"Gelein van de Voorde" <gelein@gvsnet.nl> wrote in message 
news:47bb38e7$1@newsgroups.borland.com...
> Brent Rose wrote:
>
>> When entering new records in IBC, domain based DEFAULT NULL fields
>> default to text value "NULL" rather than actual <null> value.
>
> Brent,
>
> Can you post the Metadata of an example of a domain that has this
> effect?
>
>
> -- 
> Gelein van de Voorde (IBConsole team)
>
> "The blossoms on an apple tree are standardized,
> and yet they are all different.
> That is how we, too, should learn to build."
>
> Alvar Alto