Subject | Again... Problem with Numeric and TIBOTable |
---|---|
Author | helton_o |
Post date | 2001-12-27T10:44:13Z |
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
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