ADO Query

ADO query. The component serves for definition of the SQL-operators, allowing to provide access to one or several tables in a source of data.

Properties of a component: Active, ADO connection name, SQL.

Active - operates activation of query.

ADO connection name - the reference to ADO connection component that provides the management of connection with objects of ADO data store.

SQL - contains the text of query on the basis of which the records into a data set are selected. The query includes commands of SQL language and is carried out at opening a data set. At formation of query the editor for input of text of SQL query is called. At forming the query it is possible to use Query builder - the editor, allowing to input and to carry out SQL - queries.