FoxPro Advisor Magazine Articles June 1994

• Microsoft FoxPro for Windows, versions 2.5x, 2.6, 2.6a
• Microsoft FoxPro for MS-DOS, versions 2.0, 2.5x, 2.6, 2.6a
• Microsoft FoxPro for Macintosh, versions 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 June 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 Fundamentals, page 10. Strategies for Using Indexes. By Miriam Liskin. Learning how to use the right type of index for a situation is the key to getting the best performance from FoxPro. This article explains what structural, compound, compact, and standalone indexes are all about. CDX, complex key expressions, optimize, TRIM,

Functional FoxPro, page 16. Getting Exclusive Use. By Malcolm C. Rubel. The problem we face and the reason we want a function to help us is that we have no way of knowing if the .DBF file we want is in use elsewhere on the network. USE EXCLUSIVE, SET EXCLUSIVE, UNIQUE(), DESCEND(), FOR(), TAGNO(), PACK, INDEX, MODIFY STRUCTURE, ZAP, SYS(2011), FLOCK()

Data Dictionary, page 20. The Caveman Data Dictionary Evolves! By Jay Rubin. Here are some improvements on last year's Data Dictionary. Control table.

FoxPro Tip, page 26. When PgUp Doesn't in a Multiple-Screen Set. By Drew Speedie. Problem: You've created a multiple-screen set, and sometimes when you press PgUp, control doesn't go back to the previous screen as it should. Cause: Use of a WHEN clause which evaluates .F. Solution: use SHOW GET DISABLE ENABLE instead.

Report Viewer, page 28. A Report Viewer for DOS, Windows, and Mac. By Menachem Bazian. ON THE COVER. As good as FoxPro's reports can be, they are designed to be printed. Yet users often want to view reports on the screen. This issue presents a comprehensive solution that works in all version of FoxPro and gives the user control over the display. Scrolling the report, creating mouse objects, printing a report to a file.

Browse, page 40. Browse as a READ Object. By David Bower. Everyone wants to do it, but how? Here's another way, possibly the best of all, to integrate BROWSE and READ. Trick: Using BROWSE NOCLEAR in WHEN of an invisible button. #ITSEXPRESSION, #WNAME, SCHEME(), SHOW GETS.

Q&A, page 50. Answers to Readers' Questions about FoxPro. By Steve Freides and Tamar E. Granor. SELECT SQL, ORDER BY, SYS(3), Aliases, Report Writer UDF's, UPDATED().