Updated: 2023-09-20
OLE DB Property of Rowset and Command — «refresh_sql»
Name:
refresh_sql
Type:
VT_BSTR
R/W:
R/W
Default:
EMPTY
IBProvider:
3, 5
Defines SQL query for re-reading of row data. The provider allows the use only of «OLD» parameters in query text.
Example: «SELECT * FROM MY_TABLE WHERE ID=:OLD.ID»
See also
- The rowset property insert_sql
- The rowset property update_sql
- The rowset property delete_sql
- The rowset property named_param_prefix
- The rowset property auto_insert_field_rule
- The rowset property auto_update_field_rule
- The rowset property Server Data on Insert
- The initialization property server_data_back_read