It is not the same. field # '' will work only if SET EXACT is OFF. EMPTY returns .t. for character strings made only of spaces, too.
Vlad
>I noticed that field # '' is faster than empty(field), but it turns out that it was because I had a index on field.
>
>>Sylvain answered your question. I just want to add that
>>
>>empty(lcAVar)
>>
>>is faster than
>>
>>len(allt(lcAVar)) = 0
>>
>>It is also more clear.
>>
>>Vlad
>>
>>>What is wrong with my code??
>>>
>>>*** Variables:
>>>mswhere1 = ''
>>>mswhere2 = ''
>>>director = "'Brady'"
>>>
>>>mswhere3 = iif(len(allt(director)) = 0,; mswhere2,iif(allt(len(mswhere2)) = 0, director,;
>>> mswhere2 + ' and ' + director))
>>>
>>>*******
>>>I got the error 'Function argument value, type, or count is invalid'
>>>
>>>Thanks a lot.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only