Function ExecSQL( SQLStatement : String ): Variant

Description

Executes an SQL statement.

Parameters

• SQLStatement
• Specifies the SQL statement that must be executed.

Remarks

For example, you can use this object to run a stored procedure that would automatically select or deselect the Processed check boxes of a specific result set, or which would carry out a calculation before the cost estimate is printed.

Example

sub main()

Dim Successful

Dim From

Dim To

Dim SQL

From = Params.ParamValueByParamName("par01")

To = Params.ParamValueByParamName("par02")

SQL = "exec IP_prc_OrderConfDate @FromOrdNr = '" & From & "', @ToOrdNr = '" & To & "'"

Successful = Params.ExecSQL( SQL )

end sub