TMacro.Active Property

Used to determine if the macro should be expanded.

Class

TMacro

Syntax

property Active: boolean default True;

Remarks

When set to True, the macro will be expanded, otherwise macro definition is replaced by null string. You can use the Active property to modify the SQL property.

The default value is True.

Example

MSQuery.SQL.Text := 'SELECT * FROM Dept WHERE DeptNo > 20 &Cond1';
MSQuery.Macros[0].Value := 'and DName is NULL';
MSQuery.Macros[0].Active:= False;