sql editor advanced find support finding messages

[john]

I want to use the find\advanced\new query  sql-editor to check the model for inconsistancies. To do so:

Create a sequence diagram with two instances of classes. Add two messages by creating an opereration called XXX. Change the name of the message (in the message diaglog not the operations dialogue to YYY.
You have a sequence diagram with a message XXX (refering to operation XXX) and a message YYY (not refering to an operation).

Perform the sql-editor find query:
select * form t_operation you only get the operation XXX.
Perform select * from t_object you also do not find the YYY message.

Is the t_message table missing?

[thomaskilian]

There is no t_message table. Yiou can investigate by renaming an EAP to MDB and importing data to either Access or Excel. I'm not sure where the messages are stored. Probably in t_diagramobjects?

[Bruno.Cossi]

I do not have EA in front of me, but I think the table is t_connector. You don't even have to rename the .EAP file to .MDB, you can open it is Access directly.

Bruno

There is no t_message table. Yiou can investigate by renaming an EAP to MDB and importing data to either Access or Excel. I'm not sure where the messages are stored. Probably in t_diagramobjects?

[john]

thank you both.

It indeed is in t_connection. However although there is a end_object_id in that tabel refering to the object the message is send to (and from that you can find the class). There is no way to find the relation to the operation in that class.

(if you create an operation AAA and a message refering to that operation AAA and another message not refering to the AAA operation but to BBB. When you rename the BBB message to also AAA the two messages seem to be the same. But if you now rename the operation AAA to XXX then one message is automatically renamed and one not. So somewere there is some link between the message and the operation, but where??