Subject | Null and numeric fields |
---|---|
Author | jeffplata |
Post date | 2006-05-31T02:09:27Z |
(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
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