Grabbing a subset of data out of a VFP 8 .dbf file

[RussDNC]

Looking for a tool that would allow us to create an automated schedule that looks at a VFP 8 dbf file and pull a subset of data. For example, each night I would like this tool to look at the file, and pull all our records that have a date stamp for the previous day and put it in a seperate dbf file.

Prior to us upgrading to VFP 8, we had Clipper do this for us. Looks like Clipper is not compatible with VFP 8.

 

[RussDNC]

I should have noted that we purchased off-the-shelf software that uses VFP 8 as its back end. We don't have any VFP programmers on site...which I'm sure restricts our solution options.

 

[JimWWinter]

It surely does. Best bet is to find a VFP programmer in your area and contract him to write the exe. The code should be pretty trivial.

Regards,
Jim

 

[DSummZZZ]

Or purchase VFP.
It's very possible you will have other little projects to do, and for the cost of contracting them out, it won't take long to recoup the cost. Since you have familiarity with Clipper, you'll find there are a lot of similarities in the .PRGS.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[Mike Lewis]

RussDNC,

Looks like Clipper is not compatible with VFP 8.

Actually, the code you need is identical. All of Clipper's basic data-handling commands, like APPEND BLANK, REPLACE, SKIP, etc., work just the same in VFP (although it's true that the data formats are not completely compatible).

If you know Clipper, you'll have no problem writing a little program in VFP to do what you want.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk