TCustomDADataSet.MacroByName Method

Finds a macro with the specified name.

Class

TCustomDADataSet

Syntax

function MacroByName(const Value: string): TMacro;

Remarks

Call the MacroByName method to find a macro with the specified name. If a match is found, MacroByName returns the macro. Otherwise, an exception is raised. Use this method instead of a direct reference to the TMacros.Items property to avoid depending on the order of the items.

To locate a parameter by name without raising an exception if the parameter is not found, use the FindMacro method.

To set a value to a macro, use the TMacro.Value property.

Example

MSQuery.SQL:= 'SELECT * FROM Scott.Dept ORDER BY &Order';
MSQuery.MacroByName('Order').Value:= 'DeptNo';
MSQuery.Open; 

See Also

• TMacro
• Macros
• FindMacro