DOCUMENT:Q140302 30-JUL-1999 [foxpro] TITLE :FoxPro Advisor Magazine Articles May 1995 PRODUCT :Microsoft FoxPro PROD/VER:2.50x 2.60 2.60a 3.00 | 2.00 2.5 OPER/SYS: KEYWORDS:kb3rdparty kbvfp300 kbvfp600 ====================================================================== ------------------------------------------------------------------------------- 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 1999.