IDalCommandParam.Name

Syntax

Name: String;

Description

The Name property returns the name of the SQL query parameter that is used to execute the command at the database server.

Example

Sub Main;

Var

MB: IMetabase;

DB: IDatabaseInstance;

Com: IDalCommand;

Params: IDalCommandParams;

Param_List: IStringList;

i: Integer;

Begin

MB := MetabaseClass.Active;

Param_List := New StringList.Create;

DB := MB.ItemById("BD").Open(Null) As IDatabaseInstance;

Com := DB.Connection.CreateCommand("");

Com.SQL := "Select * From Table_1 Where Num1 > :Param And Num2 < :Param1";

Com.Parse;

Params := Com.Params;

For i := 0 To Params.Count - 1 Do

Param_List.Add(Params.Item(i).Name);

Params.Item(i).Value := (i + 2) * 10;

End For;

Com.Execute;

Com.Close;

End Sub Main;

After executing the example the connection to the BD database is established and the SQL query that extracts all records from the Table_1 table, for which the values of the Num1 and Num2 fields satisfy the assigned parameters, is executed. The Param_List variable contains a list of the SQL query parameters that are used to execute the command.