IDalCursorField.Value

Syntax

Value: Variant;

Description

The Value property returns the value of the field of the current record in the cursor.

Comments

This property returns the value of the type that returns the GetDbDataType property. If a field has any custom data type, the field value can be accessed through a stream. To read more about working with custom type fields, use the knowledge base in the Working with Fields That Have Custom Data Type article.

Example

Executing the example requires that the repository contains a database with the BD identifier.

Add links to the Dal, Db, and Metabase system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    DB: IDatabaseInstance;
    Com: IDalCommand;
    Cur: IDalCursor;
    CurField: IDalCursorField;
    v: Variant;
Begin
    MB := MetabaseClass.Active;
    DB := MB.ItemById("BD").Open(Null) As IDatabaseInstance;
    Com := DB.Connection.CreateCommand("Select * From Table_1");
    Cur := Com.CreateCursor;
    CurField := Cur.Fields.Item(Cur.Fields.Count - 1);
    v := CurField.Value;
    Cur.Close;
    Com.Close;
End Sub UserProc;

After executing the example the connection to the BD database is established, after which the SQL query that selects all records from the Table_1 table is executed. The value of the last field of the first record of the received table is contained in the "v" variable.