EPUB | CHM | PDF

TPSQLQuery.Methods.ParamByName

Top Previous Next

Accesses parameter information based on a specified parameter name.

Syntax:

function ParamByName(const Value: String): TParam;

Description:

Call ParamByName to set or use parameter information for a specific parameter based on its name.

Value is the name of the parameter for which to retrieve information.

ParamByName is primarily used to set an parameter's value at runtime. For example, the following statement retrieves the current value of a parameter called "Contact" into an edit box:

Edit1.Text := PSQLQuery1.ParamByName('Contact').AsString;

Parameters used in SELECT statements cannot be NULL, but they can be NULL for UPDATE and INSERT statements.