Foxpro 2.0 to Visual Foxpro 7.0 USE problem

[fmoore0001]

Guys, I have a problem with a VFP 7.0 program I wrote to fix some damaged Foxpro files (at least damaged by our situations. It works fine except on one very large program written in Foxpro 2.0.

The problem appears to be that I cannot open a Foxpro 2.0 program with a MEMO file extension of .DBT. If a file I attempt to open has .FPT or I convert the file PHYSICALLY to .FPT, no problem. However, we still have to use this Foxpro 2.0 program for a while. Any ideas on how to open, USE and close a Foxpro 2.0 file with the .DBT memo extension with VFP 7.0.

 

[BPeisch]

Why do you need to keep the DBT extension for the memo field? Even in FP 2.X, the normal extension was FPT. DBT was used for dBASE files. Unless you need to read the file in something other than FoxPro, I'd convert it to FPT. BTW, you should be aware that if you modify a file in VFP, it can't be read by 2.x, unless you use COPY TO...TYPE FOX2X to create the file.



-BP

http://www.peisch.com

 

[fmoore0001]

Alas, have more than 100 installs of the program out there still working, and they usined DBT files for the 2.0 version. Got to deal with it.

Frank

 

[BPeisch]

SET COMPATIBLE DB4 will probably fix this situation, but be aware that it can affect other commands in ways you aren't expecting. (DIMENSION to redimension an existing array is one that comes to mind.) You should read the online help for the SET COMPATIBLE command.

What you may want to do is create a conversion program that can be run at all the sites to convert the data to FP format, so you don't have to use SET COMPATIBLE to open the data, and risk breaking something else.



-BP

http://www.peisch.com

 

[ramani]

Hi Barbara,

I was thinking about this command. But dont think, .dbt extension will be accepted.

SET COMPATIBLE FOXPLUS is better, since Frank is deriving it from FoxPlus days.

But I doubt the DBT extension will be accepted and continued. Frank wants to continue using the table in both.
(Cliper tables also have .DBT)



____________________________________________
Ramani - (Subramanian.G)

http://winnersoft.coolfreepages.com/

When you ask VFP questions, please add VFP version.

 

[skoko]

So, how you open .DBT in VFP?

 

[Dan Freeman]

You don't. VFP will convert to FPT and use that.

This goes back to AT LEAST Foxpro 2.x, and possibly Foxpro 1.x.