>>>Hi,
>>>
>>>How do I check if a value in the field is 0 (zero) if the decimal of the field could be any number (e.g. 1,2,4). For example, if field MyField type is Numeric(12,4), and the value in the field is zero, will the following return .T.?
>>>
>>>
>>>? evaluate( cTableAlias + ".MyField" ) = 0
>>>
>>>
>>>That is, do I need to have the decimal 0s specified on the right side of the equation above?
>>>
>>>TIA.
>>
>>No, and you can also use
>>
>>
>> ?empty(eval(forceext(m.cTableAlias, 'MyField')))
>>
>
>I have used EMPTY() on a numeric field before but was never 100% sure that is a valid method of determining if value is 0. Thank you for confirming it.
Most of the times I use empty(). But either way is fine
Gregory