Problem with Access Databases

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

Article #3361

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

#3361

From: Lee Gan
Date: Wed, 09 Oct 2002 22:14

19 lines
1835 bytes

I posted this message sometime ago on this forum and did not get a workable
answer. Now I am trying again.

I have an Access 97 database which has a table named something like
abc:def:gh. Then I try to query against the table using a TADOQuery. The SQL
statement looks like

SELECT * FROM abc:def:gh WHERE conditions

No problem with compilation and linking. However, whenever this SQL is
executed, an error message pops up asking me to specify parameters abc, def
and gh. This is simply because the compiler treats the table name as three
parameters. I have tried to put "abc:def:gh", 'abc:def:gh', [abc:def:gh],
{abc:def:gh} and many other things for the table name, no success. This
problem goes away when I manually change the table name to abcdefgh.

Can anybody help me? Many thanks in advance. BTW, I use BCB 6 Pro.

Lee Gan

Technical Details

Message-ID: <3da4aa48$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!fr.usenet-edu.net!usenet-edu.net!fr.clara.net!heighliner.fr.clara.net!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,ccea621b0887f8c,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-10-09 15:42:02 PST
From: "Lee Gan" <leegan@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Problem with Access Databases
Date: Wed, 9 Oct 2002 16:14:32 -0600
Lines: 21
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: <3da4aa48$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1034201672 207.34.102.197 (9 Oct 2002 15:14:32 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!fr.usenet-edu.net!usenet-edu.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail