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