Forum Discussion

mgreenberg's avatar
mgreenberg
Contributor II
3 years ago

What does ' DataTable already belongs to another DataSet.' error mean an how to fix?

I have a data adapter that calls a BR that calls one of the IC methods (I thinned it down here) but what I run the data adapter I get the error that the datatable already belongs to another dataset. ...
Dashboards
  • MarcusH's avatar
    MarcusH
    2 years ago

    I have just had the same error and I eventually fixed it. I am putting the solution here in case anyone else has the same error.

    You need to take a copy of the table. So instead of this:

    dtInterCoBud = BRApi.Database.ExecuteMethodCommand(dbConnApp, XFCommandMethodTypeId.ICMatchingForWorkflowUnitMultiPlug, interCoMethodQuery, "ICBud", Nothing).Tables(0)

    add .Copy() to the end so it is like this:

    dtInterCoBud = BRApi.Database.ExecuteMethodCommand(dbConnApp, XFCommandMethodTypeId.ICMatchingForWorkflowUnitMultiPlug, interCoMethodQuery, "ICBud", Nothing).Tables(0).Copy()

mgreenberg's avatar
mgreenberg
Contributor II

So I stole some code from another BR we had that was putting the method call into a temp table and then copying it to the table that got returned and now I am not getting the error anymore. So Strange - not sure why it needs to be that way

 

Dim tempTable As DataTable = BRApi.Database.ExecuteMethodCommand(dbConnApp, XFCommandMethodTypeId.ICMatchingForWorkflowUnitMultiPlug, interCoMethodQuery, "ICBud", Nothing).Tables(0)
If (dtInterCoBud2 Is Nothing) Then
dtInterCoBud2 = tempTable.Copy
Else
dtInterCoBud2.Merge(tempTable)
End If

DanielWillis's avatar
DanielWillis
Valued Contributor
3 years ago

Could you try changing your original code from

Dim dtInterCoBud As New DataTable

to

Dim dtInterCoBud As DataTable

  • mgreenberg's avatar
    mgreenberg
    Contributor II
    3 years ago

    Hi Daniel - same error ğŸ˜‚

    • NicolasArgente's avatar
      NicolasArgente
      Valued Contributor
      3 years ago

      Could the error come from the method query you use in the BR? Are you using dt or ds there?

      • mgreenberg's avatar
        mgreenberg
        Contributor II
        3 years ago

        Hi Nicolas - I dont know what you mean by dt or ds.   Can you please elaborate?