Skip to content

SQLCall - cSQLStatement

Calls a stored procedure or function

Type: Procedure

Syntax

Procedure SQLCall

Call Example

Send SQLCall

Description

Calls a stored procedure or stored function. The procedure specifics must have been setup by calls to the SQLSetProcedureName and SQLSetArgument messages.

Use SQLOpen and SQLClose to allocate and de-allocate statement handles. You need to close a statement handle whenever the statement changes.

See the StoredProcedureMSSQL.vw and StoredProcedureODBC.vw views in the Specialized Components sample workspace for samples of calling a stored procedure.

While stored procedures can be called using other methods, using SQLCall makes the call database-independent.