Dataset.SetField

Syntax

function Dataset.Edit(ADataset: pointer): boolean

Alternative Names

Description

Modifies the data for the current row of dataset ADataset after putting this dataset into edit mode. You can then use Dataset.Cancel to revert to the original data, or Dataset.Post to modify the underlying table. In order to be able to edit row data, you need to have the primary key column(s) in the dataset SELECT clause.

See also

Example

execute udsblock()

as

declare variable resultbool boolean;

begin

  /* create the data set */

  select employeeid, emp_name, salary, bonus_perc

  from test_data order by employeeid

  as dataset mydata;

  try 

    Dataset.Edit(mydata); /* put into edit mode */

    Dataset.SetFieldValue(mydata, 'emp_name', 'Harold');

    Dataset.Post(mydata);

    resultvarchar = Dataset.FieldValue(mydata, 'emp_name');

    Dataset.Append(mydata); /* insert new row and put in edit */

    Dataset.SetFieldValue(mydata, 'emp_name', 'Frank');

    Dataset.SetFieldValue(mydata, 'employeeid', 49998);

    Dataset.SetFieldvalue(mydata, 'salary', 100);

    Dataset.SetFieldValue(mydata, 'bonus_perc', 0);

    Dataset.Post(mydata);

  finally

    Dataset.Close(mydata);

  end        

end