Creating a Diagram Reference via automation interf

[DanielKeys]

Hi everyone,

I was wondering if anyone knows of a way to create a Diagram Reference on a diagram via the automation interface (not via direct SQL update of the database).  

When I create a Diagram Reference in the UI by dragging an existing class diagram onto another class diagram I get the "Select Type" dialogue and select "Diagram Reference".  This creates an object of type UMLDiagram and adds the Diagram ID to the PDATA column in the object.  

There is nothing in the help on how to create these types and when I search the forum I only find people doing it directly via the database (which is cheating BTW).

Any suggestions?  

Thanks

Daniel

[Geert Bellekens]

Daniel,

If you found solutions using the database then that probably means there are no alternatives.
This is often the case when programming against the EA API. Cheating sort of becomes the standard :/

Geert

[DanielKeys]

Thanks for the reply Geert.   I thought that would be the case but was hoping a solution using the interface was hiding somewhere.

Cheers

Daniel

[pca]

I also need to create diagram references via automation.  

Could the MiscData property of the Element class provide a solution ?  the documentation says that MiscData(0) corresponds to PData1 and MiscData(1) corresponds to PData2.  Which one should be used to store the diagram ID ?

[pca]

I just tried updating MiscData(0), but it is a read-only property...  
Could you share the SQL statement that you use to create the reference ?

[philippeback]

UPDATE T_OBJECT SET PDATA1='<value>' WHERE ea_guid=<guidOfObject>

or

UPDATE T_OBJECT SET PDATA1='<value>' WHERE Object_ID=<objectId>

As of value, I'd create an object, check its guid, look at the values using Access and then set them accordingly.