KnowledgeBase Archive

An Archive of Early Microsoft KnowledgeBase Articles

View on GitHub

Q137507: FoxPro Advisor Magazine Articles June 1995

Article: Q137507
Product(s): Microsoft FoxPro
Version(s): 
Operating System(s): 
Keyword(s): 
Last Modified: 12-AUG-1999

-------------------------------------------------------------------------------
The information in this article applies to:

- 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.

Application Distribution, page 74. FoxPro 2.x.
Distribute Printer Setups -- Automatically. By Shakeel Ajam.
This tip provides an easy way to put specialized information into each user's
resource file.

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.

Additional query words: VFoxWin dba fpa

======================================================================
Keywords          :  
Technology        : kbVFPsearch kbAudDeveloper kbVFP300

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.