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
>>
>>