>I'm using VFP 6 tables.
>Yau
I see.
Could you please post one of your select statements? Do you have an index on DELETED()? What is SET DELETED status and SET ANSI status?
If you have all necessary indexes you may run into situation when VFP tries to put a filter on your table instead of creating an actual cursor. In VFP6 the only way to force the actual cursor creation would be to list all the fields in the different order of table's fields or add an extra field or ommit some fields.
One more important note. Please check CPDBF() and cpcurrent. They should match.
If it's not broken, fix it until it is.
My Blog