Refresh Window
Purpose 
Updates the entire contents of the FileMaker Pro document window, including any related records.
Format 
Refresh Window [Flush cached join results; Flush cached SQL data]
Options 
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.
Compatibility 
 
Where the script step runs 
Supported 
FileMaker Pro 
Yes 
FileMaker Server scheduled script 
Yes 
FileMaker Go 
Yes 
Custom Web Publishing 
Yes 
Instant Web Publishing 
Yes 
Runtime solution 
Yes 
Originated in 
FileMaker Pro 6.0 or earlier
Description 
You do not need to select Flush cached join results in order to refresh the entire window.
This script step updates records (rows) in the current ODBC table.
Examples 
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
Related topics 
Script steps reference (alphabetical list)
Script steps reference (category list)
Updating data between FileMaker and ODBC data sources
Was this topic helpful? Send feedback.