Microsoft KB Archive/119899

= SET FILTER TO Does Not Move Record Pointer =

Article ID: 119899

Article Last Modified on 12/3/2003

-

APPLIES TO


 * 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.