FoxPro 2.6 Enhancements to the Xbase Language

ID: Q113800

2.6x    | 2.6x

WINDOWS | MS-DOS kbprg

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

Keywords          : FxinteropDbase 
Version           : 2.6x    | 2.6x
Platform          : MS-DOS WINDOWS