Subject Null and numeric fields
Author jeffplata
(Using FB 1.03, IBO 4.5B)

In one of my tables I have two numeric(15,2) columns

CREATE DOMAIN DM_MONEY AS
NUMERIC(15,2)
DEFAULT 0.00

CREATE TABLE JEVENTRIES (
ID INTEGER NOT NULL,
JEVID INTEGER NOT NULL,
GL VARCHAR(10),
SL VARCHAR(10),
ACTIVITYCODE VARCHAR(3),
EXPENSETYPECODE VARCHAR(3),
DRAMOUNT DM_MONEY,
CRAMOUNT DM_MONEY
)

Clientside I set the following values for DefaultValues
dramount=0.00
cramount=0.00

My problem is I still get null values with dramount and cramount
sometimes, but not always. This problem occurs only when using the
client program (using IBO). At one point I even set GetServerDefaults
to true to no avail.

Are there issues regading this behaviour? What should I do to ensure
non-null values in the numeric fields?

TIA
Jeff