Table of Contents

TFlexCelReport.AddSqlParameter Method

Adds an SQL parameter to use from the template on the DIRECT SQL commands. Note that the parameter must have a name even if you are using positional parameters ("?") because on the template you should always write named parameters.

Syntax

Unit: FlexCel.Report

procedure TFlexCelReport.AddSqlParameter(const parameterName: string; const parameter: TFlexCelSQLParameterMethod);

Parameters

<-> Parameter Type Description
const parameterName string The name of the parameter without special symbols, as it is written on the DIRECT SQL string. This might be different from the real parameter name.
For example, on SQL Server, parameterName might be "MyParameter" while parameter.ParameterName would be "@MyParameter"
const parameter TFlexCelSQLParameterMethod The parameter to add.

See also