Table control, zero value display for quantity

[Former Member]

Hi,

I have a table control with field type: QUAN and edit possibility enabled.

When I enter 0 value i this field.... value is disappearing. It's possible to enter any other value greater than 0 and values keeps in field but not 0 why ? Is it possible to change it ?

thx

[Former Member]

Hi,

Try to use field type as NUMC.

Diffrence between QUAN and NUMC

1. There are differences at

a) usage level

b) database level

2. usage level :

quan : we can enter numbers with decimals

(we cannot enter alphabets)

numc : we can enter numbers (without decimals)

(we cannot enter alphabets)

(NUMC is treated as a string only,

(they are not meant for calculatin purpose)

3. database level :

quan : the field type is NUMBER with decimals

NUMC : the field type is CHAR

Regards,

Harish

[Former Member]

in numc mode zero value not working too When You switch field into no edit mode , its shows 0 but in edit mode it shows nothing 😕

[Former Member]

hi,

this type of error occurs if there is datatype mismatch , u need to change the datatype of that field.

Regards,

Sumanjeet.

[Former Member]

hi,

this type of error occurs if there is datatype mismatch , u need to change the datatype of that field.

Regards,

Sumanjeet.

[Former Member]

Hi Janek,

Whats the need of displaying the 0 quantity ??

If you want , convert the data type quan to char.

for this you need to put down the logic allowing numeric values and concatenate '.' between value and decimal digits.

Regards,

Madhu.