Tim,

Have you considered to add support for derived tables in EDB ?

A derived table is similar to a view, only inlined in the table expression.

Example:

select x
from
(
 select col1 x
 from mytable
) dt

Several of the infamous "Sudoko" views were exposed as derived tables in the
original script. A very handy and powerful feature.

Ole Willy Tuv

Ole,

<< Have you considered to add support for derived tables in EDB ? >>

Sure, there's always been support in EDB for parsing derived tables
(edbexpr.pas), it's just not turned on yet since the execution needs a
couple of required items still.

It will be in there shortly.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<< It will be in there shortly. >>

Great news!

Ole Willy Tuv