Knowledge Base

SET FILTER TO Does Not Move Record Pointer

Article ID: 119899

Article Last Modified on 12/3/2003

Microsoft Visual FoxPro 3.0 Standard Edition
Microsoft FoxPro 2.0
Microsoft FoxPro 2.6a Professional Edition for Macintosh
Microsoft FoxPro 2.6 for SCO/UNIX

This article was previously published under Q119899

SUMMARY

Issuing a SET FILTER command does not move the record pointer, even if the record is currently located on a record that does not meet the filter condition. This is the expected behavior, as documented in the "Language Reference" manual and online Help system:

The condition specified by SET FILTER isn't evaluated until the record pointer is moved in the table/.DBF.

MORE INFORMATION

To move to a record that meets the FILTER condition, issue a command that moves the record pointer. For example:

   GOTO TOP

-or-

   LOCATE

Additional query words: VFoxWin FoxUnix FoxMac FoxDos FoxWin 2.50 2.50a 2.50b incorrect

Keywords: KB119899