Creation of SQL - query |
To create a new SQL-query on the page Data Sources of the Base Administrator create the Data module by clicking the Create button (or select in the tree the existing data module). After that on the screen a window of Form Constructor with the Data module appears. Onto the Data module place the components of ADO connection and ADO Query (the Bookmark of ADO Data access). Fill corresponding properties - the connection string, the query text. Window of Forming the query text:
Query editor and Query builder are intended for creation and execution of SQL-queries. |