Q140302: FoxPro Advisor Magazine Articles May 1995
Article: Q140302
Product(s): Microsoft FoxPro
Version(s): 2.50x 2.60 2.60a 3.00 | 2.00 2.5
Operating System(s):
Keyword(s): kb3rdparty kbvfp300 kbvfp600
Last Modified: 30-JUL-1999
-------------------------------------------------------------------------------
The information in this article applies to:
- Microsoft Visual FoxPro for Windows, versions 3.0, 6.0
- Microsoft FoxPro for Windows, versions 2.5, 2.5a, 2.5b, 2.6, 2.6a
- Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, 2.5a, 2.5b, 2.6, 2.6a
- Microsoft FoxPro for Macintosh, versions 2.5b, 2.5c, 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
=======
NOTE: There was no April 1995 issue of FoxPro Advisor. The cover date was
advanced by one month due to the way that newsstands handle magazines.
Following is the table of contents of the May 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. You may
also contact them via Fax 619-483-9851 or the Internet
70007.1614@compuserve.com.
MORE INFORMATION
================
FoxPro News, page 6. FoxPro Vendors Come Together Around Codebook. ProMatrix for
FoxPro Includes RAD Capabilities. FoxExpress Upgrade Includes Security. FoxPro
Advisor Conference & Exposition.
Editors's View, page 8. 3...2..1...Blast Off! Visual FoxPro launches at DevCon.
What's next? By Tamar E. Granor. Tamar reviews DevCon and the Visual FoxPro
Launch and discusses where FoxPro is headed next.
Client/Server, page 12. Visual FoxPro 3.0. Use Visual FoxPro to Design Critical
Applications for Client/Server. Visual FoxPro 3.0's object orientation, database
connectivity, and front-end tools let you properly scale applications as
companies grow -- and as business environments change. By Y. Alan Griver. Alan
explains how Visual FoxPro's new tools make it ideal for designing
business-oriented solutions. Business Process Reengineering (BPR), Nomadic,
Front-end development, Business rule enforcement, Back-end (database)
development, sample application, and procedures.
Tips, Tricks, & Traps, page 18. By Drew Speedie. This issue's tips cover
Report Writer, Project Manager, some new Visual FoxPro commands, and several
tricks to speed up development.
Tip: Visual FoxPro 3.0. Cycle Through Relevant Method Snippets. Form Builder
Properties PageUp PageDown.
Tip: Visual FoxPro 3.0. Debugging/Setting Form Properties. THIS, THISFORM,
THISFORMSET, PARENT, _Screen.ActiveForm.
Tip: FoxPro 2.x., Visual FoxPro 3.0. Paste -- Don't Type! _CLIPTEXT.
Tip: FoxPro 2.x., Visual FoxPro 3.0. Useful Symbols Information in .PJX. Program
using a project's memo field named Symbols, to display all files that call a
specific program.
Tip: FoxPro 2.x., Visual FoxPro 3.0. Getting "PageNumber nn of nn" Out of the
Report Writer. UDF SETPAGE()
Tip: Visual FoxPro 3.0 Entering .NULL. in Table Fields. From the keyboard, press
CTRL+0.
Tip: Visual FoxPro 3.0 WAIT WINDOW ... AT ... to specify the position of a WAIT
WINDOW.
Tip: FoxPro 2.x., Visual FoxPro 3.0. Help for Modifying Global Procedures.
Project Show Errors.
Functional FoxPro, page 22. FoxPro 2.x, Visual FoxPro 3.0. Calculate Loan Rates
and Amounts. Understanding the basic formula for payments lets you create a
whole collection of useful functions. By Malcolm Rubel. Mac takes a look at
calculating loan payments and interest rates. Sounds easy, but FoxPro's
PAYMENT() function has a bug you need to know about. Negative interest rates,
binary seek, binary search, and APR.
FoxPro Fundamentals, page 26. Visual FoxPro 3.0. Visual FoxPro's New Data Types.
Choosing the right data type is important. By Miriam Liskin. Visual FoxPro
includes several new data types. Miriam discusses them and explains when you
might need them. Independent of .dbc, free table, General field, OLE object,
Numeric, Float, Currency, Double, binary encoded, double-presision
floating-point, NTOM() Numeric-TO-Money, MTON() Money-TO-Numeric, Date/Time,
DateTime, DATE(), TIME(), DATETIME(), DAY(), MONTH(), YEAR(), SUBSTR(), RIGHT(),
WEEK(), CTOD(), DTOC(), TTOD(), DTOT(), TTOC(), CTOT(), SET DATE, SET CENTURY,
and .NULL.
Form Designer, page 36. Visual FoxPro 3.0. Create Tabbed Forms. The new PageFrame
control lets you create multiple- page forms with or without tabs painlessly. By
Steven Black. Multiple-page tabbed dialogs are rapidly becoming a Windows
standard. Steve shows how Visual FoxPro's PageFrames make developing these
dialogs a breeze. Object, Container, subclasses, .VCX, event model, UDF to show
firing order of events, Formpages, Formset.Load, Formset.Form.Load, Init events,
Commandbutton, tabs never receive focus.
Form Designer, page 44. Visual FoxPro 3.0. Goodbye BROWSE, Hello Grid. Grids
provide everything you wanted from an integrated BROWSE and much, much more. By
Drew Speedie. For a long time, FoxPro developers have asked for a Browse they
could integrate with READ. Drew presents Microsoft's answer -- the Grid control.
Contained object, Container object, column headers, DataEnvironment object,
object outline control, _Screen.ActiveForm.SaveAs("GRID2.SCX"), SetAll method,
NODEFAULT.
Object-Oriented Programming, page 56. Visual FoxPro 3.0. Creating Visual Classes.
With the Visual Class Designer, you can create classes with a minimum of code.
By Menachem Bazian. Menachem continues his introduction to Visual FoxPro's OOP
concepts. In this issue, he uses the Class Designer to build a StopWatch class.
CREATE CLASS, new method, timer class, engine class.
Application Testing, page 62. FoxPro 2.x, Visual FoxPro 3.0. Testing, Testing, Go
Back to School (to Test Your Applications). Here's a way to make sure your
applications are bug-free: Hire high-school students to do the job. By Whil
Hentzen. Whil describes his unique approach to testing applications -- high
school students do it for him.
Programming Tip, page 68. FoxPro 2.x. Restoring the Record Pointer. Here are two
functions that handle the "Record is out of Range" error neatly and
transparently. By Scott Leone. It's easy to save and restore the record pointer
-- unless you're at end-of-file. Scott shares a pair of functions that handle
the EOF() case neatly and transparently, and avoid the "Record is out of range"
error.
Interface Techniques, page 70. FoxPro 2.x. Speed Data Entry in Date Fields. Use
Quicken keystrokes to move from date to date. By Edward Leafe. Quicken's user
interface is very intuitive. Ed shows us how to add one of the most useful
techniques there, changing dates with a collection of special keys, to our
applications. ON KEY LABEL, PUSH KEY CLEAR, POP KEY, WHEN, VALID, GOMONTH(),
current quarter equation,
Update Tip: computing age between dates, page 73. By Tamar E. Granor. CompYear()
from Feb 1995, DATE(), MONTH(), DAY(), GOMONTH(), DTOS().
Security, page 74. FoxPro 2.x. Lock Intruders Out of Your Applications. Combine
FoxPro code with MS-DOS tricks to keep snoops out of your applications. By J.
Neal Ford and Ed Weber. With increasing amounts of sensitive data used in
applications, Neal and Ed present some welcome techniques for keeping the
unauthorized out. INKEY(), LASTKEY(), #DEFINE key constants, CTTY NUL.
Developer's Toolkit, page 76. FoxPro 2.x. Automate Application Building. By Rick
Strahl. Want to automate the process of building applications from your
projects? Rick shows us Quick Builder -- a way to speed up the
compile-test-compile- test cycle we're all familiar with.
Q&A, page 82. By Tamar E. Granor and Steve Freides. Tamar and Steve tackle
the Print Setup dialog, giving users access to the resource file, and Visual
FoxPro's new week-oriented date settings. FoxPro 2.x, Visual FoxPro 3.0.
_MFI_SETUP menu bar unavailable, SYS(1037). FoxPro 2.x. Resource files cannot be
USE SHAREd in different workstation sessions on a network. Flag Read-Only,
Calendar/Diary, SET RESOURCE OFF|ON, FOPEN(), temporary file.
FoxPro 2.x, Visual FoxPro 3.0. Week number for a date in a report comparing weeks
between years but each week must begin on Monday. SET FWEEK counts weeks, and
SET FDOW specifies the first day of the week.
Additional query words: VFoxWin FoxWin FoxDos FoxMac dba fpa vfp
======================================================================
Keywords : kb3rdparty kbvfp300 kbvfp600
Technology : kbHWMAC kbOSMAC kbVFPsearch kbAudDeveloper kbFoxproSearch kbZNotKeyword3 kbFoxPro250bMac kbFoxPro260aMac kbFoxPro250cMac kbFoxPro200DOS kbFoxPro250DOS kbFoxPro250aDOS kbFoxPro250bDOS kbFoxPro260DOS kbFoxPro260aDOS kbFoxPro260 kbFoxPro250 kbFoxPro250a kbFoxPro250b kbFoxPro260a kbVFP300 kbVFP600
Version : 2.50x 2.60 2.60a 3.00 | 2.00 2.5
=============================================================================
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.
Copyright Microsoft Corporation 1986-2002.