Hi List:

I wanted some nice accurate numeric fields, and defined them as such,
they will mostly carry currency values, so I defined them similar to
this one:

DOLLAR_AMT NUMERIC(12,2) DEFAULT 0.0 NOT NULL;

Plopped it on a form, and entered 1.46 the TDBEdit Control came up
with 9232374082633.6166 would much more reasonable. I took a look at
what actually got to IB and it says 0.

My guess is this is some kind of conversion not getting done, anyone
know of a resolution other then a search for NUMERIC(12,2) and
replace with DOUBLE PRECISION and rebuilding the database, it's not
production so this is an option...





Paul Schmidt,
Tricat Technologies
Email: paul@...
Website: www.tricattechnologies.com