Book a Demo

Author Topic: Include user- defined SQL-Queries (Adv. Search)  (Read 2112 times)

ch@SVDO

  • EA Novice
  • *
  • Posts: 15
  • Karma: +0/-0
    • View Profile
Include user- defined SQL-Queries (Adv. Search)
« on: July 01, 2007, 11:44:44 pm »
Hi,
I have to create a new Report in search view that needs to include data from several tables of the database. I tried to manage this by a Custom SQL query (Advanced Search), but this query would be far to extensive and complicated for me to create in one piece.
Therefore I created several smaller queries (e.g. "Query1", "Query2",..) and tried to bring them together in another SQL query("SELECT ... FROM Query1, Query2,....WHERE...")  . The problem is that I can't call the other (small) queries that way because Enterprise Architect simply can't find those queries.
I searched the database (renamed the project file in a ".mdb" file and examined the tables and queries) but couldn't find any of my user-defined queries (e.g, "Query1", "Query2",...) in there.

Does anyone have a clue where Enterprise Architect saves those user-defined SQL Queries and how I can include them in other SQL queries?

Thanks in advance.
Charly