Hans (and all),

I implemented this solution but I'm contemplating about the following:

1) What situations cause the Default setting in FB to be ignored, as
I've experienced? Is IBO the one in play here?

2) I have some more numeric(15,2) fields in the db. Adding two
separate triggers for each affected tables add to the overhead when
inserting/modifying records. Or am I overstating?

TIA

--- In IBObjects@yahoogroups.com, Hans <hhoogstraat@...> wrote:
>
> Possible solution, add a 'before update and insert' trigger
>
> if (new.dramount is null) new.dramount = 0;
> if (new.cramount is null) new.cramount = 0;
>
> ----- Original Message -----
> From: "jeffplata" <jeffplata@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Tuesday, May 30, 2006 8:09 PM
> Subject: [IBO] Null and numeric fields
>
>
> > (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
> >
> >
> >
> >
> >
> >
> >
> >
______________________________________________________________________
_____
> > IB Objects - direct, complete, custom connectivity to Firebird or
> > InterBase
> > without the need for BDE, ODBC or any other layer.
> >
______________________________________________________________________
_____
> > http://www.ibobjects.com - your IBO community resource for Tech
Info
> > papers,
> > keyword-searchable FAQ, community code contributions and more !
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
>