‎2009 Dec 29 10:37 AM
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
‎2009 Dec 29 10:46 AM
‎2009 Dec 30 4:29 AM
‎2009 Dec 30 10:10 AM
guys venkatesh wants for display purpose only..
use the events of table maintenance generator,
‎2009 Dec 30 5:00 AM
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
‎2009 Dec 30 9:23 AM
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