Article View: borland.public.cppbuilder.database.ado
Article #3040Re: I have a problem using a temp table.
From: Ferran Barba
Date: Fri, 03 Jan 2003 08:06
Date: Fri, 03 Jan 2003 08:06
23 lines
2250 bytes
2250 bytes
What kind of temp table are you using (and in which database)? I'm asking this because if you create a temp table in SQL Server using # (like CREATE TABLE #tempTable ...) and you close the connection after creating it the table gets lost because it is a local temporary table. If you create a temp table using ## instead of # the table is accessible for all the user and gets deleted when all the users close the connection to the server. I only know about SQL Server. If you create a temp table without # or ## (that is, a normal table), maybe you have some king of access rights? "bmkiss67" <bmkiss67@aaahawk.com> escribi๏ฟฝ en el mensaje news:3e146d0b@newsgroups.borland.com... > I have a temp table that I create on the fly and modify a bunch of data in > and then I run a query against to fill a report out. When I did this > originally I did it using the BDE. I am in the process of switching to ADO. > The problem I am having is that I have a second query I run against the temp > table, but the query can't see the table. Any suggestions? > >
Technical Details
Message-ID:
<3e1543ae$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!easynews.net!newsfeed3.easynews.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3e146d0b@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: fc5f9,b84a0b06ba73e515 X-Google-Attributes: gidfc5f9,public X-Google-Thread: 10698b,b84a0b06ba73e515 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-01-03 00:09:22 PST From: "Ferran Barba" <ferran.barba@sifbm.com> Newsgroups: borland.public.cppbuilder.database.ado,borland.public.cppbuilder.database.sqlservers References: <3e146d0b@newsgroups.borland.com> Subject: Re: I have a problem using a temp table. Date: Fri, 3 Jan 2003 09:06:02 +0100 Lines: 25 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 80.38.150.57 Message-ID: <3e1543ae$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1041580974 80.38.150.57 (3 Jan 2003 00:02:54 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!easynews.net!newsfeed3.easynews.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail