🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: how to use OpenSchema Method.

#4130
From: Vassiliev V.V.
Date: Thu, 21 Mar 2002 16:57
50 lines
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!dnews
References: <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