>I have checked this out with other tables and it seems consistent. The problem is sorted, but I am a bit confused. Please let me know if you find the same behaviour.
>
>Thanks to you and to Bruce for all your help.
>
Sanjay,
I just checked this out and if I issue a select that produces a filtered alias to the orignal table, any and all indexecause the return of CDX(1,"Result") to be the CDX for teh original table. This is exactly as I would expect since that table is supposed to have its cdx open whenever the table is open.
As for the 1548 error, I create a PRG that issued the SELECT INTO a cursor, then displayed the dbf and cdx names and then issued a BEGIN TRANSACTION on th ecursor. The only error I got was when I issued a REPLACE command saying that the cursor was read only. The dbf was the original table and the cdx was that table's cdx. There was no difference between a character or dat index tag.
How exactly are you creating this cursor, is it a view or an SQL SELECT command? SELECT commands produce read only cursors and may have a temporary IDX file if you specified a GROUP BY or an ORDER BY.