Re: Getting a list of tables from a database

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

Article #2963

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

#2963

From: Vladimir Afanasyev
Date: Mon, 17 Feb 2003 09:40

29 lines
1924 bytes

Hi,

"Mike Knoblock" <mjk111@adelphia.net> wrote:
>Yes; I saw your earlier post and tried this and it works fine for ADO
>connections. I need a method that includes ODBC-based TDataBase connections,
>and I think that is a dead end.  Thanks for the reply.
>
>Mike
>
>
>"In�s Fern�ndez" <ifernandezmed@terra.es> wrote in message
>news:3e4a7dfb@newsgroups.borland.com...
>> Try this:
>>
>> TStrings *tableList = new TStringList;
>> ADOConnection1->GetTableNames(tableList,false);
>>
>> Ines
>>

GetTableNames based on OpenSchema method of ADO 
Connection object. But not all providers support 
this feature. So access to this information very 
depend from provider. For example, for some 
providers this info can be in one of system tables 
of database.

Vladimir.

Technical Details

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

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!cyclone.bc.net!logbridge.uoregon.edu!xmission!nntp.infostrada.it!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3e4a6e98$1@newsgroups.borland.com> <3e4a7dfb@newsgroups.borland.com> <3e4a8d04@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,90198c6b8705eec9
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-02-17 02:12:06 PST
From: "Vladimir Afanasyev" <avv@systema.kiev.ua>
Sender: "Vladimir Afanasyev" <avv@systema.kiev.ua>
Reply-To: "Vladimir Afanasyev" <avv@systema.kiev.ua>
Subject: Re: Getting a list of tables from a database
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 62.244.14.114 62.244.14.114    
X-Forwarded-For: 192.168.0.147
References: <3e4a6e98$1@newsgroups.borland.com> <3e4a7dfb@newsgroups.borland.com> <3e4a8d04@newsgroups.borland.com>
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3e50adf4$1@newsgroups.borland.com>
Date: 17 Feb 2003 01:40:04 -0800
X-Trace: newsgroups.borland.com 1045474804 207.105.83.65 (17 Feb 2003 01:40:04 -0800)
Lines: 29
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!cyclone.bc.net!logbridge.uoregon.edu!xmission!nntp.infostrada.it!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message