Table of Contents for FoxPro Advisor Magazine for May 1996

WINDOWS    | MACINTOSH         | MS-DOS                           | UNIX

The information in this article applies to:

• Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b
• Microsoft FoxPro for Macintosh, versions 2.5b, 2.5c, 2.6a
• Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, 2.5a, 2.5b, 2.6, 2.6a
• Microsoft FoxPro for UNIX, version 2.6
• Microsoft FoxPro for Windows, versions 2.5, 2.5a, 2.5b, 2.6, 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 May 1996, Vol.4 No.5, FoxPro Advisor, a magazine published by Data Based Solutions, Inc., Customer Service Department, 4010 Morena Blvd., P.O. Box 17902, San Diego, CA 92177. For more information, please call Data Based Solutions at 619-483-6400, or to place an order, please call them at 800-336-6060. You may also contact them via Fax at (619)483-9851; CompuServe 70007,1614; Internet 70007.1614@compuserve.com, or visit their web site http://www.advisor.com

MORE INFORMATION

FoxPro News, page 6. Microsoft Clarifies FoxPro's Future. FoxFire! 3.0 Includes Web-Browseable Reports. Xplat Offers Enhanced Cross-Platform GUI Development.

Editor's View, page 8. By Tamar E. Granor, Editor. Where Does Visual FoxPro fit In?. Microsoft maintains its commitment to FoxPro. Keypoint: George Goley provided a sales document that compares and discusses features and strengths of Microsoft's product family. Summary: Access for ad-hoc reporting and personal applications. Visual C++ to build OCXs. Visual Basic for small footprint and non-data intensive applications. SQL Server for sensitive, WAN, and high-transaction applications. Visual FoxPro for Line- of-business applications.

COLUMNS: Tips, Tricks, & Traps, page 12. By Drew Speedie. Drew introduces the Tip of the Month, chosen for its everyday usefulness. This issue's Tip of the Month shows you how to keep .BMP's in controls and forms from disappearing.

Tip of the Month: Visual FoxPro 3.0. No More Disappearing Pictures. Moving relative path of .BMPs and .ICOs.

Tip: FoxPro 2.x., Visual FoxPro 3.0. Provide for Undo-ing GETs.

Tip: Visual FoxPro 3.0. Customize Your Toolbars.

Tip: FoxPro 2.x., Visual FoxPro 3.0. Pass Error Functions to Your Error Handler.

Tip: FoxPro 2.x., Visual FoxPro 3.0. A (non-GENSCRNX) Use for Comment Snippets.

Tip: FoxPro 2.x, Visual FoxPro 3.0. Speed Up COUNTs by Using _TALLY Instead.

Tip: Visual FoxPro 3.0. Create Local Views with GENDBC.

Tip: FoxPro 2.x., Visual FoxPro 3.0. Handy Uses for #IF .. #ENDIF.

Tip: Visual FoxPro 3.0. Keyboard Your Way Through the Properties Sheet.

Tip: Visual FoxPro 3.0. Return to the Form Designer after Running Forms.

Tip: Visual FoxPro 3.0. Keep Your Method Code from Prying Eyes. BUILDAPP.PRG.

Tip: Visual FoxPro 3.0. ToolTip Text for Image Controls.

Design, Architecture, & Modeling. Create Toolbars in a Snap, page 22. Visual FoxPro 3.0. By Miriam Liskin. Learn to use the Class Designer to build custom toolbars for your applications. Different toolbars in different contexts.

Managing Development. The Inside Scoop on PEMS, page 32. Visual FoxPro 3.0. By Malcolm C. Rubel. Continuing his tour of Visual FoxPro from A to Z, Mac looks at the functions NVL(), OBJTOCLIENT(), and PEMSTATUS() (new to 3.0b) – and tells you why you need to know about them. .NULL.

ON THE COVER: Smarter Design: Progress bars, which let users know how a task is progressing, make your Visual FoxPro applications shine.

FEATURES: Object-Oriented Development. Show your Progress with a Thermometer, page 36. Visual FoxPro 3.0. By Rick Strahl. Here's a thermometer wwTherm class that communicates the progress of tasks in your applications. Thermometer theory based on percentages concept.

Design, Architecture, & Modeling. Easy Navigation of Multiple Screens, page 20. FoxPro 2.x, Visual FoxPro 3.0. By Benjamin A. Aminnia. Let users access multiple screens in your applications. Ben shows how to do it with a jump screen with 44 buttons.

SQL Programming. Make SQL Code Maintainable, page 48. FoxPro 2.x, Visual FoxPro 3.0. By Stuart Dee. You can make it easier to maintain SQL commands by storing them in a table, then finding and running the right one when you need it.

Squash Squirrelly SQL-SELECT Quirks, page 58. FoxPro 2.x, Visual FoxPro 3.0. By Steven Miller. SQL SELECT is incredibly powerful, but it can be difficult to use. Here's a collection of tips for making SELECT work for you. Real CURSOR vs. USE AGAIN, Outer Join, line too long, UNION.

Cross-Tabs Revisited, page 62. FoxPro 2.x, Visual FoxPro 3.0. By Gerald F. Garcia, Jr. FoxPro's GENXTAB is good for simple cross-tabs, but when you need something complex, it's hard to work with. Here's an alternative for those complicated cross-tabs. Learn about XTABGEN - a tool that provides complex cross-tab capabilities.

Dynamic Data Exchange. Run Applications by Remote Control, page 72. FoxPro 2.x, Visual FoxPro 3.0. By Tom DeMay. Debugging compiled applications is difficult. Tom shows how network DDE can let you remotely control the application, letting you check on its status. Tired of late-night phone calls from perplexed users? Provide answers to their questions easily using Network DDE, which gives you remote access to their apps. FoxPro as a DDE Client and creating your own DDE Server.

ASK ADVISOR: Q&A, page 82. By Tamar E. Granor and Ted Roche. Tamar and Ted provide solutions to the right way to import data, how to suppress code page dialogs, and how to embed icons into .EXE's. FoxPro 2.x, Visual FoxPro 3.x. APPEND FROM, DELIMITED WITH. Visual FoxPro 3.x. Suppress code-page dialog, SET CPDIALOG OFF, CPDBF(), CPCURRENT(), CPZERO.PRG. FoxPro 2.x, Visual FoxPro 3.x. Embed application icon in distributed .EXE, ADDICON vs. Window Minimize via MODIFY WINDOW SCREEN ICON.