problemas con tipo de datos

[Chakib Faghloumi]

Hola,
con el gestor oracle, el DBTable y el DBSeries...
no reconocen el tipo de dato decimal
mando un ejemplo
Sentencia:
Real real_1 = 0.52;
Real real_2 = DBTable("Select Cast( "+FormatReal(real_1)+" as decimal(10,5)) from dual")[1][1];
Real real_3 = DBTable("Select Cast( "+FormatReal(real_1)+" as float) from dual")[1][1];
Salida:
Real real_1 = 0.52; #bien#
Real real_2 = 0; #mal#
Real real_3 = 0.52; #bien#

[Jorge]

Tengo que configurar una conexión odbc con oracle.

[Jorge]

Esto es lo que se obtiene desde la consola isql de odbc:

as decimal:

SQL> Select Cast( 0.52 as decimal(10,5)) from dual
+--------------------------+
| CAST(0.52ASDECIMAL(10,5))|
+--------------------------+
| .52                      |
+--------------------------+
SQLRowCount returns -1
1 rows fetched

as float:

SQL> Select Cast( 0.52 as float) from dual
+-----------------------------------------+
| CAST(0.52ASFLOAT)                       |
+-----------------------------------------+
| .52                                     |
+-----------------------------------------+
SQLRowCount returns -1
1 rows fetched

[Jorge]

Ejecutado en ubuntu, el error no se manifiesta

22:44:20 TOL> Real real_3 = DBTable("Select Cast( "+FormatReal(real_1)+" as float) from dual")[1][1]
0.52
22:44:40 TOL> 

Hay que reproducirlo en windows.

[Jorge]

(In [4537]) fixes #1503, refs #1022,#983,#300,#296, BIGINT is returned as SQL_C_CHAR then converted to Real