1

I'm having a problem with Delphi 6 + Oracle 10gR2 + ADO + ClientDataSet.

Whenever I run a aggregate function on a field NUMBER(19,9), the resulting column returns a NUMBER datatype to Delphi, and on some machines it loads as a TBCDField with a precision of 38, and everything goes well, but on some machines it loads as a TBCDField with a precision of 255, and I get a BCD overflow on the field.

To replicate the problem, just create a table with a column NUMBER (19,9), and run a SELECT SUM(column_name) column_name FROM table_name GROUP BY column_name.

Despite the fact that the column is a NUMBER(19,9), the resulting column will be a NUMBER with no precision defined.

In Delphi, load the query into a ADOQuery, with a DataSetProvider linked to it and a ClientDataSet linked to the DataSetProvider. After I call the ClientDataSet.Open, on some machines I get a BCD overflow message on the NUMBER field, but in a lot of machines it works nice.

Why am I getting this 255 precision on some machines, when the midas.dll, ADO, server, user, oracle client are all the same on both machines? Any ideas?

Jan Doggen
  • 8,799
  • 13
  • 70
  • 144
Pascal
  • 2,944
  • 7
  • 49
  • 78

2 Answers2

1

Try type cast

Select **CAST(NUMBER_FLD as VARCHAR2(15))** as NUMBER_FLD from DUAL;

On Delphi, is a StringField (ClientDataset) component, but if you get by alias, like CdsOracleSQL.FieldByname('NUMBER_FLD').AsFloat or CdsOracleSQLNUMBER_FLD.AsFloat works.

I dont know why BCDField loses the decimal separator and works likes a integer...

Simson
  • 829
  • 6
  • 16
Hangout
  • 11
  • 1
0

I don't have any definitive answer for your, but are you positive you have the same versions of the client dlls on both machines? There may be other software installed that is interfering. Try running Windows Process Explorer on the client machines and confirm that the dlls you think you are using are the ones that are actually being used by your client applications.

Steve Broberg
  • 4,255
  • 3
  • 28
  • 40
  • I'll try using Process Explorer. Good idea. But both machines have the same client, I'm sure – Pascal Jul 18 '09 at 04:10