microsoft.public.dotnet.framework.interop

WillieD

10/18/2007 11:55:00 PM

"Requena Claudio" wrote:

> Hi,
>
> Iâ??m trying to add an Index PrimaryKey in one table with no success.
> in the code below the Fields.Append don't exist and give me error.
>
> DAO.TableDef OBJTable = DAO_DATABASE.TableDefs["Table"];
> DAO.Index OBJIndex = OBJTable.CreateIndex("PrimaryKey");
> OBJIndex.Fields.Append(OBJIndex.CreateField("fMonthCD"));
>
> Any help will be appreciated, Thanks.
>
>

I had the same problem. Try casting it to DAO.IndexFields:

DAO.Field idxFld = OBJIndex.CreateField("fMonthCD");
((DAO.IndexFields) OBJIndex.Fields).Append(idxFld);