Parameter <IntegerPrecision> not working

Thomas.Schweikert · 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 · 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 · Post by **Thomas.Schweikert** » Mon 18 Feb 2008 09:40

Thx,

now it work's

Thomas