[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index]

Reference for unit 'SQLDB' (#fcl)

TCustomSQLQuery.ParamByName

Return parameter by name

Declaration

Source position: sqldb.pp line 563

public function TCustomSQLQuery.ParamByName(

const AParamName: string

AParamName

Name of parameter to look for. Case insensitive.

Resulting TParam instance.

ParamByName is a shortcut for Params.ParamByName. The 2 following pieces of code are completely equivalent:

Qry.ParamByName('id').AsInteger:=123;

and

Qry.Params.ParamByName('id').AsInteger:=123;

Params.ParamByName		Return a parameter by name
TSQLQuery.Params		Parameters detected in the SQL statement.