topic Re: Quan data type in Application Development and Automation Discussions

Quan data type

Former Member — Tue, 29 Dec 2009 10:37:17 GMT

Hi All,

I want to display table field ( i.e. quan data type) value as char data type in maintenance view,

without changing the domain data type in the table.

Ex. In table the quan field value is 125.600000

In maintance view it should be 125.6

Thanks in advance

Venkatesh K

Former Member — Tue, 29 Dec 2009 10:46:23 GMT

is it a ztable or standard table?

Former Member — Wed, 30 Dec 2009 04:29:41 GMT

Hi Soumyaprakash,

It is a Ztable.

Thanks and Regards,

Venkatesh

Former Member — Wed, 30 Dec 2009 05:00:28 GMT

If you give data type as Quan . it will not take number as what you want.

Instead of QUAN data type use CHAR .

It will accept the values waht u r entering.

delete table maintence and regnerate it.

Regards,

Pravin

Former Member — Wed, 30 Dec 2009 09:23:02 GMT

Hi Venkatesh,

What has been written by Pravin is correct that in the table you need to change the domain from QUAN type to CHAR.

Also with that in the 05 event of table maintainance generator you need to write the code for validations such as.

1) Only numerical entry is allowed in that field

2) Only one . (dot) is allowed in the string

3) If user has has added leading or trailing 0's then remove the same first and the store it.

I guess this much validations will solve the purpose.

Thanks

Former Member — Wed, 30 Dec 2009 10:10:48 GMT

guys venkatesh wants for display purpose only..

use the events of table maintenance generator,