Creating a Query Using a Stored Procedure

To create a query based on a stored procedure:

1. Open the VisiconX Data Control OLE Properties dialog box. For information on how to do this in your product, refer to the Accessing VisiconX OLE Control Properties section.
2. From the Record Source tab, in the Command Type drop-down list box, select Stored Procedure.
3. Enter a stored procedure name in the Stored Procedure drop-down list box.
4. Click List Parameters to display the query properties mapped to the stored procedure parameters.
5. Click OK.
6. Animate the query properties that map to the input parameters for the stored procedure.

NOTE: CIMPLICITY users need to use CimEdit Basic script to use query properties.  For more information, see Using Query Properties in CIMPLICITY.

 

See Also