×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.





So for the table in question,
ITITEM should return scale = 15, precision = 0
ITIDESC should return scale = 30, precision = 0
ITPRICE should return scale = 9, precision = 2
ITQTY should return scale = 9, precision = 0

I guess you meant precision = 15, scale = 0 for ITITEM, etc.

John Y.

Yeah, sorry. The way CLI uses the terms precision and scale is totally
backwards to what I think they should be (and how others use the terms as
well). The worst part is I was consciously trying to get it right, since I
figured someone would "correct" me, but alas I mixed them up anyway...


So I wasn't crazy, scale was zero for the ones I tested. :) Makes sense
now.. hopefully this won't get messed up in the archives and people will
read through the thread.

Thanks again, guys!

Brad
www.bvstools.com

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.