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

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" <cindy_winegarden@xxxxxxx> wrote in message
news:%23m977e$qFHA.464@xxxxxxxxxxxxxxxxxxxxxxx
> 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
> cindy_winegarden@xxxxxxx www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
>
>
> "JohnR" <JohnR104@xxxxxxxxxxx> wrote in message
> news:e8pPe.4205$IG2.1703@xxxxxxxxxxx
>> 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
>>
>>
>>
>>
>
>


.

Relevant Pages

  • Re: Cannot set CDX index on DBF file from C#
    ... CDX file, OLEDB also opens all indexs and will use them as required, ... In the DBF world I am used to opening a DBF and ... able to use these to build appropriate WHERE clauses in SQL. ... or not the SELECT process speeds up? ...
    (microsoft.public.fox.helpwanted)
  • Re: problems using *.dbf and *.cdx (FoxPro / C#)
    ... I had a similar issue a while ago, I had to write to an old foxpro dbf ... > but the cdx file isn't updated. ... > the file must be updated cause a xbase++ app is reading the dbf and cdx ...
    (microsoft.public.fox.helpwanted)
  • Re: How do you determine what indexes exist on VFP DBF in VB.Net
    ... Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP ... I have a VB.Net application with Visual Foxpro DBF free tables. ... > each table has a DBF and CDX file. ...
    (microsoft.public.dotnet.languages.vb)
  • How do you determine what indexes exist on VFP DBF in VB.Net
    ... I have a VB.Net application with Visual Foxpro DBF free tables. ... I am using the vfpoledb.1 provider in an ... Can anybody explain how I might query the CDX file to find out what indexes ...
    (microsoft.public.dotnet.languages.vb)
  • Re: odbc driver for Microsoft Visual Foxpro have some lock?
    ... The dbf files just are used by my program and just are readed data from ... You said I can use Visual Foxpro OLEDB data provider, ... The version do not provider the OLEDB data provider. ... Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP ...
    (microsoft.public.data.odbc)