1
FOX 2000 - One Approach
by Michael Merino, Rocky Mountain Fox User Group

In trying to find all critical items for potential Year 2000 problems in FoxPro, I come up with one systematic approach that uses a Fox program calling Norton Utilities’ [version 8.0 DOS] TEXT SEARCH command. I’ll illustrate my approach with the Purchase program, a Fox2.5 DOS application consisting of approximately 170 programs, reports, forms! screens, etc. This approach should work both for Fox 2.5 DOS and Visual Fox. This approach also works for Fox executables, as well as non- Fox database applications, in our case files created by PRODAS, a statistical package used Denver Public Health.

There are several notes to make concerning the following program. One of the few things this approach will NOT find is dates that are built from three separate fields as in DD MM YY. In addition I specified the types of files to search for because of time factors, doing the following program on a 4GB network hard drive took 63 minutes on a Pentium 75.

1.
! run the program M200°.prg [see be!cw) which automatically
searches all databases for date fields, then takes these names and runs Norton’s text search to compile a list of every occurrence of these names. Note M2000.prg also includes a few functions for the text search: DATEO, CENT (from SET CENT OFF), DTOC, DTOS, CTOD, YY (for items like MM/DD/YY), MDV.
2.
I print out these four text files to begin my investigation
3.
Now I am ready to edit these programs so I start FOX and
immediately type

SET CENT ON

then go into the first prg file and start checking using Cntl F with the search term: DATEO. I also now know the form or screen set and report files that need to be adjusted for the increased date field lengths.
4.
when completed I may need to rebuild forms! screen sets in
various projects as well
When done, I’ve completely checked the Purchase program to make sure it is Year 2000 compliant!
(Con’t, page 3)
At LA Fox...
Out and About
by Barry R. Lee


June 15, 1998, 6:30 PM - Ken Levy. Ken is a software engineer consulting for Microsoft. Ken formerly worked at Flash Creative Management, Inc. specializing in the research, design, and creation of application development tools. While working as a consultant at NASA’s Jet Propulsion Laboratory in Pasadena, Ken developed several public domain programs including GENSCRNX, PTX Editor, and other FoxPro tools. Ken can be reached at www.classx.com. Furthermore, Ken is probably one of LA Fox’s more illustrious alumni. The working title of his session is “Things You Can Do With VFP 6.0” and he’ll be spending some time on VFP6/DHTML/XML. (“I think XML is more important than most people realize.”.. .Ken) And the evening is sure to be punctuated with “Oh...ohfl! Here’s something I just thought of...”.


July 13, 1998, 6:30 PM - Rick Strahl. Please note the change of date for this very special meeting. The last time Rick Strahl presented to LA Fox, he broke all existing records for meeting lengths. Rick will be doing a three-day stand in Southern California, stopping by LA Fox on July 13th, OC Fox on the 14th, and XPro on the 15th. His topic for LA Fox will be “Building Distributed Applications with VFP”, and ‘Web Connection” at OC Fox and XPro. You can prepare for this event by visiting his website at http://www.west-wind.com [Ed. Note: If you want to catch the other two nights ... Oranqe County FoxPro Developers Group normally meets at 7:00 PM on the 2nd Wednesday of each month in the Hard Disk Cafe at Ingram Micro, 1600 St. Andrews, Santa Ana. From anywhere, take a
In this issue
Spam Alert
VFP Weds Web to Data
RYITFSWLYPKCKOPR
Page 4
Page 6
Page 7
and much more
The LA Fox Developer
A Newsletter for FoxPro Application Developers in Southern California Visit our WebSite at: http://www.mesllc.com/lofox.html June 1998
The June meeting of LA Fox will be held on
June 19, 1998, at 6:30 PM at our regular meeting place (the Torrance Airport, 3301 Airport Drive, in Torrance). For details on how to get there, see the map on the back page.

1