>> >
>> Yes, I found that with the select(viewless) cursor that I generated, I
>> could not create more than one index tag, nor could I change the tag once
>> it was created, for the CDX file with the same temporary name as the
>> cursor (I got a "read only file" error). This causes me to use the "index
>> on whatever tag whatever of somefile" which file I have to erase when I'm
>> done.
>
>I don't think so - any index on a cursor (whatever the source and way of
>creating it) vanishes when the cursor is closed. Still, I didn't check
>this for VFP (I think it defaults to FP behaviour), but if it didn't
>work I would have found tons of dead .cdx'es on my disk by now. I simply
>forget to delete them - if VFP closes cursors, their indexes vanish.

Yes, I tried this out and the indexes do go away. Thanks for the info, I thought that was only true for the main CDX file, but I created two ADDTIONAL CDX's on two different directories and they went away when the cursor did.

Still wondering though what the advantage would be to using select statements vs views. When I tried to use a select statement for my grid, the cells in the grid disappeared when I closed the cursor to run the select again. I'm probably doing something wrong here, since I am used to using views with grids, and just requery()ing.