Dataset.GetField

Syntax

function Dataset.GetField(ADataset: pointer; FieldSpecifier: variant): variant

Alternative Names

Description

Returns the value of the field specified by FieldSpecifier for given dataset ADataset. 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 data set */

  select employeeid, emp_name, salary, bonus_perc

  from test_data order by employeeid

  as dataset mydata;

  try

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

    /* get field names and current values */

    n = 0;

    while (n < Dataset.FieldCount(mydata))

    do begin

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

         n = n + 1;

       end

  finally

    Dataset.Close(mydata);

  end        

end