>Hi
>
>What's the easiest way, programmatically in code, to determine if a variable/field is a real or integer? I have code, which loops through fields in a database, and I'm using str(myField) to convert it for a report. Obviously, if it's a real number I want decimal places str(myField,2), but if it's a real than I don't need/want the decimal places. The issue is that type('myField') returns 'N' for either real or integer.
>
>Thanks in advance


if you don't get into scientific notation ( eg 1.23E22), then

function DecimalPlaces(n)

	return  mod(30 - rat('.', padl(m.n, 30)), 30)
endfunc