>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
Do you want .f. at the top or bottom?
If at the top, you may use
iif(CheckStub,'N','Y') + vendCode
Or use transform(CheckStub) + VendCode (and check transform function codes).
If it's not broken, fix it until it is.
My Blog