Access 97 Table Name

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

Article #5313

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

#5313

From: Ligong Gan
Date: Wed, 20 Jun 2001 19:51

12 lines
1486 bytes

I use ADO to access an MS Access 97 database. The table I am accessing has a
name like this: "a:aaa:aa:aaaa" where "a" is a char. The problem is if I use
an SQL statement like "SELECT * FROM a:aaa:aa:aaa WHERE ...", the program
will interpret the table name a:aaa:aa:aaaa as a sequence of parameters
because of the ":" within the table name. So what I did was first, create a
query which copies the contents of a:aaa:aa:aaaa but whose name does not
contain the ":", and then do "SELECT * FROM QueryName WHERE ...".

My question is: Does anyone know of an alternative solution without creating
a dummy query? Many thanks,

Lee

Technical Details

Message-ID: <3b30fead$1_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!194.25.134.62!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,5a793e13b2e06fa2,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-06-20 13:13:40 PST
From: "Ligong Gan" <leegan@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Access 97 Table Name
Date: Wed, 20 Jun 2001 13:51:09 -0600
Lines: 16
Organization: City of Red Deer
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 207.34.102.197
Message-ID: <3b30fead$1_2@dnews>
X-Trace: dnews 993066669 207.34.102.197 (20 Jun 2001 12:51:09 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!194.25.134.62!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews