>>>What I'm trying to achieve is a single, quick test that will compare 2 sets of states and give the following results:
>>>
>>>State1 State2 Result
>>> T T T
>>> T F F
>>> F T T
>>> F F T
>>>
>>>The first state indicated if something if being used and the second if access is granted. I really want to do this check when creating nodes for a treeview so speed is quite important.
>>>
>>>Can anyone point me to a solution?
>>>Thanks in anticipation.
>>
>>What about:
>>result = iif(state1==state2,.t., state2)
>>
>>Einar
>Einar,
>I don't think that will cover option 3 but thanks for the input, I believe I have a solution from Cetin.
It should cover all the cases you describe.
Please show me how it fails to cover option 3.
Option 3: State1 = .F. and State2 = .T.
result = iif(state1==state2,.t., state2) = .T.
Which is what you listed in your 'table'.
As for speed my solution would be a lot faster.
Einar
Semper ubi sub ubi.