Accuracer: The First And Only Cross-Platform BDE Replacement
Client-Server Single-File Embedded Database with SQL for Delphi / C++Builder / Kylix


TACRQuery.ParamByName
TACRQuery
Top 

Accesses parameter information based on a specified parameter name.

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

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


© AidAim Software Accuracer: Client-server Database Single-file Database Delphi Database Embedded Databas