Instead of creating a CDX, try creating an IDX (INDEX ON fieldname TO filename.IDX instead of INDEX ON fieldname TAG fieldname). I just played with it and it works fine (VFP6 SP3 on NT4WS). IDX files are even deleted by themselves when you close the cursor.

---

>Hi Walter,
>
>So, if I create the cursor from the SQLEXEC() I can add as many indexes as I want. But when I copy that cursor into itself I can't. I was under the impression that a cursor is a cursor. When I copy it into iteslf do all the previous indexes dissappear?