🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

ADOMD: How to retrieve "CudeDef" object from "CubeDefs" collection?

#4138
From: Sorokoletov Gregory
Date: Tue, 26 Mar 2002 10:52
44 lines
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!dnews

Show 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