DOCUMENT:Q127036 11-AUG-1999 [foxpro] TITLE :FoxPro Advisor Magazine Articles July 1994 PRODUCT :Microsoft FoxPro PROD/VER:2.60a | 2.60a | 2.60a OPER/SYS: KEYWORDS: ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft FoxPro for Windows, versions 2.5x, 2.6, 2.6a - Microsoft FoxPro for MS-DOS, versions 2.0, 2.5x, 2.6, 2.6a - Microsoft FoxPro for Macintosh, versions 2.5x, 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 ======= Below is the table of contents of the July 1994 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. Editor's View, page 8. Microsoft Does the Hokey Pokey. By John L. Hawkins. Functional FoxPro, page 10. FoxPro 2.6 Commands and Functions. By Malcolm C. Rubel. FoxPro 2.6 is being promoted as a more complete alternative to dBASE IV. Even for developers who can't spell dBASE, there are plenty of new goodies in FoxPro 2.6. SET COMPATIBLE DB4, SET COMPATIBLE ON, FOXPLUS, Null support, EMPTY(), ISBLANK(), FDATE(), FTIME(), FSIZE(), PARAMETERS(). Inside a .DBF: Why ISBLANK() Doesn't Work with All Data Types, page 14. By Malcolm C. Rubel. All data in a dbf is stored as character ASCII data. FoxPro Fundamentals, page 16. Programming for Networks. By Miriam Liskin. When data is shared on a network, locking is essential. The techniques presented here get you started, and may be all you want. EXCLUSIVE, SHARED, CALCULATE, SUM, REPLACE, DELETE, SET LOCK, READ NOLOCK, RLOCK(), SET REPROCESS, RECALL, BROWSE WHEN, BROWSE VALID, Screen Builder, page 22. Fonts, Pixels, and the FoxPro for Windows Screen Builder. By Robert Green. What is the proper SIZE of a GET when a proportional font is used? SCATTER MEMVAR, FONTMETRIC(), PICTURE. Screen Builder, page 24. Tools for Sizing Proportional Font GET Fields. By Drew Speedie. FONTMETRIC(), GETFONT(), TEXTMERGE, TXTWIDTH(), numeric field and character fields with numbers, leading and trailing spaces, READBORDER, GET. Screen Builder, page 30. Make Your popups and Lists More Descriptive. By Joe Homnick. Basing popups and scrollable lists on arrays give you tremendous flexibility. SCATTER MEMVAR, SHOW GETS, ASCAN(). Select SQL, page 32. Modify Table Structures on the Fly. By. Wayne A. Willingham. SQL is a query language. So how and why is it useful for modifying the structure of data tables? COPY STRUCTURE EXTENDED, APPEND, CREATE TABLE FROM ARRAY, AFIELDS(), SELECT, INSERT. Developer Toolkit, page 36. Storing Multiple Values in a Single Field. By Robert Gryphon. In effect, a multi-value field is a one-dimensional array of values stored in a single field of a given record.. ADEL(), AINS(), ASCAN(), MEMLINES(), MLINE(), SCATTER, GATHER, SET MEMOWIDTH, SET RELATION. FoxPro Tip, page 46 (table of contents says page 36 in error). When SET DEFAULT Doesn't. By Tamar E. Granor. When you change the FoxPro drive with SET DEFAULT, the DOS drive isn't changed. Q&A, page 50. FoxPro Solutions. By Steve Freides and Tamar E. Granor. Screen sets, PgUp, PgDn, Invisible buttons, _CUROBJ, Network Printing, Novell capture, FPNET, GPLIB, NetLib, SET PRINT TO \\SPOOLER, UDFs, SET FILTER, conditional indexing. Additional query words: FoxWin FoxDos FoxMac 2.50, 2.50a 2.50b 2.50c dba fpa novel ====================================================================== Keywords : Technology : kbHWMAC kbOSMAC kbAudDeveloper kbFoxproSearch kbZNotKeyword3 kbFoxPro260aMac kbFoxPro200DOS kbFoxPro260DOS kbFoxPro260aDOS kbFoxPro260 kbFoxPro260a Version : 2.60a | 2.60a | 2.60a ============================================================================= 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.