Book a Demo

Author Topic: Updating connection when target and source same  (Read 3603 times)

Robert Sheridan

  • EA User
  • **
  • Posts: 105
  • Karma: +0/-0
    • View Profile
Updating connection when target and source same
« on: January 29, 2015, 09:59:16 pm »
Hi,
I am transferring data from a non EA repository into EA.  The data includes connectors.  I can create connectors Ok but if the target and source are the same the subsequent update of the connector with additional values fails.  Has anyone else come across this? code below.

                   With theRelConn
                        .alias = theConnID 'From the source repository
                        .Notes = ActiveCell.Offset(0, 2).Value
                        .ClientEnd.Role = ActiveCell.Offset(0, 7).Value
                        .ClientEnd.Cardinality = Chr(ActiveCell.Offset(0, 9).Value)
                        .ClientEnd.Update
                        .SupplierEnd.Role = ActiveCell.Offset(0, 8).Value
                        .SupplierEnd.Cardinality = ActiveCell.Offset(0, 10).Value
                        .SupplierEnd.Update
                        .Update
                    End With
« Last Edit: January 29, 2015, 10:00:15 pm by RobertS »