db resource - number or numeric.

[xren]

Hi,

I have columns with number as the data type in my oracle database,

when I create db resource for this table and using import, the fields imported are all integer instead of number. How can these be fixed?

If I manually change the fields type for the Db resource, should I pick number or numeric? what are the differences?

Thanks,
Xiaoli

[Jon]

If the Oracle columns specify 0 decimal places, INTEGER is the correct type. If they have decimal places you should use the DECIMAL type for the resource fields.

At runtime, it doesn't matter too much which type is specified in the Database Resource fields, but it does matter what type is specified for the mapped form fields. The form fields should be either INTEGER or NUMERIC depending on whether decimal places are allowed or not.