Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IIF() error
Message
From
17/06/1999 20:10:54
 
 
To
17/06/1999 09:36:05
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00230164
Message ID:
00231154
Views:
26
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
Map
View

Click here to load this message in the networking platform