>>>You can create ONE _structural_ index, but you can create any indexes you want if they're not structural, i.e. not in the default file, but in a separate .cdx file. My standard procedure for this is
>>>
>>>lcCdx=lcSortWork+sys(3)
>>>
>>>index on [whatever] tag Tag1 of (lcCdx)
>>>index on [whatever] tag Tag2 of (lcCdx)
>>>index on [whatever] tag Tag3 of (lcCdx)
>>
>>Now that is correct! Thanks for pointing that out, I hadn't really considered that method of doing things, mainly because of the house keeping involved.
>>If you make your SQL select cursor R/W, you can create more than one tag in the structural CDX. However, this CDX will not automatically remove itself when the cursor is closed, even though it still has the same (root) name! It's still pretty easy to remove this file when you close the cursor and you don't have to worry about "scoping" on the variable for your separate CDX file name.
>
>You can index the R/O cursor like this, and then Use it Again - the .cdx should be usable, and should vanish when you close them. Didn't check this out, though.
I've always found that you can only put ONE tag on the R/O cursor. The second will give you an error about the fact that it is R/O and fail. Re-opening it again and THEN adding the tags works, but the temporary file for the CDX does not automaticaly get removed.