Devart Forums

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

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.

Thx,

now it work's

Thomas