>>Hi,
>>
>>I have an expression that compares if a value in a table/cursor field is equal to 0 (zero). The field is of type numeric with two decimals (e.g. 3.44, 0.00, 1.01)
>>
>>Which syntax is more reliable to use:
>>
>>cursor.field = 0 or <another expression>
>>
>>or
>>
>>cursor.field = 0.00 or <another expression>
>>
>>
>>TIA
>
>Both are correct if it comes to field.
>If you compare variable sometime 0 is not equal to 0 :-)
>because variable can be something like that: 0.000000000000001 and you will see it in debugger as 0 but it is not :-)
>So if you compare variable and zero better use:
>
>ROUND(variable, 2) = 0
>
In my case, I am comparing a field. So I will leave it as 0 (without decimals). But I will make a note to use the Round() when it comes to variables.
Thank you for your prompt help!
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham