>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
Peter Robinson ** Rodes Design ** Virginia