Archiv der Kategorie: SQL

Problem The Images of a specific diagram in the data structure of the Sparx Systems Enterprise Architect should be read by diagram name. Approach Usage of MDB Plus and Data Mining Solution This is SQL for the Access / .eap-File … Weiterlesen →

Problem The order of tree elements in the project browser should be queried in SQL. Die Reihenfolge der Objekte im Projekt-Browser soll über SQL abgefragt werden Approach – Ansatz Usage of the TPos column within the tables t_object and t_package. … Weiterlesen →

Problem A SQL statement is needed, that returns a list of all link relations with start and end object name. Additionally a tagged value (here it is called ‚Object identifier‘) should be appended Approach Usage of MDB Plus Solution Note: … Weiterlesen →

Problem A SQL Statement is needed to get the coordinates of Diagram Object like Activities, Classes, Lanes and so on… In this statement only the stereotypes ‚Project Phase‘, ‚Gate‘, ‚Product Maturity‘, ‚Lane‘ of the diagram ‚Product Creation Process‘ will be … Weiterlesen →

Problem A SQL-Statement is needed (here Access / .eap) that gets all Coordinate-, Routing- and Position information of links in a diagram of the Sparx Systems Enterprise Architect. Approach Data Mining and the Usage of MDB Plus Solution The link … Weiterlesen →