it happens to everyone- I did worse e.g. answering a FP2.x q. with VFP5 solution etc. (s) Arnon >Arnon, you're right, I'm wrong. I use more SQL than Views, and my fingers >didn't let my brain catch up. Thanks for the quick catch. > >Barbara > >>Barbara, any view (parameterized or not) will always create a temporary >>table >>NOFILTER is for use with regular SELECT SQL cursors >> >>Arnon >>>Given all this hassle, why don't you use a parameterized view instead of >a >>>filter. If you're using VFP5, use the NOFILTER clause, and if VFP3 add >a >>>'nonsense' field to force a cursor not a filtered table. Then your >>>reccount() and Recno() values are always correct. >>> >>>HTH >>>Barbara >>> >>> > >