FoxPro Advisor Magazine Articles July 1994

• Microsoft FoxPro for Windows, version 2.5x, 2.6, 2.6a
• Microsoft FoxPro for MS-DOS, versions 2.0, 2.5x, 2.6, 2.6a
• Microsoft FoxPro for Macintosh, version 2.5x, 2.6a

NOTE: The "FoxPro Advisor" is published by Data Based Solutions, Inc., a publisher independent of Microsoft; we make no warranty or endorsement, implied or otherwise, regarding the accuracy or reliability of information published in the "FoxPro Advisor." Please contact Data Based Solutions if you have questions or want to order the "FoxPro Advisor."

SUMMARY

Below is the table of contents of the July 1994 FoxPro Advisor, a magazine published by Data Based Solutions, Inc., 4010 Morena Blvd., Suite 200, San Diego, CA 92117. For more information, please call Data Based Solutions at 619-483-6400, or to place an order, please call them at 800-336-6060.

MORE INFORMATION

FoxPro News, page 6.

Editor's View, page 8. Microsoft Does the Hokey Pokey. By John L. Hawkins.

Functional FoxPro, page 10. FoxPro 2.6 Commands and Functions. By Malcolm C. Rubel. FoxPro 2.6 is being promoted as a more complete alternative to dBASE IV. Even for developers who can't spell dBASE, there are plenty of new goodies in FoxPro 2.6. SET COMPATIBLE DB4, SET COMPATIBLE ON, FOXPLUS, Null support, EMPTY(), ISBLANK(), FDATE(), FTIME(), FSIZE(), PARAMETERS().

Inside a .DBF: Why ISBLANK() Doesn't Work with All Data Types, page 14. By Malcolm C. Rubel. All data in a dbf is stored as character ASCII data.

FoxPro Fundamentals, page 16. Programming for Networks. By Miriam Liskin. When data is shared on a network, locking is essential. The techniques presented here get you started, and may be all you want. EXCLUSIVE, SHARED, CALCULATE, SUM, REPLACE, DELETE, SET LOCK, READ NOLOCK, RLOCK(), SET REPROCESS, RECALL, BROWSE WHEN, BROWSE VALID,

Screen Builder, page 22. Fonts, Pixels, and the FoxPro for Windows Screen Builder. By Robert Green. What is the proper SIZE of a GET when a proportional font is used? SCATTER MEMVAR, FONTMETRIC(), PICTURE.

Screen Builder, page 24. Tools for Sizing Proportional Font GET Fields. By Drew Speedie. FONTMETRIC(), GETFONT(), TEXTMERGE, TXTWIDTH(), numeric field and character fields with numbers, leading and trailing spaces, READBORDER, GET.

Screen Builder, page 30. Make Your popups and Lists More Descriptive. By Joe Homnick. Basing popups and scrollable lists on arrays give you tremendous flexibility. SCATTER MEMVAR, SHOW GETS, ASCAN().

Select SQL, page 32. Modify Table Structures on the Fly. By. Wayne A. Willingham. SQL is a query language. So how and why is it useful for modifying the structure of data tables? COPY STRUCTURE EXTENDED, APPEND, CREATE TABLE FROM ARRAY, AFIELDS(), SELECT, INSERT.

Developer Toolkit, page 36. Storing Multiple Values in a Single Field. By Robert Gryphon. In effect, a multi-value field is a one-dimensional array of values stored in a single field of a given record.. ADEL(), AINS(), ASCAN(), MEMLINES(), MLINE(), SCATTER, GATHER, SET MEMOWIDTH, SET RELATION.

FoxPro Tip, page 46 (table of contents says page 36 in error). When SET DEFAULT Doesn't. By Tamar E. Granor. When you change the FoxPro drive with SET DEFAULT, the DOS drive isn't changed.

Q&A, page 50. FoxPro Solutions. By Steve Freides and Tamar E. Granor. Screen sets, PgUp, PgDn, Invisible buttons, _CUROBJ, Network Printing, Novell capture, FPNET, GPLIB, NetLib, SET PRINT TO \\SPOOLER, UDFs, SET FILTER, conditional indexing.