SQL editor with SUBSELECT

[viarellano]

Hi,

is there any possibility to do a query definition with a subselect?.
When i tried it, EA gives me next error msg:

SELECT * FROM (SELECT *  FROM t_object);

DAO.QueryDef [3131]
Syntax Error in from Clause.

Thanks!

Vi

[Wyatt]

That syntax is not valid in the standard Jet engine.  If you choose the option to use Jet 4.0 (tools | options -- restart required), it will work as expected.

[viarellano]

thanks
it is posible to set this value to the SqlServer deployed version of EA ?

regards