Hi, I've noticed a strange behaviour when you run a script like this:
ALTER DOMAIN MYDOMAIN_DM SET DEFAULT 'ZZZ'
The database stores (using here '>' or '<' as delimiters)

> DEFAULT 'ZZZ'<

instead of

>DEFAULT 'ZZZ'<

(it stores a space in front of DEFAULT)
This fools IBO when is retrieving default field values from DB, since
it's searching for 'DEFAULT' and finds '_DEFAULT' instead!
I've tried this on IB (6.1.x) and Firebird (0.9.4).
Must we change IBO?
The procedure:
TIB_Dataset.SysGetServerDefaults2(PreSetDefaults: boolean);
In the IBA_Dataset.IMP
The line
if UpperCase( Copy(Default_Source, 1, 7 )) = 'DEFAULT' then
has to become:
if UpperCase( Trim(Copy(Default_Source, 1, 7 ))) = 'DEFAULT' then
Will someone here send it as a known bug in IB and Firebird developers
community? (I prefer Firebird first ;))
Thanks
Marco Menardi