Re: TADOTable.IndexDefs Problem


>I can't get a list of indices from TADOTable.
>Here's what I've tried:
>
> for i := 0 to dmMain.adotSource.IndexDefs.Count -1 do
> lbIndexFields.Items.Add(dmMain.adotSource.IndexDefs.Items[i].Fields);
>
>I'm getting 0 for Count even when I know that the table's got indices.
>Here's one wrinkle in the process. The TADOTable is pointing to an Access
>97 database. Are there any known problems there?

IndexDefs is not supported for TadoTable.
Use TadoConnection.Openschema method

ADOConnection1.OpenSchema(siIndexes
,VarArrayOf([Null,Null,null,null,'YourTable'),EmptyParam,ADODataSet1)
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages