Calling a stored procedure

Topic group

When you want to call a stored procedure, use the StoredProc object. When a stored procedure returns a rowset, it can take the place of a Query object.

To call a stored procedure,

1. Drag a StoredProc object from the Component palette onto the design surface.

2. Set its procedureName property to the name of the stored procedure.

3. Set any parameters that are passed to the stored procedure in the params array.

4. Set its active property to true.