Strange EOutOfResources exception on TADOQuery

Article View: borland.public.cppbuilder.database.ado

Article #2384

Back to borland.public.cppbuilder.database.ado Previous Next

#2384

From: Frank
Date: Sat, 05 Jul 2003 16:04

29 lines
1792 bytes

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

Technical Details

Message-ID: <3f06f705@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!skynet.be!skynet.be!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,a4ca6b88cf3ee918,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-07-05 09:09:18 PST
From: "Frank" <wesNO@SPAMlibero.itNO>
Sender: "Frank" <wesNO@SPAMlibero.itNO>
Reply-To: "Frank" <wesNO@SPAMlibero.itNO>
Subject: Strange EOutOfResources exception on TADOQuery
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 217.133.204.134 217.133.204.134    
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3f06f705@newsgroups.borland.com>
Date: 5 Jul 2003 09:04:21 -0700
X-Trace: newsgroups.borland.com 1057421061 207.105.83.65 (5 Jul 2003 09:04:21 -0700)
Lines: 29
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!skynet.be!skynet.be!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail