Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Sorno on May 17, 2014, 12:30:52 am

Title: Limitation of EA's SQL search?
Post by: Sorno on May 17, 2014, 12:30:52 am

Hi,

I'm fiddling around with custom SQL for RTF-reporting  and have hit a brick wall.

When trying to use functions like Declare or IF the query returns no data when executed through EA (custom query and sql search). The model is hosted on a Microsoft SQL server och the query works fine if runned directly on the database.

Is this a hard limitation in  EA v10.0.1010?

Have a great weekend!

Title: Re: Limitation of EA's SQL search?
Post by: qwerty on May 17, 2014, 01:53:29 am

Depends on the RDBMS you use. If you use EAP then you're already in dead end. This Mikeysoft Access complies neither a SQL standard nor does it have any sophisticated functions.

q.

Title: Re: Limitation of EA's SQL search?
Post by: Geert Bellekens on May 19, 2014, 03:46:07 pm

Sorno,

I'm afraid it is.
Some of the more advanced features of SQL Server don't work when using them through EA.
First time I noticed this was when trying to do a recursive query.

Geert

Title: Re: Limitation of EA's SQL search?
Post by: Eve on May 19, 2014, 05:04:15 pm

Generally EA's processing of SQL queries is minimal. Most circumstances I have seen where it failed (but worked with a direct connection) were due to limitations of the drivers.

Title: Re: Limitation of EA's SQL search?
Post by: OpenIT Solutions on May 19, 2014, 09:39:27 pm

I found that if the statement didn't start with SELECT ... it would fail - so recursive queries in SQL Server for example...the solution we used was to create a VIEW on the SQL Server and issues simple SELCT against the VIEW from Sparx...