What is the actual data in field X? Unless it is character type you will get an error. However empty(fieldX) will give the correct answer for all data types - 0 for numeric, an empty date { / / }, etc.
HTH
Barbara
>In a form, I have the formula to check a field X of a table --- if X = "" ...
>It works fine when I run the form in VFP. But it has wrong operant error after I complie it to an exe file.
>Finally I change it to if empty(X) ... then it works fine in both VFP and in its exe file. Does it mean we should use the empty() instead of = "" if we want to check empty field?