🚀 go-pugleaf

At the moment I get all the information in a recordset with 'show index from 
<tablename>',
 also de precission of decimal with 'show columns from <tablename>'

For now I think this is the way...

"juanma" <juanmmm@cajamar.es> escribi� en el mensaje 
news:4874bc46@newsgroups.borland.com...
> 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
>
>