TfrxBDEQuery The component is used for performing SQL-queries to DB. The component has the following properties:
Property | Description
Active | Defines whether a query is active.
DatabaseName | DB alias name.
FieldAliases | Allows to set user’s field aliases.
Filter | Expression for records’ filtering.
Filtered | Defines whether it is necessary to use the filter.
Master | Data master-set.
Params | The list of query parameters.
SQL | Query text.
The "Active," "DatabaseName," "FieldAliases," "Filter," "Filtered," and "Master" properties are similar to the properties of the "TfrxBDETable" component described above. The "SQL" property has its own editor for filling the SQL-query. The "Params" property also has its editor. It becomes available as soon as a query text contains parameters. A parameter can be of two types: either one assigned from the master-source or one having a concrete value (either an absolute symbol or a link to the variable or object’s property, as it is shown in the picture, can act as a value). In case when a parameter is taken from the data master-set, it is necessary to adjust the "TfrxBDEQuery.Master" property. The data set must contain a field with the name coinciding with the name of the parameter. At the same time, it is necessary to specify neither a parameter type, nor its value.