DAO.QueryDef [3131] Syntax error in FROM clause.

[Geert Bellekens]

I'm trying to write a somewhat complicated query, and I don't seem to be able to get EA to execute my query if it does a join with a subquery
I boiled it down to this type of statement:

Code: [Select]

select * from
t_attribute ta
inner join (select a.ID, a.Name from t_attribute a) dataq on dataq.ID = ta.IDwhen I execute this in EA I get

DAO.QueryDef [3131]
Syntax error in FROM clause.

The annoying thing is that this executed perfectly fine on the same model when I execute it using SQL Anywhere.

Geert

Does anyone know a workaround for this problem?

[Geert Bellekens]

I found it.

Seems to be related to Jet 4

My query tools aparently uses Jet 4, while I was using EA without the setting "Use Jet4".

By simply turning the setting on (without changing anything to my .eap file, so the file is still in Jet 3.5 format) it started working.

Next to that I also noticed a huge (8 seconds vs +10 minutes) performance different for one of my complicated queries with lots of joins and unions.

Geert