No decimals on Agregation Fields

Classic Servoy
1

Servoy 2.1.1.
Data Base: Oracle 9i

dataprovider:
TOTAL (number,6)

agregation field:
sum_total : (Type: SUM, Column: TOTAL)

I have two records with the following data on the total column:

r1: TOTAL = 10,45
r2: TOTAL = 1,25

Field sum_total returns: 11 (No decimals !!!)

If I put this as a format for sum_total: #.00
Field sum_total returns: 11.00 (No decimals !!!)

2

can you post me the create table statement of that table?
Because it seems that oracle is returning those values like that.

3 
CREATE TABLE AVALES ( 
  ID_AVALES         INTEGER       NOT NULL, 
  ID_AGENTES        INTEGER       NOT NULL, 
  FECHAVENCIMIENTO  DATE, 
  ID_MONEDAS        INTEGER, 
  TOTAL             NUMBER (20,6), 
  FECHA             DATE, 
  CONSTRAINT PK_AVALES
  PRIMARY KEY ( ID_AVALES ) 
    USING INDEX 
     TABLESPACE USUENVIOS_IDX PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USUENVIOS_TAB
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 65536
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE;

This is just an exmple, I mean with this table, but it happens with all fields defined as NUMBER on all tables.

4

this is an oracle driver bug.
A aggregation field (the sum) is returning a value that according to the ResultSetMetaData doesn’t have a Scale and a Precision. They should at least return the same Scale and Precision of the column where it is build on.

I made a workaround for 2.1.2.

5

Is there any recent experience on the NCLOB problem in Ortacle 10g (see Blob NOT WORKING with ORACLE 9i - Classic Servoy - Servoy Community)?
The behaviour I saw was that field content was correctly displayed, but could not be edited (the field was emptied instead).

Thanks!

6

Nop, NCLOB still a problem for us.

Lets hope its solved in 2.1.2 !!!

7

i have tested this.
With 4 of the latest drivers i could get from oracle and all have the same problem. The DatabaseMetaData does return the wrong value for an NCLOB field when xx.getShort(“DATA_TYPE”); is called
It is returning 1111 for that. And that is Types.OTHER and we really can’t do anything with it. They should return Types.CLOB (2005)

There is no workaround for that this.