topic Regarding Table Control in screen Painter in Application Development and Automation Discussions

Regarding Table Control in screen Painter

Former Member — Tue, 28 Feb 2006 06:54:25 GMT

hi,

In my table control, one column is aceepting the UV Rate of the Material. But that particular column did not accept the Decimal Value . when i enter the decimal,

'Please enter the Numeric value' error is coming.

I am declared as Curr Data type for my table zuvrate-dmbtr.

how can i enter decimal value in that column?

Re: Regarding Table Control in screen Painter

Former Member — Tue, 28 Feb 2006 07:04:57 GMT

Have you declared the reference field for the currency field in the screen painter? The ref. field parameter can be found in the 'Dictionary' tab under the attributes. Enter the reference field here (eg: T001-WAERS).

Sudha

Re: Regarding Table Control in screen Painter

Former Member — Tue, 28 Feb 2006 07:37:21 GMT

this problem will occur with currency and quantity fields...

instead use another variable of type c.

var(len) type c. then assign the values accordingly u ll get correct result.

Re: Regarding Table Control in screen Painter

Former Member — Tue, 28 Feb 2006 08:19:45 GMT

Hi sudha,

i have already declared the reference field t001-waers. but it is also showing error?

Is there any other way to enter decimal number in table control?

Regards,

Neptune.M

Re: Regarding Table Control in screen Painter

Former Member — Tue, 28 Feb 2006 08:31:16 GMT

Is the screen field referring to the dictionary field? Is the 'From Dict' attribute ticked?

Sudha

Re: Regarding Table Control in screen Painter

Former Member — Tue, 28 Feb 2006 08:39:47 GMT

Hi Sudha ,

thanks for your answer.

In screen Painter screen , From Dict is ticked.

But i cant enter the decimal values.

Thanks,

Neptune.M

Re: Regarding Table Control in screen Painter

Former Member — Tue, 28 Feb 2006 08:40:54 GMT

Hi Sudha ,

thanks for your answer.

In screen Painter screen , From Dict is ticked.

But i cant enter the decimal values.

Thanks,

Neptune.M

Re: Regarding Table Control in screen Painter

Former Member — Tue, 28 Feb 2006 08:44:43 GMT

Neptune,

I think this should solve your problem - in the field attributes, uncheck the 'From dict' and specify the format as DEC (decimal) instead of CURR. I tried with a sample program and this seems to work perfectly.

Sudha

Message was edited by: Sudha Mohan

Re: Regarding Table Control in screen Painter

Former Member — Tue, 28 Feb 2006 09:00:09 GMT

Hi Sudha,

If i Uncheck the from dict and i gave as dec then Data type mismatch error is coming ?

For you how it is working?

and one more thing, If i change in table as dec data type, then more than one decimal places will be showing .

For eg If i Give 23456 then

234.56000 value is showing in the table control.

ig i give 233456768 then

23.345.678.9000 value is showing in the table control.

Now what can i do?

Thanks,

Neptune.M

Re: Regarding Table Control in screen Painter

Former Member — Tue, 28 Feb 2006 09:20:18 GMT

Neptune,

Lets start from the beginning -

Your custom table has a field called DMBTR (domain WERT7). The reference value for this field is T001-WAERS.

Hope its correct so far.

In the table control, your field DMBTR is called <customtablename>-DMBTR.

In the screen attributes of this field, you have the 'From Dict' ticked, Format is CURR and the reference field is specified. Correct?

If this is the case then the table control should not throw any errors, do let me know if there is any change.

Update: I just figured, probably the reason for your errors is that you have not used the domain in your custom table and have specified the CURR type as a direct type. The problem with this is that 2 decimal places will always be required by the system. Whereas if you use the data element (eg: DMBTR), the output length is 16, which would work fine.

Sudha

Message was edited by: Sudha Mohan

Re: Regarding Table Control in screen Painter

Former Member — Tue, 28 Feb 2006 10:56:44 GMT

Hi sudha,

In My table , uvrate column structure is like this,

dmbtr dmbtr curr 13 2 ,

Now From Dict is also ticked,

But i got error once again in table control.

Neptune.M

Re: Regarding Table Control in screen Painter

Former Member — Tue, 28 Feb 2006 12:18:52 GMT

Hi all,

In My user table , uvrate column structure is like this,

dmbtr dmbtr curr 13 2 ,

reference field is t001-waers,

in screen painter,

From Dict is also ticked,

But My problem is,

i cant enter decimal values to the table control.

If i enter decimal entry, Please enter numeric error is coming.

actually where is the problem? and what is the Problem?

Plz if anyone knows, reply me.

Thanks,

Neptune