Hi,
I use Oracle as my database.
I create integers in Oracle and Oracle then uses Number(38) for these columns.
In Servoy dataprovider this is displayed as number with no length.
In oracle i can insert (and retreive) a number in these columns like 12345678901234567890123456789012345678 (38 digits) without problems.
If i enter a number like that in the same column in Servoy and then read it back in Oracle i get 12345678901234567525491324606797053952
So it seems the number(38) precission is not handled by Servoy. It looks more like a (19,2) precission
Am i missing something ?? ( I am using the correct Oracle Jdbc driver (Oracle 10.2.0.4.0))
Regards,
I see a simular issue as in post http://forum.servoy.com/viewtopic.php?f=4&t=11307
if i create a number column in Servoy dataprovider and enter a length of 38 or 50 or 100 and then apply
the length is changed to 2 and in Oracle a column is created NUmber(19,2)
If i choose a length of 0 and apply the length is set to 126 and in Oracle a Float(126) is created.
Is there some documentation about how numbers in Servoy are translated to the database ?? an vice - versa
Regards.
Seems I get something similar here in Servoy 4.0.1 with PostgreSQL 8.2.5:
When creating .dbi files (synchonize with database) I get the following error (one of many).
‘crm2->crm_clientcontact->ctc_duration’ column difference. (NUMBER(id:2), length: 10, allowNull: true) in DB ↔ (NUMBER(id:2), length: 2, allowNull: true) in DB information file.
The DB information on this column differs from the actual column in the DB.
(emphasis is mine)
Servoy does show the correct length in the dataprovider tab but it seems when creating the .dbi file it gets confused.
In my case all the errors are for number fields.