|Top Previous Next|
This component executes SQL queries on a DB. It has the following properties:
The “Active”, “DatabaseName”, “FieldAliases”, “Filter”, “Filtered” and “Master” properties are similar to those of the “TfrxADOTable” component described above. The “SQL” property has its own editor for entering the SQL query.
The “Params” property also has its own editor. It is enabled when a Query text contains parameters.
A parameter can be one of two types : its value either derived from the master-source or set as a discrete value (either an absolute value, as shown above, or linked to a variable or to an object property).
When a parameter is derived from the data master-set the “TfrxADOQuery.Master” property has to be set. This dataset must contain a field of the same name as the parameter. Neither the parameter type nor its value has to be specified.