TPSQLStoredProc.Properties.Params

Stores the input parameters for a stored procedure.

Syntax:

property Params: TParams;

Description:

Access Params at runtime to set input parameter names, values, and data types dynamically (at design time use the Parameters editor to set parameter information or TPSQLStoredProc component editor). Params is an array of parameter values.

Unlike BDE TStoredProc, all parameters in TPSQLStoredProc.Params property have ParamType ptInput.

Example:

Set all parameters to an empty string:

with StoredProc1 do
for I := 0 to ParamCount - 1 do
Params[I].AsString := '';