Subject Again... Problem with Numeric and TIBOTable
Author helton_o
Hi,

I have the follow table in a IB database:

CREATE TABLE Formulas
(
CodFormula SMALLINT NOT NULL ,
DscFormula VARCHAR(15) NOT NULL ,
CodVctoDesc SMALLINT NOT NULL ,
Formula VARCHAR(150) NOT NULL ,
Piso NUMERIC(18,2) DEFAULT 0 NOT NULL ,
Teto NUMERIC(18,2) NOT NULL
);

When i try to assign a value to the field "Teto" (
tblFormulasTeto.AsFloat
:= 999999999.99; ) i receive an error message "Invalid floating point
operation", if i try to assign the value 899999999.99 it works fine.

I'm using a TIBOTable and Dialect 3.

Any sugestions ?

Helton