ERP Function convert input Dataset to Ice Table for BO Update

Kinetic ERP
1

Passing a View Dataset (dsCustMltPlr) as a parameter to ERP Function. In Function define UD01 Tableset variable as tblUD01. In Function try to fill the table with Custom Code statement tblUD01 = dsCustMltplr.Tables[0]; To Update Ice.Tableset.UD01 with tblUD01 using BO Update widgets. Get syntax error from tblUD01 = dsCustMltplr.Tables[0]; → Cannot Implicitly convert type. System.Data.Dataset to Ice.Tablesets.UD01Tableset.

Is there a conversion option ? Do I need to read dsCustMltplr line by line adding to tblUD01 using custom code ?

Tried search for solution specific to issue without luck. Any wisdom is appreciated. thanks.

As additional info. Had everything working, selecting rows to be updated, passing fields into ERP Function , doing a GetByID to fill UD01 table w BO widget. Found when alot of rows selected for update, some rows did not get updated. As if the function could not keep up w the calls being made to it. Assuming it is not synchronous. It this issue can be resolved , would solve the above issue as I tried using the whole view (all rows) as input.

2

If you share this code somebody can probably point out how to fix it.

Not that I know of. I would do it the way it sounds like you already tried.

1 Like
3

No Custom Code original solution. → Dataview condition is row checked → Row Add to UpdateView → iterate = ERP Function pass lookup and value fields → In Function -? BO widget GetByID → Set fields → Set Rowmod - Bo widget Update. Works great with a Return msg displayed to user between Updates. But can’t have user clicking OK 10-30 times between each row for alot of selected rows. Remove Return Msg and half of the records do NOT get updated. This to me confirms a timing / overload issue …

4

Oh yeah no dont do that. After you pass the dataset to your function, iterate theough it there and use it to populate the tableset. I thought that is what you were saying you had tried.