Messages

1

Automation Interface, Add-Ins and Tools / Re: Setting "Involved Columns" mapping on a foreign key connector from script

« on: May 12, 2023, 02:54:20 am »

It seems that I was able to solve the problem on my own after all.

The issue was the ordering of the parameter in the PK method on one side and the FK method on the other side. The order of the parameters has to match as it is used for the mapping.

2

Automation Interface, Add-Ins and Tools / Setting "Involved Columns" mapping on a foreign key connector from script

« on: May 12, 2023, 12:27:32 am »

Hi,

I am creating foreign key relations between two tables progamatically in Sparx EA (v15) using the scripting functionality.
Generally it seems to be working well, however, I cannot find a way to define the mapping between the columns of the connector ends.

I works well out of the box, if a PK consists only of single column.
If I have a PK with two columns and I reference it using a FK from other table, the mapping of the columns seems to behave rather inconsistent.

• sometimes it does not show up in diagramm at all
• sometimes the columns mapped automatically but incorrectly
• sometimes the columns are mapped automatically correctly

Is there a way how I can set the mapping explicitelly from the script either on the FK operation or the FK connector or somewhere else?
Basically I am searching for the funtcionality which, using the interface, can be done when you right click on connector and then select "Foreign Keys..." menu item.

Thanks!

Best regards,
Martin