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 19 years ago

Last modified 16 years ago

#381 assigned defect

DBTable function fails when accessing real fields of an Oracle92 table

Reported by: pegarcia Owned by: Jorge
Priority: normal Milestone:
Component: DataBase Version: head
Severity: normal Keywords:
Cc:

Description

The TOL DBTable function (Version of 2006/04/06) is producing invalid results
when one attempt to select real values from an Oracle92 Database. Especifically,
the following statements:

Real DBOpen("recbys", "recbys", "recbys");

Text qry = "

select price

from fn3promotionmonthly

";

Set Table = DBTable(qry);

returns values truncated at the first decimal figure. The field "price" is defined as
float by "Number(10, 2)". That digit is also no rounded and just automatically
changed by zero.

Change History (1)

comment:1 Changed 16 years ago by Víctor de Buen Remiro

Owner: changed from danirus to Jorge
Status: new → assigned
Note: See TracTickets for help on using tickets.