Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Logical represenatation problem
Message
From
08/02/2000 08:47:36
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00326212
Message ID:
00328714
Views:
22
>Hi everybody,
>
>I have a problem, which seems to me have no solutions.
>
>I have a logical field, which I want to populate with .t. on some condition and leave blank otherwise.
>
>I have to create this field using IIF expression:
>LogicalFiled=IIF (somecondition,.t.,.f.)
>
>My question is: How can I make this field blank, if !somecondition?
>
>Thanks in advance

Try with .NULL. values ...
LogicalFiled = IIF(ISNULL(somecondition) OR ISBLANK(somecondition),.NULL., IIF(somecondition, .T., .F.) )
It works when count for .NULL. fields , or blank fields, the third condition
.T. - print check X .F. - print empty box .NULL. - not print
Possibly be a solution ?
Previous
Reply
Map
View

Click here to load this message in the networking platform