Powerbuilder supports 18 decimal digits

[nikhilparchure]

I have a reports while executing gives the following error
Powerbuilder supports 18 digits decimal conversion
Is this a restriction or a bug ....

Very urgent
pls help

Regards
Nikhil

 

[rt63]

It is as per design of standard data types in PB. This is from the help document


Decimal or Dec

Signed decimal numbers with up to 18 digits. You can place the decimal point anywhere within the 18 digits—for example, 123.456, 0.000000000000000001 or 12345678901234.5678.

Double

A signed floating-point number with 15 digits of precision and a range from 2.2250738585073E-308 to 1.79769313486231E+308.

Real

A signed floating-point number with six digits of precision and a range from 1.175495E-38 to 3.402822E+38.


Do you really need that much precision in your data. Otherwise, convert the data in the query/proc so that it sends only a few significant digits.
RT