KnowledgeBase Archive

An Archive of Early Microsoft KnowledgeBase Articles

View on GitHub

Q127036: FoxPro Advisor Magazine Articles July 1994

Article: Q127036
Product(s): Microsoft FoxPro
Version(s): 2.60a | 2.60a | 2.60a
Operating System(s): 
Keyword(s): 
Last Modified: 11-AUG-1999

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