I am looking for a tool to run ad hoc selects, updates, and
deletes on files in dBase IV format, with Windows XP as the OS.
The preferred syntax is SQL-92; functions to parse character
data (or write my own) is a plus. Is FoxPro a good tool for
this, and if so, what version would you recommend?

Thanks,
Harry

Harry,
The VFP 8.0 data engine would be a good choice, however unless you want to do a lot of custom programming, you may want to check out some "canned" VFP solutions. Two that come to mind are Stonefield Query at www.stonefield.com and FoxFire! at http://www.micromegasystems.com/foxfire/foxfire.htm. For Non-VFP solutions you may want to consider Crystal Reports or R&R Report Writer at http://www.hallogram.com/. Note: CR like Stonefield Query and FoxFire! can also be integrated into a VFP application if you want a more customized front-end.

You could also use Access to attach to the tables using the new VFP OLE DB provider (http://www.microsoft.com/downloads/d...isplaylang=en), or the older (more limited) VFP ODBC client (http://msdn.microsoft.com/vfoxpro/do...c/default.aspx) and develelop the queries and reports in that environment.

Rick

"Harry Stangel" <hstangel (AT) pacbell (DOT) net> wrote