Messages

1

Automation Interface, Add-Ins and Tools / Re: Automation I/F & SQL Script Results Passing

« on: July 13, 2012, 05:05:35 am »

Thanks, I'll give that a try.

2

Automation Interface, Add-Ins and Tools / Automation I/F & SQL Script Results Passing

« on: July 13, 2012, 04:22:36 am »

I created a SQL script in EA that generates a list of diagrams that display a given connector based on the connector's ID.

I need to pass the EA search results out of the EA model to my external VBA script.  The external VBA script invokes EA SQL script using the Repository.GetElementsByQuery() function but the function fails to return a collection of diagrams.  

Is there some other approach that can get me the information I need?

SQL script:
------------
SELECT t_diagram.ea_guid AS CLASSGUID,t_diagram.Diagram_Type AS CLASSTYPE, t_diagram.Diagram_ID, t_diagram.Name, t_diagram.ea_guid
FROM  t_diagram, t_diagramlinks
WHERE            t_diagramlinks.ConnectorID=<Search Term>
              AND  t_diagramlinks.Hidden=FALSE
              AND  t_diagram.Diagram_ID = t_diagramlinks.DiagramID