Parameter <IntegerPrecision> not working

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
Thomas.Schweikert
Posts: 30
Joined: Tue 27 Jun 2006 15:46

Parameter <IntegerPrecision> not working

Post by Thomas.Schweikert » Thu 07 Feb 2008 15:35

Hi,

all of our tables have an ID-field

ID NUMBER(10,0)

if i want to fire a simple SQLDataset (select * from tablename)
-persistent fields- i get an error

"...expected integer found float ...."

We use the TCRSQLConnection component and the following
parameters in the dbxconnections.ini

...
IntegerPrecision=10
EnableBCD=False
...

Today i'v updated to version 4.20.6. with version 3.20.9 everything was ok.

Delphi 7 ENT

Thomas

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Mon 11 Feb 2008 08:23

You should not use EnableBCD parameter in combination with a ...Precision parameter. When you set EnableBCD = False, it is the same as setting the following parameters:
BCDPrecision = 0
FloatPrecision = 38
IntegerPrecision = 9.

So that it resets IntegerPrecision to 9. In version 3.20 paramerers were set in different order. So that it was working.

To resolve the problem, remove EnableBCD parameter and set with the following parameters:
BCDPrecision=0
FloatPrecision = 38
IntegerPrecision = 10.

Thomas.Schweikert
Posts: 30
Joined: Tue 27 Jun 2006 15:46

Post by Thomas.Schweikert » Mon 18 Feb 2008 09:40

Thx,

now it work's

Thomas

Post Reply