Automate Foxpro 2.6 Free Table Links

[LaDeana1]

I am trying to link foxpro 2.6 free tables and their indexes through code. (.dbf file and it's associated .cdx file) I'm able to link them using dbase IV however, the indexes will not update when deleting or adding records.

I have tried to create an inf file which points to it's cdx index file but it errors out giving me 'index file not found'.

I have also tried vfpoledb to link them but I can't get around the prompt to select the unique record identifier. I need to establish this to edit the table.

Does anyone know if I can set the index fields through a connection string?

Thanks for your help!

 

[alvechurchdata]

the indexes will not update when deleting or adding records

I've just tried the same here with some old Fox files and found the same. Sorry I can't help but you might get more joy in the FoxPro(old versions) Forum182.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[LaDeana1]

Thanks for your suggestion. I posted it on their forum but they suggested to add pks to the table, which I'm unable to do.

Thanks