🚀 go-pugleaf

Hi, friends,
I am using BCB5, ADO and Oracle 9ir2. When I am using Microsoft ODBC driver
for Oracle or Oracle OLEDB driver, float data type (result from SQL
expression such as F1 * F2) is translated to TBCDField, but when I am using
Oracle ODBC Driver(Shipped by Oracle Company), float data type is translated
to TFloatField. Property 'EnableBCD' is set to be True in my program. My
program is a multi-tire one, and designed to be run on different DBMSs. When
connecting to SQL Server or DB2, BCD field is returned as expected. I define
persistent field list on  the client side. If the data types of the server
and client are not the same, and error will report, such as: Expected BCD,
actual float. This problem limits adability of my program. I can define
persistant field list on server side too, whose data types match types of
client side, but I think this is not a good idea, and I have to modify all
of my server program. It's a hard work. Microsoft ODBC driver is not a
suitable choice, because it can support some data types of Oracle 8 and
Oracle 9. Oracle OLEDB driver can't be adopted too, because it can't return
parameter types in SQL statement, so I will have to set the parameter types
programmatically.

Is it a bug in BCB, or in Oracle ODBC driver? What is the best way to
resolve it?

Thanks!


Mountain