Have I already created a table?

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

Article #1884

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

#1884

From: Pat
Date: Sun, 11 Jan 2004 15:50

17 lines
1488 bytes

Hi everybody,
I'm using BCB6 and TADOComponents to quering a MS Access database.
First I create tables with the command:

"CREATE TABLE CatTable ([ID] AutoIncrement NOT NULL CONSTRAINT [PrimKey] 
PRIMARY KEY, [Nome] Text NULL)";

It should be better to know if a table named CatTable already exist 
before creating it.
How can I do this using TADOComponents?
If I'm not wrong SQL property of TADOQuery doesn't support the command 
"SHOW TABLES".
Thanks in advance.
Pat

-- 
remove AGR for reply

Technical Details

Message-ID: <4001713a@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newshosting.com!news-xfer1.atl.newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,20f748cae954311b,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2004-01-11 07:58:35 PST
Date: Sun, 11 Jan 2004 16:50:46 +0100
From: Pat <pat-rizioAGR@libero.it>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: it, en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Have I already created a table?
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 62.98.144.222
Message-ID: <4001713a@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1073836346 62.98.144.222 (11 Jan 2004 07:52:26 -0700)
Lines: 18
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newshosting.com!news-xfer1.atl.newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail