TADCustomCommand.ParamBindMode Property

Determines the order in which a component’s parameters are assigned to the parameter list for SQL command on the DBMS.

Group

Links

TADCustomCommand Class, TADCustomCommand Members, uADCompClient Namespace, public, See Also

Get or set ParamBindMode to determine the order in which parameters in the Params property are matched to the parameters used by the SQL command on the server. ParamBindMode can be one of the following:

Value	Ordering
pbByName	Parameters specified in the Params property are matched to identically named parameters on the server. This is the default.
pbByNumber	Parameters in Params are assigned one-by-one to the next available parameter on the server (for example, the first parameter in Params is assigned to the first parameter used by the SQL command, and so on).

Whenever possible, ParamBindMode should be pbByName. This guarantees that parameters are matched to the correct parameters used by the SQL command regardless of physical ordering in Params. At design time, the names of known parameters appear in the Parameters editor.

Syntax

property ParamBindMode: TADParamBindMode;