BCD Overflow

[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.

[Plash]

Please provide the Pascal code where the error occurs and the SQL statement to create the VENTE table.

[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"

[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;

[webpac]

Thanks, it works.