>As far as NOFILTER, I recommend it for situations where you're displaying a cursor, that's one of two situations where I've encountered problems, with grids suddenly displaying non-sensical results to users.

So my select/browse pick-lists (which I use quite a bit and like) would be a candidate for NOFILTER. BTW, the only thing I don't like about these is that the user must press Escape to select the record. No way around that I suppose.


>The other is maybe worse, when you USE DBF() AGAIN to make a write cursor, this will cause a crash if a filtered table is the SQL result...

Will watch out for that.


>I use NOFILTER now almost always in code for one-table SQL to cursors, but usually not in Command window table queries, where I want quick results and don't need to do anything else with cursor...

Muchas gracias for the tips.

Peter