🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: How to get Schema Information from access database?

#2973
From: Vladimir Afanasyev
Date: Fri, 21 Feb 2003 13:16
23 lines
1668 bytes
Hi Joachim,

"Joachim" <mfgjojo@gmx.de> wrote:
>Hello NG,
>can anybody please tell me how to get schema information from an access
>database. I tried ADOConnection->OpenSchema but that did�t work. I want to
>check if a column is indexed or not.
>

I create example and put it in the codecentral.
I use later binding (Variant's CreateObject method) for it.
Frankly saying it is correctly. Some days ago I read in MS SDK:

"It is a crucial, though seldom mentioned fact, that ADO is an
 IDispatch interface. "

Yes ADO was developed for later binding.

OpenSchema (ADO) for MS Access
http://codecentral.borland.com/codecentral/ccWeb.exe/listing?id=19587

Vladimir.
Technical Details
Message-ID: <3e5626c5$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <3e53aaa3@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,7e0fa85067e573fa
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-02-21 05:40:05 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: How to get Schema Information from access 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:  <3e53aaa3@newsgroups.borland.com>
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3e5626c5$1@newsgroups.borland.com>
Date: 21 Feb 2003 05:16:53 -0800
X-Trace: newsgroups.borland.com 1045833413 207.105.83.65 (21 Feb 2003 05:16:53 -0800)
Lines: 23
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail