system.db.refresh
This function is used in Python Scripting.
Description​
This function will programmatically cause a SQL Query or DB Browse property binding to execute immediately. This is most often used for bindings that are set to Polling - Off. In this way, you cause a binding to execute on demand, when you know that the results of its query will return a new result. To use it, you simply specify the component and name of the property on whose binding you'd like to refresh.
Client Permission Restrictions​
Permission Type: Legacy Database Access
Client access to this scripting function is blocked to users that do not meet the role/zone requirements for the above permission type. This function is unaffected when run in the Gateway scope.
Syntax​
system.db.refresh(component, propertyName)
Parameters​
| Type | Parameter | Description |
|---|---|---|
| JComponent | component | The component whose property you want to refresh |
| String | propertyName | The name of the property that has a SQL Query binding that needs to be refreshed |
Returns​
Boolean - True (1) if the property was found and refreshed successfully.
Scope​
All
Code Examples​
# This example could be placed in the actionPerformed event of a Button, to be used to refresh the data of a Table.
# Remember to use the scripting name of the property that you're trying to refresh, and that the property names are case-sensitive.
table = event.source.parent.getComponent("Table")
system.db.refresh(table, "data")