FoxPro 2.6 Enhancements to the Xbase Language

Last reviewed: April 30, 1996
Article ID: Q113800
The information in this article applies to:
  • Microsoft FoxPro for Windows, versions 2.6x
  • Microsoft FoxPro for MS-DOS, versions 2.6x

SUMMARY

The information below describes the enhancements to the Xbase language in FoxPro 2.6.

This information is also available in the FoxPro Windows-style online Help file (FOXHELP.HLP). To go directly to this topic, choose dBASE Help from the Help menu, and then select "FoxPro Enhancements to the Xbase Language."

MORE INFORMATION

                 FOXPRO ENHANCEMENTS TO THE XBASE LANGUAGE
                 =========================================

FoxPro contains many commands and functions that do not exist in dBASE IV (or, of course, dBASE III PLUS). Here is a partial list of those commands.

Memory Variable/Array Manipulation

   ACOPY()
   ADEL()
   ADIR()
   AELEMENT()
   AFIELDS()
   AINS()
   ALEN()
   ASCAN()
   ASORT()
   ASUBSCRIPT()
   SCATTER

General Commands and Functions

   BETWEEN()
   CURDIR()
   EMPTY()
   EXTERNAL

   FOR ... ENDFOR ..NEXT

   GETFILE()
   GOMONTH()
   HEADER()

   HELP IN WINDOW

   LOCFILE()

   OCCURS()

   ON()
   POP KEY
   PUSH KEY
   RDLEVEL()

   RESTORE FROM FROM <file> | FROM MEMO
   RESTORE MACROS FROM <file> | FROM MEMO

   SCHEME()
   SCOLS()
   SET HELP TO

   SET HOURS TO 12|24
   SET NOTIFY ON|OFF
   SET PDSETUP TO

   SET RESOURCE
   SET SHADOWS
   SET TRBETWEEN
   SET UDFPARMS
   SROWS()
   TARGET()

   WAIT WINDOW

Low-Level File I/O Functions

   FCHSIZE()
   FCLOSE()*
   FCREATE()*
   FEOF()*
   FERROR()*
   FFLUSH()*
   FGETS()*
   FOPEN()*
   FPUTS()*
   FREAD()*
   FSEEK()*
   FWRITE()*
   HEADER()*

   * found only in dBASE IV version 1.5 or 2.0

SQL Statements

   CREATE TABLE FROM ARRAY
   INSERT INTO ... VALUES ... FROM ARRAY
   SELECT ALL ... DISTINCT ... FROM INTO

   SET ANSI

Window Processing Commands and Functions

   WBORDER()
   WCHILD()
   WCOLS()
   WEXIST()
   WLAST()
   WLCOL()
   WLROW()
   WMAXIMUM()
   WMINIMUM()
   WONTOP()
   WOUTPUT()
   WPARENT()
   WREAD()
   WROWS()
   WVISIBLE()

Menu-Related Commands and Functions

   CNTBAR()
   CNTPAD()

   POP MENU ... TO MASTER

   POP POPUP
   PRMBAR()
   PRMPAD()
   PUSH MENU
   PUSH POPUP
   RELEASE BAR
   RELEASE PAD
   SET MARK OF
   SET STICKY
   SET SYSMENU
   SIZE POPUP
   SKPBAR()
   SKPPAD()

Keyboard and Mouse Commands and Functions

   CAPSLOCK()
   CHRSAW()
   INSMODE()
   KEYBOARD
   MDOWN()
   NUMLOCK()

   SET MOUSE TO

Text and Data Formatting

   ATCLINE()
   ATLINE()
   PUTFILE()
   MODIFY MEMO
   @ ... EDIT - Text Edit Regions

Project/Create Application Commands

   BUILD APP ... FROM <project>
   BUILD EXE FROM  <project>

   BUILD PROJECT

Screen-Related Commands

   _CUROBJ
   OBJNUM()

   RESTORE SCREEN FROM memvar

   SHOW GET ... ENABLE | DISABLE
   SHOW GETS ENABLE | DISABLE
   SHOW OBJECT

Generator Directives

   #ITSEXPRESSION
   #READCLAUSES
   #REDEFINE
   #SECTION
   #WNAME


Additional reference words: FoxDos FoxWin 2.60 2.60a foxhelp.dbf
foxhelp.hlp improvement superset
KBCategory: kbprg
KBSubcategory: FxinteropDbase


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.

Last reviewed: April 30, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.