Cursor.FieldValue

Syntax

function Cursor.GetField(Crsr: pointer; FieldSpecifier: variant): variant

Alternative Names

Description

Returns the value of the field specified by FieldSpecifier for cursor Crsr. The FieldSpecifier can be an integer based field index (starting at zero) or a field name.

See also

Example

execute udsblock()

as

begin

  /* create the cursor */

  mydata = Cursor.Create('select * from UDS$TEST_DATA');

  try

    GUI.ShowMessage('Number of fields in the cursor: ' || Cursor.FieldCount(mydata));

    /* get field names and current values */

    n = 0;

    while (n < Cursor.FieldCount(mydata))

    do begin

         GUI.ShowMessage('Field name: ' + Cursor.FieldName(mydata, n) || String.CRLF() + 'Value: ' + Cursor.FieldValue(mydata, n));

         n = n + 1;

       end

  finally

    Cursor.Close(mydata);

  end        

end