TMedQuery.SQL TMedQuery

property SQL: TStrings ;

Description

Use this property to specify SQL statement to be executed when ExecSQL or Open method is called. It may contain one SQL statement with syntax valid for the database standing behind Mediator.

The specified SQL statement may contain replaceable parameters, as defined in standard SQL-92 syntax conventions (i.e. colon followed by parameter name). Corresponding actual parameters should be created and stored in the Params property.

Example:

qry.SQL.Add('select * from TEST where FN >= :minval and FN <= :maxval');