Finds a Macro with the name passed in Name.
function MacroByName(const Value: string): TMacro;
Call the MacroByName method to find a Macro with the name passed in Name. If a match was found, MacroByName returns the Macro. Otherwise, an exception is raised. Use this method rather than a direct reference to the Items property to avoid depending on the order of the entries.
To locate a parameter by name without raising an exception if the parameter is not found, use the FindMacro method.
To assign the value of macro use the TMacro.Value property.
MSQuery.SQL:= 'SELECT * FROM Scott.Dept ORDER BY &Order'; MSQuery.MacroByName('Order').Value:= 'DeptNo'; MSQuery.Open;