close Warning: Can't synchronize with repository "(default)" (/var/svn/tolp does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 15 years ago

Closed 14 years ago

#941 closed defect (duplicate)

Redondeo de los datos de Oracle a cero

Reported by: Iván Robles Owned by: Jorge
Priority: highest Milestone: Mantainance
Component: Database Version: 2.0.1
Severity: blocker Keywords: odbc, oracle, decimal, number
Cc:

Description

Buenos días, al ejecutar la siguiente orden en Tol con una BBDD Oracle, nos devuelve cero, nos redondea el numero.

DBTable("select cast(0.04 as decimal(20,10)) from dual");
DBTable("select cast(0.04 as number(20,10)) from dual");

La version del driver usado es:

Oracle en OraClient11g_home1 11.01.00.06

Change History (1)

comment:1 Changed 14 years ago by Jorge

Keywords: odbc oracle decimal number added
Milestone: → Mantainance
Resolution: → duplicate
Status: new → closed

Este bug es duplicado de #983. Se verifica también que en ubuntu no se reproduce:

22:44:40 TOL> Set tmp = DBTable("select cast(0.04 as decimal(20,10)) from dual");
1 elements
22:50:03 TOL> Set View( tmp, "Std" );
$tmp$=[[  0.04]]
1 elements
22:50:19 TOL> Set tmp1 = DBTable("select cast(0.04 as number(20,10)) from dual");
1 elements
22:50:55 TOL> Set View( tmp, "Std" );
$tmp$=[[  0.04]]
1 elements

La solución se continuará en el ticket #983.

Note: See TracTickets for help on using tickets.