NTX Indexes in VFP 8

[rkdua66]

Hi,

I am using Clipper 5.2 DBF files with indexes (NTX). Now i want to use these dbfs in VFP 8 without converting into VFP 8.

I want to use NTX index files in VFP 8.

Anyone having idea about this pls help me.

Thanks
Ravinder Dua
rdua@rcmcdelhi.com

 

[Mike Lewis]

You can't use NTXs natively in VFP. You would have to re-index the tables, to create IDX or (preferably) CDX indexes.

If you want to be able to share the data between Clipper and VFP, one option would be to use a product such as Codebase, which supports both Clipper and Foxpro table and index files. But that would mean rewriting some or all of your table access code.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Mike Lewis]

Another possibility might be to use ODBC to access the Clipper data from within VFP.

Basically, you would set up a set of remote views to access the Clipper tables. Your VFP program would then use those views just as if they were normal tables. You would keep the Clipper indexes; your VFP program would not need to be aware of them. There would be no need to change your Clipper code in any way.

I have never done this with Clipper, but I can't see why it shouldn't work (assuming you can find an ODBC driver for Clipper, which you most probably can).

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads