Bde.DBTables.TStoredProc
| [–] Properties | |
|---|---|
| Type: class | |
| Visibility: public | |
| Source: Bde.DBTables.pas Bde.DBTables.hpp
| |
| Unit: Bde.DBTables | |
| Parent: Bde.DBTables | |
Delphi
TStoredProc = class(TDBDataSet)
C++
class PASCALIMPLEMENTATION TStoredProc : public TDBDataSet
Description
TStoredProc encapsulates a stored procedure in a BDE-based application.
Use a TStoredProc object in BDE-based applications to use a stored procedure on a database server. A stored procedure is a grouped set of statements, stored as part of a database server'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. TStoredProc provides a Params property that enables an application to set these parameters before executing the stored procedure.
TStoredProc reuses the Params property to hold the results returned by a stored procedure. Params is an array of values. 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.