Article View: borland.public.cppbuilder.database.ado
Article #4130Re: how to use OpenSchema Method.
From: Vassiliev V.V.
Date: Thu, 21 Mar 2002 16:57
Date: Thu, 21 Mar 2002 16:57
50 lines
2510 bytes
2510 bytes
ADOConnection1->OpenSchema(siViews, EmptyParam, EmptyParam, ADODataSet1);
First parameter is schema - in this example Views.
Second - Restrictions - for example, if you get columns schema (siColumns)
you could get columns for all tables, or specify restiction and get columns
for concrete table - every schema defines its restrictions. Use EmptyParam
for no restrictions. Otherwise Restrictions is Variant that contains array
of Variants with restrictions.
Third - GUID of schema - if your provider have a schema that is not in
enumeration, enter its GUID here. Use EmptyParam is usual.
Fourth - TADODataSet in which schema is returned.
Regards,
Vassiliev V.V.
http://www.oledbdirect.com
"Mortalpain" <mortalpain@mortalpain.net> �������/�������� � ��������
���������: news:3c987417$1_1@dnews...
> hi~ all.
>
> i'm trying to use openschema method.
>
> but it's very difficult.... specially second and third parameters
>
> for example
>
> void __fastcall OpenSchema(const TSchemaInfo Schema, const OleVariant
> &Restrictions, const OleVariant &SchemaID, TADODataSet * DataSet);
>
> what is const OleVariant &Restrictions ?
>
> and what is const OleVariant &SchemaID ?
>
> help is lack of explainations....
>
> there are in My source
>
> OleVariant Restrictions = WideString("TABLE_NAME");
>
> objConn->OpenSchema(siTables, Restrictions, NULL, objRsSchema);
> objRsSchema->Open();
>
> help me please....
>
> Good Programming and all happy~ :-)
>
>
Technical Details
Message-ID:
<3c9a1144_2@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!peer1-sjc1.usenetserver.com!usenetserver.com!hub1.nntpserver.com!xmission!logbridge.uoregon.edu!cyclone.bc.net!newsfeed.media.kyoto-u.ac.jp!newsfeed01.sul.t-online.de!t-online.de!dnewsReferences:
<3c987417$1_1@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,cdca7ec5f3bcafce X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-03-21 09:11:22 PST From: "Vassiliev V.V." <vv_vas@iname.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3c987417$1_1@dnews> Subject: Re: how to use OpenSchema Method. Date: Thu, 21 Mar 2002 19:57:48 +0300 Lines: 52 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 62.118.130.95 Message-ID: <3c9a1144_2@dnews> X-Trace: dnews 1016729924 62.118.130.95 (21 Mar 2002 08:58:44 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!peer1-sjc1.usenetserver.com!usenetserver.com!hub1.nntpserver.com!xmission!logbridge.uoregon.edu!cyclone.bc.net!newsfeed.media.kyoto-u.ac.jp!newsfeed01.sul.t-online.de!t-online.de!dnews