🚀 go-pugleaf

"Frank" <wesNO@SPAMlibero.itNO> wrote:
>
>Hi,
>I'm trying to execute the following query to an
>Access database (the SQL is correct, I tried directly
>inside Access):
>
>"SELECT S.cod, S.parent, S.tipo, S.cod_tab_tipo, (SELECT descr FROM
>    (
>              SELECT 1 AS tp, cod, descr FROM Tab1
>              UNION ALL
>             SELECT 2 AS tp, cod, descr FROM Tab2
>              UNION ALL
>             SELECT 3 AS tp, cod, descr FROM Tab3
>
>    )
>    WHERE tp = S.tipo AND cod = S.cod_tab_tipo 
>) AS descr
>FROM Tab_Struct AS S"
>
>
>When I open the query I get an EOutOfResources exception
>with message "Unable to insert an item".
>I never received this kind of message. I noticed that if
>I delete the third SELECT of the three "UNION ALL" satements
>it works. I have instead the necessity to add other SELECT 
>statements to that group..
>Any ideas?
>Thanks,
>Frank



Proble solved, had nothing to do with ADO, sorry for the useless post.
Frank