Hi Cetin,
Thanks for the feedback. I originally wrote this code a few years back & I am just now revisiting that project. The idea is that the number you're getting is user input, or import from a file with an unknown number of decimal places (if any), so I could not define lnSignificantdecimals up front. Unless I am missing the true meaning behind your post... if so, please explain.
>
>That creativity is not foxbased < g >.
>
>nValue = 234.8234721345
>cValue = trim(trans(m.nValue))
>? iif(occurs('.',m.cValue),len(m.cValue)-at('.',m.cValue),0)
>
>Why don't you simply use:
>lnSignificantdecimals = 10
>create table ... (myMathField b(m.lnSignificantDecimals), ...)
>(or Y)
>Cetin
Paul A. Busbey
Victoria Insurance