[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] Reference for unit 'SQLDB' (#fcl)


Refresh query to re-fetch field values after a DB update


Source position: sqldb.pp line 701

published property TSQLQuery.RefreshSQL : TStringList;


RefreshSQL can be used to specify a SQL statement that is executed after an UPDATE or INSERT operation. The query will be executed, and the values of all fields in the result set will be copied to the dataset. This SQL statement is only executed during the ApplyUpdates operation, not during the Post call itself.

A RefreshSQL can be constructed automatically by SQLDB by setting the pfRefreshOnUpdate or pfRefreshOnInsert flags in the ProviderFlags of the fields in the dataset, depending on whether the operation was an update or insert.

For SQL engines that support RETURNING clauses, the RETURNING clause will be used to refresh field values, unless sqoPreferRefresh is specified in TSQLQuery.Options

See also




Options controlling the behaviour of the dataset

Documentation generated on: May 14 2021