[firebird-support] SP Parameter DEFAULT and Domains

[venussoftop]

Hi all

I am trying to make DEFAULT NULL stick for a couple of SP parameters.  I 
generally use DOMAIN but when I did it through DOMAIN (and FlameRobin) the 
DEFAULT would not make it to the final DDL.  When I used FireBird types the 
DEFAULT remained.

The DEFAULT NULL in below got ignored in the final DDL
    TCPROMPT CHAR250 DEFAULT NULL,
    TCSEP CHAR250 DEFAULT NULL )

The DEFAULT NULL makes it through to final DDL
    TCPROMPT Char(250) DEFAULT NULL,
    TCSEP Char(250) DEFAULT NULL )

Please advise

Thanks and regards
Bhav