Subject | Problem with Numeric and TIBOTable |
---|---|
Author | Helton de Oliveira |
Post date | 2001-12-26T17:23:47Z |
Hi,
A 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
:= 999999999999.99; ) i receive an error message "Invalid floating point
operation".
I'm using a TIBOTable and Dialect 3.
Any sugestions ?
Helton
A 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
:= 999999999999.99; ) i receive an error message "Invalid floating point
operation".
I'm using a TIBOTable and Dialect 3.
Any sugestions ?
Helton