Input Arguments (Magic xpa 4.x)
You can insert a colon (:) followed by a number anywhere in your Direct SQL command as a property designator. The colon plus number combination is replaced by the property value specified in the SQL Command dialog box’s Input Argument table. The properties are computed just before the SQL Command is prepared, and Magic xpa replaces the property designator with the computed value in the SQL statement’s text. The statement is then passed to the RDBMS for syntax evaluation and execution.
The SQL command syntax is always re-evaluated before the command is executed, regardless of the Resident Task property value (in the Task Properties dialog box). Generally, Input arguments are used as placeholders for SQL WHERE clauses.
BLOB variables are not supported as input parameters when working with an MSSQL database.
Arguments
Argument Repository
Argument Passing
