Top Previous Next

Returns the query object used to perform a specified kind of update.


property Query[UpdateKind: TUpdateKind]: TPSQLQuery;


Query is a read-only property that provides a reference to the internal TPSQLQuery that executes the SQL that applies the data updates. Use properties and methods of TPSQLQuery to work with this reference.

Using one of the TUpdateKind constants as an index for the Query property, the internal TPSQLQuery object will have the SQL specified in the corresponding update SQL property: DeleteSQL, InsertSQL, or ModifySQL. UpdateKind can be one of the following:


Return the query object used to execute DELETE statements (DeleteSQL).


Return the query object used to execute INSERT statements (InsertSQL).


Return the query object used to execute UPDATE statements (ModifySQL).

Each query object executes a particular kind of SQL statement. The contents of the SQL statements executed by these objects can be accessed directly using the ModifySQL, InsertSQL, and DeleteSQL properties.

The main purpose of Query is to provide a way for an application to set the properties for an update query object or to call the query object's methods.

If a particular kind of update statement is not provided, then its corresponding query object is nil. For example, if an application does not provide an SQL statement for the DeleteSQL property, then setting Query[ukDelete] returns nil.