topic Re: Making Numeric field blank in Application Development and Automation Discussions

Making Numeric field blank

Former Member — Tue, 30 Sep 2008 11:20:13 GMT

Hi Experts ,

i have a requirement to make the numeric field "blank" in some rows of internal table .

its about vendor

whenever any vendor will repeat , i need to display 3 numeric fields "blank" , in that particular row .

please help me on this issue .

thanks in advance .

vijeta

Re: Making Numeric field blank

Former Member — Tue, 30 Sep 2008 11:24:17 GMT

Hello,

You can't make a numeric field value blank because the initial type value is zero. Instead I suggest you to convert these field to character and then make these new fields blank.

Regards.

Re: Making Numeric field blank

Former Member — Tue, 30 Sep 2008 11:29:51 GMT

Hi,

One very important thing we cannot make numeric field as blank is can be made initial i.e. 0.

So we have to make the field as character then we can make it blank by initializing it.

thanx.

Re: Making Numeric field blank

Former Member — Tue, 30 Sep 2008 11:35:08 GMT

Please use a CHAR field instead of desired length.

When you need to perform any operations, declare a run time integer variable and by type casting assign the char field to this variable.

This will solve the problem.

Re: Making Numeric field blank

Former Member — Tue, 30 Sep 2008 12:29:56 GMT

can i have any example .

thanks in advance .

vijeta

Edited by: Vijeta Aharwar on Sep 30, 2008 2:38 PM

Re: Making Numeric field blank

Former Member — Fri, 03 Oct 2008 13:53:20 GMT

Hi ,

it will be helpful if u provide an example .

thanks in advance.

vijeta

Re: Making Numeric field blank

former_member194797 — Fri, 03 Oct 2008 14:30:17 GMT

If you are using the WRITE statement, you can use the NO-ZERO option; with this option the entry which has zero value in the table is displayed as spaces.