On before insert trigger do:
if (fieldX is null) then fieldX=0;

Luiz.

----- Original Message -----
From: Gordon Hamm <vds@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, July 19, 2001 6:33 PM
Subject: [IBO] zero instead of Nil


> I have a numeric field called balance. Id like it to force the initial
value
> to 0 instead of NIL. How would I do that.
>
> Gordon Hamm
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>