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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement