>>>>>>>>I have many systems developed in Clipper 5.2. It's using .NTX files.
>>>>>>>>I bought the Visual FoxPro 5.0 to update these systems. I would like to know how to use all .DBF tables with both languages.
>>>>>>>>Should I use .CDX of Foxpro 2.x Files? How can I do this?
>>>>>>>>
>>>>>>>>Thanks a lot.
>>>>>>>>
>>>>>>>>Paulo Hakme - ottobock@ottobock.com.br
>>>>>>>>http://www.ottobock.com.br/
>>>>>>>
>>>>>>>Paulo, you can use Clipper's DBF's as is, but you cannot use NTX files in VFP. You can use your INDEX ON code to rebuild indexes in VFP and even create one .CDX instead of many .NTX
>>>>>>>
>>>>>>>Nick
>>>>>>
>>>>>>How about keep the Clipper files and their indexes and use local views in your VFP development?? A local view against the Clipper tables, using ODCB to get the data should work..
>>>>>
>>>>>Bu since Clipper indexes cannot be used by VFP the speed of views may not be effective... so you need VFP indexes.
>>>>
>>>>You can do an index on the views.. Using the CDX's on the tables may cause problems for clipper, since you will be modifying the header info, correct??
>>>
>>>I mean indexes which are necessary for effective joins in the views.
>>>Personally I think it is not the right idea to make a kind of hybrid of Clipper and VFP, struggling for the same tables... I had experience in moving Clipper app to VFP, and (of course! :) it ended up in complete rewrite of the app in VFP...
>>
>>Understood, but sometimes you can NOT have your cake and eat it too... So, in these cases you need to have two systems accessing the data...
>
>What's the fun of having cake and not eating it? :)))
>
>>
>>hence, if you even have a 2.6 app and a VFP app accessing the same data it is the same thing..
>
>You are right, and I was lucky and convinced the client to threw Clipper away... :)

You will be hard pressed to get this always.. Most times you will have to support an app for a while and to use VFP, versus clipper you need some more hardware than clipper does..