num datatype

[Former Member]

Hi experts,

i need to create a field with datatype NUM 4 dec 4,

what datatype i need to select while creating table.

thanks in advance

[Former Member]

Hi

While creating the fields of the table, select the <b>Pre-defined data types</b> and select <b>NUMC with size 4 and decimals 4</b>. (is it that you enter only fractional values with 4 decimal places?)

Regards

Raj

[Former Member]

Hi

You can't give decimal place values for NUMC data types

you either use CURR or QUAN data type fields with decimals

<b>Reward points for useful Answers</b>

Regards

Anji

[Former Member]

hi,

Use Predefined NUMC04 data type but this will not include decimals in it.

Regards,

Santosh