Query area

copy link

This chapter describes the features of objects corresponding to queries.

Query:	A query represents a code object that can send a query to the database to retrieve or modify the data it contains
Selected table	An in-query table is a table or view selected in the query, i.e., included in the query's from list
Query column	The query column object represents an expression of the query's Select list, and thus a column in the recordset returned by the query
Order By	The Order By object represents a sort condition for records returned by the query. Only data retrieval queries, apart from views, accept Order By criteria
Filter	The filter object represents a selection condition for records returned or modified by the query
In-query table field	An in-query table field represents a reference to the fields owned by the table selected in the query, i.e., included in the query's from list

Changed on: 15/12/2022 / From version: 8.5.3800