>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
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