jeffplata wrote:

> (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?

I only use default from the server (GetServerDefaults) but I have
noticed that numerics in a TIB_Grid with embedded controls somethimes
displays the values incorrect re null/0. Can this be the case?

HTH,

/Dany