SET FILTER TO Does Not Move Record Pointer

ID: Q119899

2.00 2.5x 2.6x | 2.5x 2.6x 3.00 | 2.5x 2.60a | 2.60

MS-DOS         | WINDOWS          MACINTOSH  | UNIX

kbprg

The information in this article applies to:

Microsoft Visual FoxPro for Windows, version 3.0
Microsoft FoxPro for MS-DOS, versions 2.0, 2.5x, 2.6x
Microsoft FoxPro for Windows, versions 2.5x, 2.6x
Microsoft FoxPro for Macintosh, versions 2.5x, 2.6a
Microsoft FoxPro for UNIX, version 2.6

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 reference words: VFoxWin 3.00 FoxUnix FoxMac FoxDos FoxWin 2.00 2.50 2.50a 2.50b 2.60 2.60a incorrect KBCategory: kbprg KBSubcategory: FxprgGeneral

Keywords          : FxprgGeneral 
Version           : 2.00 2.5x 2.6x | 2.5x 2.6x 3.00
Platform          : MACINTOSH MS-DOS UNIX WINDOWS