Decimal Display

[SSuhaib]

Hi all,

I have a problem displaying "n" number of decimals in my SQL client application. Example, original value in database (9.1e) is 123.123456789 but the value in SQL client application is 123.1234567. Any ideal how to display the full length?

Thanks in advance.

 

[Stefan]

Look at your SQL92 scale and number of decimals in the data dictionary.

The number of decimals is shown in the normal field properties, the scale / width is shown if you adjust field width.

With 10.2B04 a decimal with 10 decimals and width 20, shows your example completely from SQL.