Hi Bruce,
>>
>>Is there a function to determine size of variable? Today I had a numeric overflow Error, so I was thinking, is it possible to find a size (or number of digits) in Numeric variable.
>>I finally got it working in this code:
>>
>>
>>if !empty(pnSize) and vartype(pnSize)='N'
>> lnMax=val(replicate('9',pnSize-1))
>> if lnLotSizeSqFt>lnMax
>> lnLotSizeSqFt=lnMax
>> endif
>>endif
>>there pnSize is a parameter (actual field size). But how can I determine size of variable?
>
>Something like this, if you don't want the decimal portion?
>
>len(alltrim(str(int(nValue))))
Yes, it should work. Not a one function, though :) (I was thinking I'm missing something obvious)
Thanks a lot.
If it's not broken, fix it until it is.
My Blog