Dataset.Cancel

Syntax

function Dataset.Post(ADataset: pointer): boolean

Alternative Names

Description

Cancels modifications to the current row for for the dataset ADataset after editing or inserting a new row of data. Returns TRUE if successful, FALSE otherwise.

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.Insert(mydata); /* put into edit mode */

    Dataset.SetFieldValue(mydata, 'emp_name', 'Cancel this change');

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

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

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

    /* this row won't be added if you cancel */

    Dataset.Cancel(mydata);  

  finally

    Dataset.Close(mydata);

  end        

end