Limitation of EA's SQL search?

[Sorno]

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!

[qwerty]

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.

[Geert Bellekens]

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

[Eve]

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.

[OpenIT Solutions]

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...