temp table use

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

Article #3087

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

#3087

From: bmkiss67
Date: Mon, 16 Dec 2002 20:11

11 lines
1801 bytes

We are converting our BCB code from using the bde (with MS SQL 6.5) to ADO
(with MS SQL 7.0).  With the bde I have code that makes a temp table, I
insert data, I turn on identity_insert, etc.  Now, it doesn't like the way i
have written N\A, it doesn't like see that I set identity_insert off (or
on), and when I comment some of that stuff out (date is all messed up) I get
a error that says it doesn't like my #temptable.  When I finally get to
something that I wasnt to test now, it tells me that it can't create
#temptable because it already exist.  Does ADO not do temp tables?  If it
does, how has it changed?  Any resources on ADO in BCB using MS SQL?

Thanks

Technical Details

Message-ID: <3dfe338b$1@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-08!supernews.com!129.250.169.16.MISMATCH!pln-e!extra.newsguy.com!lotsanews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer01.lnd.ops.eu.uu.net!emea.uu.net!news2.euro.net!newsfeed.freenet.de!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,c2facc8db6c0cf5,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-12-16 12:36:49 PST
Reply-To: "bmkiss67" <bmkiss67@cablespeed.com>
From: "bmkiss67" <bmkiss67@aaahawk.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: temp table use
Date: Mon, 16 Dec 2002 15:11:53 -0500
Lines: 13
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: 209.244.80.210
Message-ID: <3dfe338b$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1040069515 209.244.80.210 (16 Dec 2002 12:11:55 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!129.250.169.16.MISMATCH!pln-e!extra.newsguy.com!lotsanews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer01.lnd.ops.eu.uu.net!emea.uu.net!news2.euro.net!newsfeed.freenet.de!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail