>If you are always using NOFILTER or READWRITE options in your SELECT commands than you are safe. Otherwise, if SELECT conditions are Rushmore optimizable, VFP can just open the source table with USE ... AGAIN ALIAS ... and SET FILTER on it.


I either use SPT to get the cursor. Or create cursor. Or I create a subset cursor from other cursors. But there is Never any opened tables. Which is why I was unaware of the conditions you mentioned. Otherwise I'd have been here asking you why my counts are not right.

Since I'm still on VFP6 SP5 the READWRITE stuff is just a hope for the future. I still have to use the USE DBF() AGAIN method.