Correct connector endpoint coordinates using a SQL Query on the .eap-File (.mdb)

[Schludi]

Hi!

I have to draw some EA diagrams using only the .eap file without an installed EA on the server. So i am opening it as MDB-File via ODBC.
I have problems to find out where to place the connectors end point.

I have searched several topics in this forum. I know there is the attribute t_diagramlinks.Geometry (with edge={1,2,3,4})  and the Attribute [t_connector].Start_Edge and the attribute [t_connector].End_Edge , which are attributes that determine the edge to which the line is connected.

The table [t_diagramlinks] with the attribute "Geometry" is diagram-dependent.
The table [t_connector] with the attributes [t_connector].Start_Edge and the attribute [t_connector].End_Edge is not diagram-dependent --> there could be connections that haven't been drawn on a diagram.

I know that the SX, SY, EX, EY of t_diagramlinks are coordinates relative to the origin of each node that is drawn on a diagram - however i have problem to place the endpoints on the diagram like it has been drawn in the Enterprise Architect - the end of the connector often is somewhere in the middle of the end node.

Questions

• I am using in  t_diagramlinks.Geometry the csv-Value EDGE - but where do i find this for the end node?
• For which purpose are the attributes Start_Edge an End_Edge in the table "t_connector" when it is not diagram-dependend?

Current Situation:
"My Interpretation" is what my web app currently draws (this is a screenshot).

Target Situation:
"EA Interpretation" is what i would like to see in my web app --> I need the same picture like the EA.

Problem:
EX / EY sometimes is zero and isn't painting the end line to the edge. Here EDGE is 4 what means it starts on the left side.

Question:
How do i find out where to place the end point?

[Geert Bellekens]

I don't have an answer for your question, but your query seems way too complicated.
Any reason why you are doing so many joins with subqueries instead of simply joining the tables?

Geert

[Schludi]

Hi thanks for your reply. I guess i should delete this SQL Statement from the Question because it is not relevant for the answer :-).

The focus of my question is the displayed connector between the node "System Requirements" and "Applicable Standards". There is a bend/kink because t_diagramlinks.Path was filled - but that seems to work:



Here is the same picture with coordinates:

[qwerty]

Same here as on your SO question: What is your goal? To get the layout from "My Interpretation"? EA won't do that. It will always attach a connector to the rectangular frame of an element.

q.

[Schludi]

Current Situation:
"My Interpretation" is what my web app currently draws (this is a screenshot).

Target Situation:
"EA Interpretation" is what i would like to see in my web app --> I need the same picture like the EA.

Problem:
I can not use EX/EY because sometimes it is zero like shown in the screenshot with the coordinates. So i do not know exactly where the endpoint is.

[qwerty]

I tried to give an explanation of EA's rendering mechanism here on SO.

q.