FlexCelReport.SqlParameterReplace Property
Format string for replacing the standard parameter names on DIRECT SQL commands. You can leave it empty for ODBC, OLEDB or SQLSERVER databases. See Also SqlParametersType
Remarks
On ADO.NET sql parameters can be defined on multiple ways, depending on the database you use. For example, SQL Server will use "@ParamName", while OLEDB will use "?" as parameter id. But, to keep templates database independent, you will always use "@ParamName" notation on the Direct SQL commands you write on templates. When using OLEDB, ODBC or SqlSever, FlexCel knows how to replace the correct parameters on the SQL on templates, but for more generic databases you might need to use this property. This is a standard .NET format string, where {0} will be replaced by the parameter name. For example, on Oracle database you might need to set this value to ":{0}" (without quotes) that will translate on ":ParamName"
Syntax
Namespace: FlexCel.Report
public String SqlParameterReplace { get; set; }
Examples
On oracle databases, you can set this property to ":{0}" (without quotes) It will create parameters of type ":ParamName".