Can you use a WITH statement in TADOQuery?

Hi there

I'm trying to pass this select statement to Oracle, using the TADOQuery
object:

with T1 as (select train_i from train where train_i < 20) select * from
T1;

It fails saying the result does not return a dataset set.

It I do this:

select * train_i from train where train_i < 20;

it works fine.

Any clues?

Dean

.

Relevant Pages