Add MERGE/REPLACE option to OUTPUT DATASET parameter passing syntax

  • Thread starter Thread starter Lieven De Foor
  • Start date Start date
Status
Not open for further replies.
L

Lieven De Foor

Guest
Currently there is a possibility to add records to a client side dataset from a dataset passed as output parameter using the APPEND option: RUN AddData(param1, param2,... OUTPUT DATASET MyDataset APPEND ). This only works if the records being added don't already exist in the target dataset (no unique key violation). I would like to be able to replace or merge records in the already existing dataset, with those in the dataset returning from the method/procedure, just like the dataset FILL-MODE attribute provides to the FILL() method. Now you have to create an extra dataset to hold the data returned from the method/procedure, and manually merge the records in the already existing dataset. If a MERGE/REPLACE option was present, this extra step would no longer be needed. Eg. RUN FillDataSet(param1, param2, ... OUTPUT DATASET MyDataset). RUN RefreshRecord(RecordId, OUTPUT MyDataset MERGE/REPLACE).

Continue reading...
 
Status
Not open for further replies.
Back
Top