I’m hoping this is an easy one. Is there a way to “clone” the tables/data from one tableset to another? For example, in a pre-processing method directive I have the ds that is the default tableset for that BPM. I have created my own version in a code block and pulled in some data and updated some ro…

[image] dr_dan: ttUD100A.Add(eachRow); That row is part of this TableSet (from u in dsUD100.UD100A where u.Company == callContextClient.CurrentCompany && u.Key1 == key1 select u) It cannot be added to another T…

DataSet.Copy? DataSet.Copy Method (System.Data) | Microsoft Learn

That was my first thought but he did technically ask for Tableset… :smiley:

Update by query and then fill in the mappings?? Or am I missing what you are trying to do.

Excuse my ignorance… but is a dataset and a tableset the same thing? I know in Epicor I’m calling it a tableset but it’s called a ds in the method directive… so… yeah I don’t really know what the difference is if there is one.

They are different, but for most uses for us, they are the same.

[image] knash: Update by query and then fill in the mappings?? Or am I missing what you are trying to do. You know, I tried that but I overlooked that my tables were in there. I just saw the tt tables and the ERP tables and I just assumed that was all I had. But yeah I think this would work. …

If you have a dataset that needs to be returned from a bpm, and not a tableset you can use this.dsHolder.Attach(ds); to attach your dataset instead. What exactly are you working with?

[image] hmwillett: Convert Erp.Tablesets to System.Data.DataSet I used that yesterday :slight_smile: Thanks @Olga lol

I am working with UD100 and UD100A. When a record is updated in UD100A, I am checking all the child rows in UD100A and then updating a field in UD100 (a status). Only the rows I’m modifying show up in the ttUD100A in the ds in the method directive. So I am instantiating my own ds and doing a GetByID…

Copy one tableset to another

Epicor ERP 10

hmwillett (Hannah Willett) March 23, 2023, 5:55pm 12

Convert Erp.Tablesets to System.Data.DataSet - ERP 10 - Epicor User Help Forum (epiusers.help)

Topic		Replies	Views
Convert Erp.Tablesets to System.Data.DataSet Epicor ERP 10 e10 , function	12	7791	September 25, 2023
Custom Action to Copy Rows Between UD Tables Epicor ERP 10 bpm , baq , ubaq	15	4723	January 9, 2020
Copy UD table parent and child record set - sample code Kinetic ERP copyudrecord	0	675	May 5, 2022
Copy a UD Record in a BPM Epicor ERP 10 epicor , bpm , ud	4	2789	June 5, 2019
Any way to copy UD fields from quote to order without code? Epicor ERP 10	7	3582	September 9, 2017

Copy one tableset to another

Related topics