Dataset.Insert

Syntax

function Dataset.Insert(ADataset: pointer): boolean

Alternative Names

Description

Inserts a new row into dataset ADataset and set it into an 'edit state' so you can modify the new rows data using Dataset.SetField. You can then use Dataset.Cancel to stop inserting the new row, 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.Insert(mydata); /* insert new row and put in */

    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);

    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);  

    Dataset.Cancel(mydata);  

  finally

    Dataset.Close(mydata);

  end        

end