Re: forms query?

"Venkata Krishnan .J" <venkat@pacific.net.sg> wrote: If the value really has to be stored as integer, convert to decimal and use the format function for display. Re-convert to integer for insert into the database. If it doesn't matter if the value is stored as decimal, use decimal with the desired precision and without a scale. Hope this helps... >i'm using informix 4gl 6.2. while capturing data using forms i have the >foolng problem. >i want to capture numeric data declared with integer and when the user >enters the number i want to fill the space with zeros. so that >[ 1]if the user enters this my screen should show it as >[00001].picture and format clause is not of any help. is there any other >way to achieve this? >my mail id is :venkat@pacific.net.sg _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Gordon E. Hooker MACS PCP 25 Clarke Street Ripley Queensland Australia Phone 61-7-32940555 Email gordonh@thehub.com.au _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ We are just two lost souls living in a fish bowl Year after year Pink Floyd