Re: Have I already created a table?

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

Article #1887

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

#1887

From: Palmetzhofer Dietmar
Date: Mon, 12 Jan 2004 09:40

26 lines
1860 bytes

Try using ADOConnection1->GetTableNames(TStrings* List, bool SystemTables =
false);
You�ll get a list of all the tablenames.
Greetings,
Didi

"Pat" <pat-rizioAGR@libero.it> schrieb im Newsbeitrag
news:4001713a@newsgroups.borland.com...
> 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: <40026b79@newsgroups.borland.com>

Path:

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

References: <4001713a@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,20f748cae954311b
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2004-01-12 02:08:13 PST
Reply-To: "Palmetzhofer Dietmar" <xxremovethisxx_dietmar.palmetzhofer@boku.ac.at>
From: "Palmetzhofer Dietmar" <xxremovethisxx_dietmar.palmetzhofer@boku.ac.at>
Newsgroups: borland.public.cppbuilder.database.ado
References: <4001713a@newsgroups.borland.com>
Subject: Re: Have I already created a table?
Date: Mon, 12 Jan 2004 10:40:23 +0100
Lines: 28
Organization: Univ. f. Bodenkultur
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 62.46.232.122
Message-ID: <40026b79@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1073900409 62.46.232.122 (12 Jan 2004 01:40:09 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!news-hog.berkeley.edu!ucberkeley!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message