Unit 'SQLDB'	Package
[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index]	[#fcl]

TCustomSQLQuery.ParamByName

Return parameter by name.

Declaration

Source position: sqldb.pp line 608

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.