Re: Printing Floating Decimal numbers

colin@scdipc0.ueci.com (Colin Mcgrath) writes: >We store numeric data in a floating decimal point numeric column: DECIMAL(8) >We can unload the data and it unloads fine: 123.456 or 12.345678 or 12345.0 >In SQL Query, we can select and display the data as it was typed in, once >the environmental variable "DBFLTMASK" is set to "-1" >In 4GL screens and reports, is there any way to format the output to display >the data as it was typed in and as it unloads and as it displays in SQL? >Currently, I format it into character data with a USING "<<<<<<<&.########" >then, in a FOR loop, strip off trailing zeros past the decimal point. >Not the same as the original numbers, if the zeros were significant. Why not take your scheme one step further by making the input a CHAR field, then reading what they input to create the USING string to display it with? ============================================================ Dennis J. Pimple Informix Software Inc Senior Consultant Denver Colorado USA dennisp@informix.com Voice:303-850-0210 Fax:303-779-4025