Article View: borland.public.cppbuilder.database.dbexpress
Article #194MySQL how get names and expresion of index
From: juanma
Date: Wed, 09 Jul 2008 13:25
Date: Wed, 09 Jul 2008 13:25
33 lines
1749 bytes
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-mailShow 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