Searching for table / linked element features

[Michel777]

Hi,

I want to know, in which table  the linked element features (attributes) are stored.
t_connector links elements,  but no attributes.

Thanks a lot in advance,

Michel

[Geert Bellekens]

See here: http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1423554898/5#5
or here: http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1373484277/0#0

Geert

[Michel777]

Geert,

thanks a lot for your effort, not only in that case !

The t_connector stores the linked Features too, in the column StyleEx. If I understood well the referenced posts  and other linked posts:

SyteEx contains the ea-guid-s of the linked features (in my case Attributes and Operations) as follows:

LFEP={38304C2F-59FC-48a7-A55D-D356FEEBC519}L;LFSP={6C9935E0-9566-4aa9-A9AF-DD3EAD42C2CE}R;

LFEP: belongs to the object, referenced in column End_Object_ID
LFSP: belongs to the object, referenced in column Start_Object_ID

But what is the meaning of the characters "L" and "R" in the right end of ea_guid-s ?

Thanks a lot in advance,

Michel

[qwerty]

LF<dir>P=<guid><pos>; connector is attached to attribute/operation
<dir> = S or E meaning Start (source) or End (target) <guid> = ea_guid of t_attribute or t_operation
<pos> = R if <dir> == S or L if <dir> == E
<pos> is obviously redundant...
There can be one LFSP, one LFEP or both be present in one StyleEx property

Copy/pasted from my Inside book (p.53)

q.

[Michel777]

Dear qwerty,

thanks a lot !

Warm regards,

Michel

[Michel777]

qwerty,

I found the following entry in my database:

LFEP={9C5029AF-7CE5-441d-9C25-245BA6E72164}R;

In that case:

<pos> = R and
<dir> = E

and so your conclusion

<pos> = R if <dir> == S or
<pos> = L if <dir> == E

is not true.

I suppose, that is the direction how you draw the relationship. Something like from right (R) to left (L), although if you draw a relationship vertically, there is either rightwards nor leftwards.

Perhaps R / L is s further synonym for  start / end  - source / target.

Michel

[qwerty]

I think the word "redundant" rules. I couldn't make up my mind as to what the suffix is used. Where I examined it, it was redundant. If you could provide a different example I'll have a look again.

q.

[Michel777]

Thanks for offering !

Obviously the dealing with the StyleEx has been changed in the meanwhile. Anyway, we are on the very deep and unsupported technical level. BTW: I'm wondering, that no one of Sparx closes such posts with pure speculations. If you want to investigate in that issue, them I'll create an example for you.

BTW: I found LFEP={BB2E7A9D-6492-435a-B357-7F5133F9C8A3}R;LFSP={7D94FA00-F542-4523-B887-2FF0FDC17823}R;

-> Both endpoints with "R" -> no right / left .... or similary.

Michel

[qwerty]

Yes, Sparx does not intervene. And that is much appreciated by their customers. From time to time they even offer bread crumbs - or easter eggs - here on the forum. Partially those unofficial database interfaces are already described in the help. E.g. the SQLQuery is an official part of the API and some tables are also listed; though my book is the only source to bring all those bread crumbs together so you have sort of a piece of cake.

If you send me an example I'll investigate further - and eventually update Inside. You'll find my mail following the link below and clicking the Contact.

q.

[KP]

LFSP = Linked Feature Start Point, i.e. the elementfeature at the source end of the connector.
LFEP = Linked Feature End Point, i.e. the elementfeature at the target end of the connector.

The final L and R refer to the vertical edge of the element that the connector attaches to, either Left or Right.

[qwerty]

Thanks, Neil (for the confirmation of my statement above ). But the L/R are different per diagram and attached dynamically when rendering. The L/R are saved when the link is created (I just verified that). But then later it is ignored. So it is not a redundant but a superfluous information. Right?

q.

[KP]

You're probably right. I tried moving a connector to the opposite side of the element and the L/R wasn't changed, but the connector displayed correctly after a restart and reload project.

[qwerty]

Thanks again for the confirmation  

q.