Article View: borland.public.cppbuilder.database.ado
Article #4138ADOMD: How to retrieve "CudeDef" object from "CubeDefs" collection?
From: Sorokoletov Gregory
Date: Tue, 26 Mar 2002 10:52
Date: Tue, 26 Mar 2002 10:52
44 lines
2471 bytes
2471 bytes
How can I retrieve "CudeDef" object from "CubeDefs" collection?
I Delphi it is possible in the following way:
var
Catalog1: ICatalog;
CudeDef1: CubeDef;
I: Integer;
Catalog1 := CoCatalog.Create;
Catalog1._Set_ActiveConnection(OleVariant(DataSource)); // DataSource -
connection string
for I:= 0 to Catalog1.CubeDefs.Count- 1 do
begin
CudeDef1= Catalog1.CubeDefs[I] as CubeDef;
// here we use the CubeDef object;
TreeView1.Items.AddChild(RootNode, CubeDef1.Name);
end;
But when in C++ Builder I wrote:
WideString DataSource= "Provider=MSOLAP.2;
Integrated Security=SSPI;
Persist Security Info=False;
Data Source=ARISXXXXX;
Initial Catalog=FoodMart 2000;
Client Cache Size=25";
Catalog1->set_ActiveConnection(DataSource);
TCOMCubeDefs CubeDefs1= Catalog1->CubeDefs;
TCOMCubeDef25 CubeDef1;
//CubeDefs *CubeDefs1= Catalog1->CubeDefs;
//CubeDef *CubeDef1;
for(I= 0; I < CubeDefs1->Count; I++)
{
CubeDef1= Catalog1->CubeDefs->get_Item(I); // here will be error!
// CubeDef1= Catalog1->CubeDefs[I];
TreeView1->Items->AddChild(RootNode, CubeDef1->Name);
}
I get error: access violation :((((((((((((((((((!!!
Please explain my where is my error!
Technical Details
Message-ID:
<3ca052df$1_2@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!newsfeed.online.be!diablo.netcom.net.uk!netcom.net.uk!newsfeed.icl.net!newsfeed.media.kyoto-u.ac.jp!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,c870f68434c1f204,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-03-26 03:07:39 PST From: "Sorokoletov Gregory" <gsorokoletov@sovintel.net> Newsgroups: borland.public.cppbuilder.database.ado Subject: ADOMD: How to retrieve "CudeDef" object from "CubeDefs" collection? Date: Tue, 26 Mar 2002 13:52:15 +0300 Lines: 46 Organization: Sovintel X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 NNTP-Posting-Host: 212.44.130.15 Message-ID: <3ca052df$1_2@dnews> X-Trace: dnews 1017139935 212.44.130.15 (26 Mar 2002 02:52:15 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!newsfeed.online.be!diablo.netcom.net.uk!netcom.net.uk!newsfeed.icl.net!newsfeed.media.kyoto-u.ac.jp!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews