>>>>>All,
>>>>>
>>>>>I am querying a VFP table that has about 1.5 million records. The table is indexed on a date field called aaddb. My query shows that it returned 13,533 records on the status bar. Then the status bar message changes and it states: Tcursor(c:\arrestees.dbf) Record: 24/1427204.
>>>>>Only the records I have selected show in the browse window. However if I do a ?reccount() it shows that there are 1427204 records in my cursor. If I select all of the records from the cursor into a new cursor I get all 1427204 records from the original table.
>>>>>
>>>>>This is my query.
>>>>>

>>>>>SELECT * FROM arrestees where BETWEEN(aaddb, CTOD('12/30/1939'), CTOD('12/29/1941')) into cursor tCursor
>>>>>

>>>>>
>>>>>How can I get just the records I am trying to select? This is a new one on me.
>>>>
>>>>That's a long-known issue. If the query is 100% rushmore optimizable, vfp may just do a SET FILTER. I have been adding NOFILTER to every query for many years now.
>>>
>>>Personally I add READWRITE in stead of NOFILTER. The net result is the same plus the new cursor is read/write.
>>
>>Personally I put them both in. Aiming to leave no doubt with the reader.
>
>That's a good point, but if a cursor is not going to be updated, I still put nofilter, just don't include readwrite. Readwrite must do more than just NOFILTER?

Yes, I should have been clearer (as I try to be in my code < s >).
I meant that when I need both I do code both, even if the one implies the other.
I ***ALWAYS*** code NOFILTER but only sometimes code READWRITE... when I'm going to be updating the cursor.

cheers