SDAC

TMSSQL.ParamByName Method

Sets or uses parameter information for a specific parameter based on its name.

Class

TMSSQL

Syntax

function ParamByName(const Value: string): TMSParam;

Parameters
Value
Holds the Parameter value.
Return Value
the parameter, if a match was found. Otherwise, an exception is raised.

Remarks

Call the ParamByName method to set or use parameter information for a specific parameter based on its name. Name is the name of the parameter for which to retrieve information. ParamByName is used to set the parameter's value at runtime and returns a TMSParam object.

Example

For example, the following statement retrieves the current value of a parameter called "Contact" into an edit box:

Edit1.Text := Query1.ParamsByName('Contact').AsString; 

See Also

© 1997-2019 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback