topic Table control, zero value display for quantity in Application Development and Automation Discussions

Table control, zero value display for quantity

Former Member — Mon, 04 Aug 2008 10:13:56 GMT

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

Re: Table control, zero value display for quantity

Former Member — Mon, 04 Aug 2008 10:19:27 GMT

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

Re: Table control, zero value display for quantity

Former Member — Mon, 04 Aug 2008 10:53:40 GMT

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 😕

Re: Table control, zero value display for quantity

Former Member — Mon, 04 Aug 2008 11:01:39 GMT

hi,

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

Regards,

Sumanjeet.

Re: Table control, zero value display for quantity

Former Member — Mon, 04 Aug 2008 11:06:15 GMT

hi,

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

Regards,

Sumanjeet.

Re: Table control, zero value display for quantity

Former Member — Mon, 04 Aug 2008 11:16:03 GMT

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.