FoxPro Advisor Magazine Articles June 1995

• Microsoft Visual FoxPro for Windows, version 3.0

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

This article lists the Table of Contents for the June 1995 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 OLE and the Object Management Group Get Together. Add QBE Builder and Report Writer to FoxPro Programs. Mission Critical Table and Database Recovery. Real-Time Project Management Tool for Developers. Add-On Tool Leverages FoxPro SQL. New Names for Upgrades to Visual FoxPro.

Editor's View, page 8. For the Greater Good. By Tamar E. Granor. Tamar explains how a number of vendors have helped the community as a whole, plus some changes in FoxPro Advisor, and a rundown of spring conferences.

Tips, Tricks, & Traps, page 12. By Drew Speedie. This issue's expanded Tips column includes a number of ways to increase your productivity, as well as some hints on improving your code.

FoxPro 2.x. SQL Out of Memory Blues? Dynamic Refresh of SAY Colors. Indexing USE .. AGAIN Cursors.

FoxPro 2.x, Visual FoxPro 3.0. An Overlooked Operator, the modulus. Debugging Reports. Use FILER With Wildcards. Trim CR/LF's From Memo Fields. CTRL+ALT+SHIFT to See the Screen.

Visual FoxPro 3.0. OLE Support in the Project Manager. New Directory Commands. New Modeless FIND dialog. FIND / REPLACE in the Form and Class Designers. Color Scheme 15 Now Reserved. Parents Are Useful!

Developer's View, page 16. Visual FoxPro 3.0. I Hear a Symphony. By Alan Schwartz. Alan shows how writing object-oriented applications is more like conducting an orchestra than operating a machine room. Sending a message. Object messaging is like dialing a phone -- it all depends where you're calling from. Relationship of containership. Inheritance and parents. Get a spatial state of mind.

Functional FoxPro, page 20. Visual FoxPro 3.0. Before You Debug in Visual FoxPro, Know Your Objects. By Malcolm C. Rubel. Visual FoxPro changes the way we debug. Mac talks about the changes. Object-oriented code is very different from what we're used to. Object oriented code. Debugging objects. Visual FoxPro events. Debugging tools for Visual FoxPro.

FoxPro Fundamentals, page 24. FoxPro 2.x, Visual FoxPro 3.0. Database Design 101. By Miriam Liskin. Designing the database is one of the most important parts of application development. Miriam goes through the steps involved in determining the tables and relations in a database. You can come up with a good database design using just paper and pencil. Designing tables. Identifying tables. Defining entities. Describing entities. Avoiding redundancy. Avoid calculated fields. Evaluating the design. Planning table relationships. One-to-one relationships. One-to-many relationships. Many-to-many relationships.

Review, page 32. FoxPro 2.x for MS-DOS/Windows Project Management for Workgroups. By Robert Gryphon. FoxPro's Project Manager is useful, but not very usable. Robert reviews CAPCON, a product designed to overcome many of Project Manager's weaknesses. CAPCON increases a manager's control over the application- building process, providing security and documentation, too.

CAPCON 2.0, $395 Standard Edition CAPCON 2.0-Lite $185 CAPCON 2.0 Single-User $199 Cascade Interactive Designs, Inc. 1300 Spring St. Seattle, WA 98104 (800) 863-0389, (206) 720-1234 Fax (206) 720-6211

Event-Driven Applications, page 36. Visual FoxPro 3.0 Foundation READ is Dead! By Frank Grimberg. Visual FoxPro means never having to code a foundation READ. Frank explains how the new READ EVENTS command works and how to use it.

Menus, page 44. FoxPro 2.x, Visual FoxPro 3.0. Making Sense of GUI Menus. By Nancy Jacobsen. It's always been difficult to match GUI menu standards with database applications. Nancy explains why and shows how you can make a good fit.

Menus, page 56. FoxPro 2.x. You Can Go Back Again. By Jeff Daniels. You often want to put the user back in the menu with the last choice high-lighted. Jeff explains why this is difficult and shows two techniques to let you do it anyway.

Screen Builder, page 62. FoxPro 2.x for Windows/Macintosh. Don't GET Mad -- GET it Right! By Drew Speedie. A generator directive lets you get the right number of characters -- even in a proportional font.

Network Printing, page 66. FoxPro 2.x for MS-DOS. Print It Where They Want It. By Benjamin A. Aminnia. Ben shows how easy it is to let the user choose a network printer in FoxPro for MS-DOS.

Numeric Operations, page 72. FoxPro 2.x. Convert Fractions to Decimals and Back. By Antonio and Alfonso De Pasquale. Some values are represented best by fractions. The De Pasquales show how to

 easily change fractions to decimals and back.

Date Math, page 76. FoxPro 2.x. How Long Has it Been? By Michael Norton. figuring out how much time has passed between two events isn't as easy as it seems. Michael provides a pair of functions to compute elapsed time.

Developer Toolbox, page 78, FoxPro 2.x. Recycling DELETED Records. By Jim McKinniss. Jim provides another approach to recycling deleted records. This version, while less generic, is shorter and faster.

FoxPro Advisor Q&A, page 82. By Tamar E. Granor, and Ted Roche. Tamar and Ted offer advice on network errors, lost memo files, checking Windows environment settings, and editing contained objects in Visual FoxPro.