IQuery

Assembly: Db;

Description

The IQuery interface contains properties and methods of the Query repository object.

Inheritance Hierarchy

IQuery

Comments

When a new query is created, to ensure its correct work, determine the following minimum set of properties in the settings:

Database.
Sql or SqlText.

Properties

	Property name	Brief description
	AutoDefineStorage	The AutoDefineStorage property determines whether data saving settings are automatically defined at query saving.
	Database	The Database property determines a database, in which the query is stored.
	ParamsCheck	The ParamsCheck property determines whether parameters are considered at query execution.
	Sql	The Sql property determines the text of SQL query to a database of the Query object.
	SqlText	The SqlText property determines the text of SQL query to a database of the Query object for certain DBMS driver.
	Storage	The Storage property returns options for data saving.
	SubstituteAllParamsInQuery	The SubstituteAllParamsInQuery property determines whether all parameters values to query body on execution.

Methods

	Method name	Brief description
	ClearSqlText	The ClearSqlText method clears query text of object query.
	RefreshFields	The RefreshFields method updates the list of the Query object fields under the information from a database.

See also:

Db Assembly Interfaces | IDatasetModel | IDatasetInstance