Auto-Refresh Mode

When auto-refresh mode is enabled, an INSERT or UPDATE operation on the database is followed immediately by a request to the database for the inserted or updated row. The row obtained via this request replaces the inserted or updated row in the IliSQLTable object.

This is useful in either of the following situations:

• The database contains triggers that can alter inserted or modified rows.

• The selected list of the SQL SELECT statement contains formulas (for example, PRICE * QTY) that need to be recalculated each time the row changes.