TLogicalSqlUpdateOperation

Facilitates implementing a logical SQL operation though a temporary table containing an update result

Inheritance

Level	Ancestor	Description
1	TObject	Ultimate ancestor in a class hierarchy
2	TLogicalSqlUpdateOperation

Source

Sql.Database.Logical.UpdateOperation.pas (35)

Fields

Scope	Visibility	Type	Name	Description
Instance	private	TSqlTable	FTable
Instance	private	TList<TSqlTableColumn>	FColumns
Instance	private	TList<TSqlTableColumn>	FManagedColumns
Instance	private	TList<TSqlTableColumn>	FUnmanagedColumns
Instance	private	TList<TSqlTableColumn>	FPrimaryKeyColumns
Instance	private	TSqlTable	FTemporaryTable
Instance	private	TMap<TSqlTableColumn,TSqlTableColumn>	FToTemporary
Instance	protected	TSqlDatabase	Database

Methods

Scope	Visibility	Result	Name	Description
Instance	private	TSqlPhysicalTable	CreateTemporaryTable(Identifier: TText)
Instance	private	TList<TSqlTableColumn>	CreateManagedColumns()
Instance	private	TList<TSqlTableColumn>	CreateUnmanagedColumns()
Instance	private	TList<TSqlTableColumn>	CreatePrimaryKeyColumns()
Instance	private	TSqlExpression	CreateColumnEquals(Column: TSqlTableColumn)
Instance	protected	TBoolean	IsManagedColumn(Column: TSqlTableColumn)
Instance	public		Create(Database: TSqlDatabase; TemporaryIdentifier: TText; Table: TSqlTable; Columns: TList<TSqlTableColumn>)
Instance	public		Destroy()
Instance	public		FillTemporaryTable(Select: TSqlSelect)
Instance	public		FillTemporaryTable(Rows: TList<TSqlRow>)
Instance	public		AddManagingColumns(InsertSelect: TSqlInsertSelect)
Instance	public	TSqlExpression	CreateRowEquals()
Instance	public	TSqlExpression	CreatePrimaryKeyEquals()
Instance	public	TSqlExpression	CreateUniqueKeyEquals()
Instance	public	TSqlExpression	CreatePresentRestriction()
Instance	public		ValidateManagedColumns()
Instance	public		CheckKeyViolation()