Icon TEDBStoredProc

Unit: edbcomps

Inherits From TEDBDBDataSet

Use the TEDBStoredProc component to prepare and execute a stored procedure or function. The parameter values for the stored procedure or function are automatically discovered when preparing the stored procedure or function, and then can be assigned values to be used when the stored procedure or function is executed. In addition, the component can execute stored procedures that return result sets and the returned result sets can be navigated and updated just like any other dataset. When executing functions, any result value can be read by examining the "Result" parameter that will automatically defined when preparing the function. This parameter will also have a TParam.ParamType value of ptResult.

Image