Table of Contents

TUpdateCommand Class

Describes an UPDATE statement, including the target table, the fields to modify, and the WHERE conditions that identify the rows to update.

Syntax

Unit: Aurelius.Sql.Commands

TUpdateCommand = class(TDMLCommand);

Constructors

Name Description
Create Creates a TUpdateCommand with empty update-field and where-field lists.

Properties

Name Description
UpdateFields Gets or sets the list of columns and their new parameter-​placeholder values for the SET clause.
WhereFields Gets or sets the list of structured WHERE conditions that identify rows to update.
WhereStatement Gets or sets a raw SQL fragment appended to the WHERE clause.