Subject Re: [ib-support] ISQL and NOT NULL fields
Author Claudio Valderrama C.
""Ivan Prenosil"" <prenosil@...> wrote in message
news:20011107171548.70E651504C@......
> Imagine you have corrupted database/table such that there are NULLs
> in NOT NULL field (e.g. when you add NOT NULL constraint to already
> populated table by updating system table).
>
>
> Which variant do you think is better for ISQL ?
> To show '0' or '' instead of '<null>' (like in current ISQL),
> or to show null as '<null>' (like in WISQL ) ?

I definitely prefer to detect, handle nulls and show them as <null> so no
doubt is left. Maybe it should be an option.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing