Microsoft KB Archive/140302

= FoxPro Advisor Magazine Articles May 1995 =

PSS ID Number: 140302

Article Last Modified on 12/3/2003

-

The information in this article applies to:


 * Microsoft Visual FoxPro for Windows 3.0
 * Microsoft Visual FoxPro for Windows 6.0
 * Microsoft FoxPro for Windows 2.5
 * Microsoft FoxPro for Windows 2.5a
 * Microsoft FoxPro for Windows 2.5b
 * Microsoft FoxPro for Windows 2.6
 * Microsoft FoxPro for Windows 2.6a
 * Microsoft FoxPro for MS-DOS 2.0
 * Microsoft FoxPro for MS-DOS 2.5
 * Microsoft FoxPro for MS-DOS 2.5a
 * Microsoft FoxPro for MS-DOS 2.5b
 * Microsoft FoxPro for MS-DOS 2.6
 * Microsoft FoxPro for MS-DOS 2.6a
 * Microsoft FoxPro for Macintosh 2.5b
 * Microsoft FoxPro for Macintosh 2.5c
 * Microsoft FoxPro for Macintosh 2.6a

-



This article was previously published under Q140302



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 KB140302

Technology: kbAudDeveloper kbFoxPro200DOS kbFoxPro250 kbFoxPro250a kbFoxPro250aDOS kbFoxPro250b kbFoxPro250bDOS kbFoxPro250bMac kbFoxPro250cMac kbFoxPro250DOS kbFoxPro260 kbFoxPro260a kbFoxPro260aDOS kbFoxPro260aMac kbFoxPro260DOS kbFoxproSearch kbHWMAC kbOSMAC kbVFP300 kbVFP600 kbVFP600Search kbVFPsearch kbZNotKeyword3

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2004 Microsoft Corporation. All rights reserved.