>I bagged the select into cursor route I was taking and tried the use again with a different alias. Then I created some index tags to a temporary file. Like you said, the index file didn't automatically delete when I closed the new alias. I tried to use a delete tag all command to try and get rid of it, but since my original table isn't opened exclusive, it won't let me get rid of the tags. Is there a better way to clean up these extra index files, and if not, how can I check to see if the indexes exist before I add them. In other words, once I run my new routine and create the tags, it does great. If I do it again, it tells me the tags already exist and do I want to replace them. I'm trying to get rid of this prompt and clean up the mess.
>
First, which version and SP are you running? Bill says he didn't get the problem with the CDX hanging around, and when I just tried it, I didn't either. He's running SP3 and I'm running SP4.
If you do have the problem, and don't want to upgrade your SP, as I said, you must build the first index on the original cursor before you USE it AGAIN. Then the CDX will go away when you close the cursor.