TMSSQL.Params Property

Contains parameters for a query's SQL statement.

Class

TMSSQL

Syntax

property Params: TMSParams stored False;

Remarks

Contains parameters for a query's SQL statement.

Access Params at runtime to view and set parameter names, values, and data types dynamically (at design time use the Parameters editor to set the parameter information). Params is a zero-based array of parameter records. Index specifies the array element to access.

An easier way to set and retrieve parameter values when the name of each parameter is known is to call ParamByName.

See Also

• TMSParam
• ParamByName