Using TSQLStoredProc (Procedure)
Go Up to Using dbExpress
TSQLStoredProc represents a stored procedure that is executed using dbExpress. TSQLStoredProc can represent the result set if the stored procedure returns a cursor. You can add a TSQLStoredProc component to a form at design time, or create one dynamically at run time.
To use TSQLStoredProc
- From the dbExpress category of the Tool Palette, drag a TSQLStoredProc component to the form.
- In the Object Inspector, set its Name property to a unique value appropriate to your application.
- Set the SQLConnection property.
- Set the StoredProcName property to specify the stored procedure to execute.
- If the stored procedure returns a cursor to be used with visual data controls, add a data source component to the form.
- Set the DataSet property of the data source component to the stored procedure-type dataset.
- Provide input parameter values for the stored procedure, if necessary.
- To execute the stored procedure that returns a cursor, use the Active property or call the Open method.
- Process any results.