SQL Query in Excel does not work

22 October 2013 at 5:13 pm #7101

Participant

It seems like the SQL query does work in Excel if you do the following:

1) Put t_object.ea_guid AS CLASSGUID, as the first statement in the SQL SELECT
1.1) The ‘AS’ must be capital letters. A lower case ‘as’ will not work.
2) Only use the ea_guid out of the t_object table. It does not seem to work on other tables.

Compare licence prices

Choose the licence that’s right for you and your team

Prices

Download a free trial

Download eaTeamWorks today for free for life features, plus no obligation, 30-day trials of all the products: eaDocX, Revision Manager, eaSheets, Model Expert and PortfolioManager. Discover for yourself why eaTeamWorks is the world’s best-selling Enterprise Architect extension.

Download