The following information is extracted from the format file and applied to the Browse window:įield sizes (as specified in PICTURE clauses)Īll SAY expressions (included as calculated BROWSE fields) The format file must first be opened with SET FORMAT. Specifies the use of a format file to control the display and data-entry format in a Browse window. Otherwise, BROWSE positions the record pointer at the top of the table by default. Prevents the record pointer from being moved from its current position to the top of the table when a Browse window is opened with the FOR clause. Include REST to keep the record pointer at its current position. Include FOR to move the record pointer to the first record meeting the condition. For information on Rushmore optimizable expressions, see SET OPTIMIZE and Using Rushmore Query Optimization to Speed Data Access. For best performance, use an optimizable expression in the FOR clause. Rushmore Query Optimization optimizes a query specified with a BROWSE FOR if lExpression1 is an optimizable expression. Specifies a condition whereby only records for which lExpression1 is true are displayed in the Browse window. OPEN DATABASE (HOME(2) + 'data estdata')īROWSE FIELDS contact FONT 'System', 15 STYLE 'NU'īROWSE FIELDS contact FONT 'Geneva', 14 STYLE 'NU' See the GETFONT( ) Function for a list of available language script values.įor example, the following clause specifies 16-point Courier font for the fields displayed in a Browse window: You can specify a language script with nFontCharSet. The character expression cFontName specifies the name of the font, and the numeric expression nFontSize specifies the font size.

Specifies the Browse window's font and font size.

If you omit FIELDS, all the fields in the table are displayed in the order they appear in the table structure.įONT cFontName] When you include a field from a related table, preface the field name with its table alias and a period. You can include fields from other related tables in the field list. The fields are displayed in the order specified in FieldList. Specifies the fields that appear in the Browse window.

Foxpro 2.6 commands with example