Parameter <IntegerPrecision> not working

Parameter <IntegerPrecision> not working

Postby 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
Thomas.Schweikert
 
Posts: 30
Joined: Tue 27 Jun 2006 15:46

Postby 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.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby Thomas.Schweikert » Mon 18 Feb 2008 09:40

Thx,

now it work's

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


Return to dbExpress driver for Oracle