>>>Hi All,
>>>
>>>What is the quickest way to test if a numeric table field has a decimal portion?
>>
>>int(field) <> field
>
>That tells me if the specific number in the field has a decimal portion. I need to know if the field definition itself has been set to have a decimal portion. For field type double TYPE() and VARTYPE() both return "N".
What does AFIELDS return?
BTW, I think I answered what you asked. You needed to be more precise in the question.
If it's not broken, fix it until it is.
My Blog