Page 1 of 1
BCD Overflow
Posted: Wed 04 Apr 2007 16:19
by webpac
Hi everyone,
I just have pay theDbxOda. I use Oracle 10g Express. I got an error with this SQL request :
Code: Select all
SELECT
VENTE.CA/VENTE.UNITE
FROM
VENTE
Débordement BCD
and in english it's
BCD overflow
I use the last version 3.1.0.8 of DbxOda and Delphi7.
Thanks.
Posted: Thu 05 Apr 2007 07:38
by Plash
Please provide the Pascal code where the error occurs and the SQL statement to create the VENTE table.
Posted: Thu 05 Apr 2007 12:42
by webpac
Hi,
This is how the table is created :
Code: Select all
CREATE TABLE VENTE (REGION0 VARCHAR2(15), VILLE0 VARCHAR2(15), FAMILLE0 VARCHAR2(15), PRODUIT0 VARCHAR2(15), EXERCICE DOUBLE PRECISION, TRIMESTRE DOUBLE PRECISION, MOIS DOUBLE PRECISION, ANMOIS VARCHAR2(15), CA DOUBLE PRECISION, UNITE DOUBLE PRECISION) STORAGE ( INITIAL 1M NEXT 5M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 )
This is the TSQLConnection params :
DataBase=MYBASE,User_Name=MYNAME,Password=MYPASSWORD,GetDriverFunc=getSQLDriverORA,LibraryName=dbexpoda.dll,VendorLib=OCI.DLL,BlobSize=-1,ErrorResourceFile=,LocaleCode=0000,"Oracle TransIsolation=ReadCommited"
Posted: Fri 06 Apr 2007 07:33
by Plash
If you are using the DOUBLE PRECISION data type, you should set the EnableBCD connection option to False just after the connection is opened.
Code: Select all
const
coEnableBCD = TSQLConnectionOption(102);
begin
SQLConnection1.Open;
SQLConnection1.SQLConnection.SetOption(coEnableBCD, Integer(False));
end;
Posted: Fri 06 Apr 2007 07:56
by webpac
Thanks, it works.