Save query into table

Previous Top Next

ici_9093 The component provides automatic saving of SQL-query results into the data table.

Properties of a component are: Active, Table name, Name, Top, Left, Database path, SQL (query's text).

Table name -a filename is specified. It is selected by using the dialog of choosing a table from a set of DB tables definite by user in Base Administrator.

SQL (query's text) - contains a query text, on the basis of which the records are selected into the data set. The query includes the commands of SQL language. At creation of a query at the development stage it is possible to use the Query builder or Query editor.

Active - indicates onto necessity of query execution and saving of its result into the table.

At activation of the form the component Save query into table is always executed by the first. Due to this, the other components of the form may refer to the table, formed as a result of the query.