>>Greetings all,
>>I am attempting to use a logical field name checkStub (.f., or .t.) in a compound index. The code requires the field to remain a logical fields: .f. or .t. I would like to sort in a compound index with a character field named vendCode. I tried:
>>

>> str(checkStub) + vendCode
>>

>>but that gives me "invalid type".
>>
>>Any ideas?
>>
>>thanks, vince
>
>To combine several fields, you must normally convert everything to character type.
>
>Here are two alternatives:
>
>

>* Option 1
>index on transform(CheckStub) + VendCode
>
>* Option 2 - smaller index
>index on iif(CheckStub, "1", "0") + VendCode
>* or
>index on iif(CheckStub, "T", "F") + VendCode
>

And a short version of option 1, ergo 1b:

index on TRANSFORM(CheckStub, "Y") + VendCode

The nice thing about all these is that the false values will come before true values. I wish we had that order in language, when naming code: post_hook comes before pre_hook; "before_*" comes after "after_*"... whichever word pair I tried, it sorts wrongly.

Hmmm... maybe ante- and post- would be good?