Subject | Currency is Null ---- How to stop |
---|---|
Author | Michael L. Horne |
Post date | 2002-12-23T18:05:27Z |
Hello,
Using Delphi 7, IBO 4.2Ib, Firebird 1.0.0.796.
I have fields defined as
CREATE DOMAIN T_CURRENCY AS NUMERIC(9,2) DEFAULT 0
When these fields are displayed using TIB_Edit, if the user
selects the data in the field and hits "Delete", then the
value stored in the field of the DB is "NULL" instead of zero.
Is there a way I can have IBO set the fields to zero? Or
do I need to have a on update/insert trigger that checks
every numeric field in the record to see if they are null
and replace with a zero?
Thanks
Michael L. Horne
Using Delphi 7, IBO 4.2Ib, Firebird 1.0.0.796.
I have fields defined as
CREATE DOMAIN T_CURRENCY AS NUMERIC(9,2) DEFAULT 0
When these fields are displayed using TIB_Edit, if the user
selects the data in the field and hits "Delete", then the
value stored in the field of the DB is "NULL" instead of zero.
Is there a way I can have IBO set the fields to zero? Or
do I need to have a on update/insert trigger that checks
every numeric field in the record to see if they are null
and replace with a zero?
Thanks
Michael L. Horne