One reason might be a corrupted index. Try to reindex.
>When I run my form, it has always worked properly, but all of a sudden something has gone wrong, which makes me think that this is a data issue. When I extract the SQL code out of my form's Local View and run it while in debug mode, I am able to generate a result.
>
>But, when I use the same local view (containing the same SQL code), it doesn't obtain the result at all and comes up with an empty data set. Is there some quirk in VFP Local Views that does this on occasion?
>...
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)