Data.Win.ADODB.TADOStoredProc
Delphi
TADOStoredProc = class(TCustomADODataSet)
C++
class PASCALIMPLEMENTATION TADOStoredProc : public TCustomADODataSet
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| class | public | Data.Win.ADODB.pas Data.Win.ADODB.hpp |
Data.Win.ADODB | Data.Win.ADODB |
Description
TADOStoredProc encapsulates a stored procedure in an ADO database.
Use a TADOStoredProc object when a client application must use a stored procedure in a database. A stored procedure is a grouped set of statements, stored as part of a database's metadata (just like tables, indexes, and domains), that performs a frequently repeated, database-related task on the server and passes results to the client.
Note: Not all database servers support stored procedures. See a specific server's documentation to determine if it supports stored procedures.
Many stored procedures require a series of input arguments, or parameters, that are used during processing. TADOStoredProc provides a Parameters property that enables an application to set these parameters before executing the stored procedure.
TADOStoredProc reuses the Parameters property to hold the results returned by a stored procedure. Parameters is a collection of TParameter objects, each representing an individual parameter for the stored procedure. Depending on server implementation, a stored procedure can return either a single set of values, or a result set similar to the result set returned by a query.