Script Steps Reference

86 FileMaker Script Steps Reference
Refresh Window
Format
Refresh Window
Option
Select Flush cached join results to delete the results of queries for related records and
cause related records to be refreshed. Do not select this option if you know your script
does not affect related data, and if you want to minimize the performance impact of re-
accessing related data (particularly when sharing a database over a network).
Select Flush cached SQL data to delete the results of queries for related ODBC data
source records and cause related ODBC records to be refreshed. FileMaker Pro dumps
the internal cache and refreshes record data. Do not select this option if you know your
script does not access ODBC data.
Web compatibility
This script step is web-compatible.
Description
Updates the entire contents of the FileMaker Pro document window, including any related
records. You do not need to select Flush cached join results in order to refresh the entire
window.
Updates records (rows) in the current ODBC table.
Example
Go to Record/Request/Page [First]
Loop
Set Field [Table1::Salary; Table1::Salary * 1.1]
Go to Record/Request/Page [Next; Exit after last]
End Loop
Refresh Window
Beep
Scroll Window
Format
Scroll Window [Home/End/Page Up/Page Down/To Selection]
Options
Use Specify to choose a scrolling option.
• Home, End, Page Up, or Page Down scrolls the window to the beginning, to the
end, up a page, or down a page.
• To Selection brings the current field into view (similar to tabbing into a field).