Microsoft KB Archive/106701

{| = BROWSE REST Description Incorrect in FoxPro 2.5 =
 * width="100%"|

ID: Q106701

The information in this article applies to:


 * Microsoft FoxPro for MS-DOS, versions 2.5, 2.5a, 2.5b
 * Microsoft FoxPro for Windows, versions 2.5, 2.5a, 2.5b

SUMMARY
Page L3-247 in the "Language Reference" incorrectly describes the use of the BROWSE REST command. (It is correctly documented in the FoxPro version 2.0 for MS-DOS "Commands & Functions" manual.) The BROWSE REST definition in the 2.5 documentation states the following:

By default, BROWSE positions the record pointer at the top of the table/.DBF. Include REST to prevent the record pointer from being moved from its current position to the top of the table/.DBF. This statement is incorrect. It should say: By default, BROWSE with a FOR clause positions the record pointer at the first record that matches the FOR condition. Include REST to  prevent the record pointer from being moved from its current position.

MORE INFORMATION
The BROWSE REST command must be used in conjunction with the FOR clause to have any effect. By default, BROWSE keeps the record in the same position unless you use a BROWSE FOR command to narrow your criteria. If you are currently on a record that matches the filter criteria, you can use the REST clause to keep the record pointer on the same record. If the current record doesn't match the criteria, the record pointer moves to the next record in index order that matches the FOR condition. If there are no records that match the FOR condition after the current record position, the record pointer moves to the last record that matches the FOR condition. If you do not use the REST clause with the FOR clause, the record pointer always positions itself on the first record that matches the FOR condition.

Additional reference words: FoxDos FoxWin 2.50 2.50a 2.50b docerr KBCategory: kbprg kbdocerr KBSubcategory: FxprgBrowse
 * }