Skip to content

TSQLQuery.UpdateMode

How to create update SQL statements.

Declaration

Source position: sqldb.pp line 749

published property UpdateMode;

Description

UpdateMode determines how the WHERE clause of the UpdateSQL and DeleteSQL statements are auto-generated.

upWhereAll
Use all old field values.
upWhereChanged
Use only old field values of modified fields.
upWhereKeyOnly
Only use key fields in the where clause.

See also

Name Description
TSQLQuery.UpdateSQL Statement to be used when updating an existing row in the database.
TSQLQuery.InsertSQL Statement to be used when inserting a new row in the database.