Bde.DBTables.TQuery.ParamByName

• Up to Parent: TQuery

Delphi

function ParamByName(const Value: string): TParam;

C++

Data::Db::TParam* __fastcall ParamByName(const System::UnicodeString Value);

Properties

Type	Visibility	Source	Unit	Parent
function	public	Bde.DBTables.pas Bde.DBTables.hpp	Bde.DBTables	TQuery

Description

Accesses parameter information based on a specified parameter name.

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 := Query1.ParamByName('Contact').AsString;

Edit1->Text = Query1->ParamByName("Contact")->AsString;

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

See Also

• System.UnicodeString

• Params