Subject Re: [ib-support] ISQL and NOT NULL fields
Author Claudio Valderrama C.
""Ivan Prenosil"" <prenosil@...> wrote in message
> 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.

Claudio Valderrama C. - -
Independent developer
Owner of the Interbase® WebRing