Fetch Data From DOS (Fpd26)

[alisaif]

Hi All,

I want to fetch data from foxpro for dos to VFP9 which is currently running on Lan.
Is it a wise idea to get it directly from running application or there is another alternate.

Thanks

Saif

 

[Mike Lewis]

If the data is in ordinary Foxpro for Dos files, that is, DBF files, you will have no problem. Just treat the files in exactly the same way as you would treat an ordinary VFP table. If necessary, you can also update the Dos files from your VFP application.

The only problem I can think of is if the Dos application has opened the DBFs for exclusive use. In that case, you will have to make sure that all the users have come out of the application before you can access the files.

But apart from that, you should have no difficulties at all.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[alisaif]

Thanks a lot !!

Saif

 

[Olaf Doschke]

One more difficulty is the encoding of data. But indeed also VFP can read MSDOS codepage 437 or 850 or other code pages. You have STRCONV to convert single strings. If you convert the DBFs, they won't be usable by the DOS application anymore, so you have to go through that bottleneck of converting all text data back and forth to be readable in a Windows environment in Ansi codepages like 1252.

Bye, Olaf.

 

[JackTheC]

I remember I had a Dos Foxbase+ application more than 10 years ago which was still in use in a large multiuser environment. Gradually I upgraded parts into VFP3.0 or VFP6.0 while the original was stil in use. No problems whatsoever. When I left the company, both parts (DOS and VFP) where still in use peacefully together.

 

[NasibKalsi]

you can issue

set cpdialog off

before opening the fpd26 dbf files.

* credits - this forum

nasib