🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.dbexpress
Article #194

MySQL how get names and expresion of index

#194
From: juanma
Date: Wed, 09 Jul 2008 13:25
33 lines
1749 bytes
Hi,

I have a program where I can get all schema of a database (msql) through ADO 
component, now I'm triying to do that with dbexpres but I can't get de index 
names of a table (neither the precission of decimal field).

I tried with a TSQLDataSet like:

// ATb->IndexDefs->Update();
 for (int n = 0; n < ATb->IndexDefs->Count; n++) {   //lsI->Count
  XSTID * xi = new XSTID;
  xi->cN = ATb->IndexDefs->Items[n]->Name;
  xi->cF = ATb->IndexDefs->Items[n]->FieldExpression;
  xi->nP = ATb->IndexDefs->Items[n]->Options.ToInt();
  xDB.xT[i]->xI.AddItem(xi);
 }
 ATb->Close();
....

Also I tried with:

ATb->SetSchemaInfo(stIndexes,(WideString)xDB.xT[i]->cN, (WideString) NULL, 
(WideString)"");
ATb->Open();
....

I thought that all this stuff was dummy in dbexpress, because the code work 
without error but don't get any information...

do anybody know something about this? any clues?

TIA
Juanma
Technical Details
Message-ID: <4874bc46@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder.news-service.com!news.isoc.lu!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: fb4e2,fd6189fe6f7720f,start
X-Google-Attributes: gidfb4e2,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "juanma" <juanmmm@cajamar.es>
Newsgroups: borland.public.cppbuilder.database.dbexpress
Subject: MySQL how get names and expresion of index
Date: Wed, 9 Jul 2008 15:25:24 +0200
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: 195.57.121.132
Message-ID: <4874bc46@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1215609926 195.57.121.132 (9 Jul 2008 06:25:26 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder.news-service.com!news.isoc.lu!newsgroups.borland.com!not-for-mail