executeTemplateSQL(String) Method

concatenate parameters into SQL template string through replacing the placeholders by the values given in paramRanges and execute the final SQL, empty values and excel errors get a NULL value.

Namespace: DBaddinAssembly: DBaddin in (DBaddin.dll)

Syntax

private int executeTemplateSQL(
	string paramString
	)

Parameters

paramString: Type: String
SQL template string, the parameter placeholders are identified with !1!, !2!, ... (assuming ! is the default paramEnclosing)

Returns

Int32