How do you determine what indexes exist on VFP DBF in VB.Net

[JohnR]

Hi, I have a VB.Net application with Visual Foxpro DBF free tables. So
each table has a DBF and CDX file. I am using the vfpoledb.1 provider in an
Oledb environment to access the tables. I have a need to programmatically
determine what DBF fields are associated with the index in the table. I am
using the stmt:
Dim dtSchema As DataTable = MyDataReader.GetSchemaTable

to retrieve attributes of the DBF file such as fieldname, fieldtype, and
fieldsize. However, I can't find any reference to the indexes that are
associated with it.

Can anybody explain how I might query the CDX file to find out what indexes
are defined for the DBF file at runtime?

Thanks, John

[Cindy Winegarden]

Hi John,

I really don't think it's possible and I'd be pleased to find out that it
is, in fact, possible.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
ci**************@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"JohnR" <Jo******@hotmail.com> wrote in message
news:e8pPe.4205$IG2.1703@trndny01...

Hi, I have a VB.Net application with Visual Foxpro DBF free tables. So
each table has a DBF and CDX file. I am using the vfpoledb.1 provider in
an Oledb environment to access the tables. I have a need to
programmatically determine what DBF fields are associated with the index
in the table. I am using the stmt:
Dim dtSchema As DataTable = MyDataReader.GetSchemaTable

to retrieve attributes of the DBF file such as fieldname, fieldtype, and
fieldsize. However, I can't find any reference to the indexes that are
associated with it.

Can anybody explain how I might query the CDX file to find out what
indexes are defined for the DBF file at runtime?

Thanks, John

[JohnR]

Hi Cindy,

Thanks for the reply... Unfortunately your answer is what I suspected.
Right now I'm cheating and created a function that will pass me back an
array with the fieldnames that compose the primary key... I have to do it
manually based on tablename, however. Ugh! But it does work...

Regards,
John
"Cindy Winegarden" <ci**************@msn.com> wrote in message
news:%2***************@TK2MSFTNGP15.phx.gbl...

Hi John,

I really don't think it's possible and I'd be pleased to find out that it
is, in fact, possible.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
ci**************@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"JohnR" <Jo******@hotmail.com> wrote in message
news:e8pPe.4205$IG2.1703@trndny01...

Hi, I have a VB.Net application with Visual Foxpro DBF free tables. So
each table has a DBF and CDX file. I am using the vfpoledb.1 provider in
an Oledb environment to access the tables. I have a need to
programmatically determine what DBF fields are associated with the index
in the table. I am using the stmt:
Dim dtSchema As DataTable = MyDataReader.GetSchemaTable

to retrieve attributes of the DBF file such as fieldname, fieldtype, and
fieldsize. However, I can't find any reference to the indexes that are
associated with it.

Can anybody explain how I might query the CDX file to find out what
indexes are defined for the DBF file at runtime?

Thanks, John

[Cindy Winegarden]

Hi John,

I really don't think it's possible and I'd be pleased to find out that it
is, in fact, possible.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
ci**************@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"JohnR" <Jo******@hotmail.com> wrote in message
news:e8pPe.4205$IG2.1703@trndny01...

Hi, I have a VB.Net application with Visual Foxpro DBF free tables. So
each table has a DBF and CDX file. I am using the vfpoledb.1 provider in
an Oledb environment to access the tables. I have a need to
programmatically determine what DBF fields are associated with the index
in the table. I am using the stmt:
Dim dtSchema As DataTable = MyDataReader.GetSchemaTable

to retrieve attributes of the DBF file such as fieldname, fieldtype, and
fieldsize. However, I can't find any reference to the indexes that are
associated with it.

Can anybody explain how I might query the CDX file to find out what
indexes are defined for the DBF file at runtime?

Thanks, John

[JohnR]

Hi Cindy,

Thanks for the reply... Unfortunately your answer is what I suspected.
Right now I'm cheating and created a function that will pass me back an
array with the fieldnames that compose the primary key... I have to do it
manually based on tablename, however. Ugh! But it does work...

Regards,
John
"Cindy Winegarden" <ci**************@msn.com> wrote in message
news:%2***************@TK2MSFTNGP15.phx.gbl...

Hi John,

I really don't think it's possible and I'd be pleased to find out that it
is, in fact, possible.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
ci**************@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"JohnR" <Jo******@hotmail.com> wrote in message
news:e8pPe.4205$IG2.1703@trndny01...

Hi, I have a VB.Net application with Visual Foxpro DBF free tables. So
each table has a DBF and CDX file. I am using the vfpoledb.1 provider in
an Oledb environment to access the tables. I have a need to
programmatically determine what DBF fields are associated with the index
in the table. I am using the stmt:
Dim dtSchema As DataTable = MyDataReader.GetSchemaTable

to retrieve attributes of the DBF file such as fieldname, fieldtype, and
fieldsize. However, I can't find any reference to the indexes that are
associated with it.

Can anybody explain how I might query the CDX file to find out what
indexes are defined for the DBF file at runtime?

Thanks, John