Sign in Join
FPDoc Onlineexperiment

TCustomSQLQuery.Macros property

Member of TCustomSQLQueryprotectedIn unit SQLDB

Set of macros for this SQL statement.

Declaration

pascal
property Macros: TParams read GetMacros write SetMacros stored HasMacros;

Description

Macros is a collection of named macro values. In difference with Params the macro value is always replaced textually in the SQL statement before it is sent to the SQL engine. This allows you to parametrize parts of the SQL statement that the SQL engine will not let you parametrize: the table name, the order by clause or an IN clause in a SQL select statement. Macros are resolved before parameters are resolved.

See also

An experiment, built from development snapshots. Not the official Free Pascal or Lazarus documentation.