[^^Up^^]
[Menu]
[About The Guide]
AADD() Add a new element to the end of an array
ABS() Return the absolute value of a numeric expression
ACHOICE() Execute a pop-up menu
ACLONE() Duplicate a nested or multidimensional array
ACOPY() Copy elements from one array to another
ADEL() Delete an array element
ADIR()* Fill a series of arrays with directory information
AEVAL() Execute a code block for each element in an array
AFIELDS()* Fill arrays with the structure of the current database file
AFILL() Fill an array with a specified value
AINS() Insert a NIL element into an array
ALERT() Display a simple modal dialog box
ALIAS() Return a specified work area alias
ALLTRIM() Remove leading and trailing spaces from a character string
ALTD() Invoke the CA-Clipper debugger
ARRAY() Create an uninitialized array of specified length
ASC() Convert a character to its ASCII value
ASCAN() Scan an array for a value or until a block returns true (.T.)
ASIZE() Grow or shrink an array
ASORT() Sort an array
AT() Return the position of a substring within a character string
ATAIL() Return the highest numbered element of an array
BIN2I() Convert a 16-bit signed integer to a numeric value
BIN2L() Convert a 32-bit signed integer to a numeric value
BIN2W() Convert a 16-bit unsigned integer to a numeric value
BLOBDIRECTEXP() Export the contents of a BLOB pointer to a file
BLOBDIRECTGET() Retrieve data from a BLOB file without referencing a field
BLOBDIRECTIMP() Import a file into a BLOB file and return pointer to the data
BLOBDIRECTPUT() Put data in a BLOB file without referencing a specific field
BLOBEXPORT() Copy the contents of a memo field number to a BLOB file
BLOBGET() Get the contents of a BLOB, identified by memo field number
BLOBIMPORT() Read the contents of a BLOB file into a memo field
BLOBROOTGET() Retrieve the data from the root area of a BLOB file
BLOBROOTLOCK() Obtain a lock on the root area of a BLOB file
BLOBROOTPUT() Store data in the root area of a BLOB file
BLOBROOTUNLOC() Release the lock on a BLOB file's root area
BOF() Determine when beginning of file is encountered
BREAK() Branch out of a BEGIN SEQUENCE...END construct
BROWSE()* Browse records within a window
CDOW() Convert a date value to a character day of the week
CHR() Convert an ASCII code to a character value
CMONTH() Convert a date to a character month name
COL() Return the screen cursor column position
COLORSELECT() Activate attribute in current color settings
CTOD() Convert a date string to a date value
CURDIR() Return the current DOS directory
DATE() Return the system date as a date value
DAY() Return the day of the month as a numeric value
DBAPPEND() Append a new record to the database in the current work area
DBCLEARFIL() Clear a filter condition
DBCLEARIND() Close all indexes for the current work area
DBCLEARREL() Clear active relations
DBCLOSEALL() Close all occupied work areas
DBCLOSEAREA() Close a work area
DBCOMMIT() Flush pending updates
DBCOMMITALL() Flush pending updates in all work areas
DBCREATE() Create a database file from a database structure array
DBCREATEIND() Create an index file
DBDELETE() Mark a record for deletion
DBEDIT() Browse records in a table layout
DBEVAL() Evaluate code block for each record matching scope/condition
DBF()* Return current alias name
DBFIELDINFO() Return and optionally change information about a field
DBFILEGET() Insert the contents of a field into a file
DBFILEPUT() Insert the contents of a file into a field
DBFILTER() Return the current filter expression as a character string
DBGOBOTTOM() Move to the last logical record
DBGOTO() Position record pointer to a specific identity
DBGOTOP() Move to the first logical record
DBINFO() Return and optionally change database file information
DBORDERINFO() Return and optionally change order and index file information
DBRECALL() Reinstate a record marked for deletion
DBRECORDINFO() Return and optionally change information about a record
DBREINDEX() Recreate all active indexes for the current work area
DBRELATION() Return the linking expression of a specified relation
DBRLOCK() Lock the record at the current or specified identity
DBRLOCKLIST() Return an array of the current lock list
DBRSELECT() Return the target work area number of a relation
DBRUNLOCK() Release all or specified record locks
DBSEEK() Move to the record having the specified key value
DBSELECTAR() Change the current work area
DBSETDRIVER() Return the database driver and optionally set a new driver
DBSETFILTER() Set a filter condition
DBSETINDEX() Empty orders from an order bag into the order list
DBSETORDER() Set the controlling order
DBSETRELAT() Relate two work areas
DBSKIP() Move relative to the current record
DBSTRUCT() Create an array containing the structure of a database file
DBUNLOCK() Release all locks for the current work area
DBUNLOCKALL() Release all locks for all work areas
DBUSEAREA() Use a database file in a work area
DELETED() Return the deleted status of the current record
DESCEND() Create a descending index key value
DEVOUT() Write a value to the current device
DEVOUTPICT() Write a value to the current device using a picture clause
DEVPOS() Move the cursor or printhead to a new position
DIRCHANGE() Change the current DOS directory
DIRECTORY() Create an array of directory and file information
DIRMAKE() Create a directory
DIRREMOVE() Remove a directory
DISKCHANGE() Change the current DOS disk drive
DISKNAME() Return the current DOS drive
DISKSPACE() Return the space available on a specified disk
DISPBEGIN() Begin buffering screen output
DISPBOX() Display a box on the screen
DISPCOUNT() Return the number of pending DISPEND() requests
DISPEND() Display buffered screen updates
DISPOUT() Write a value to the display
DOSERROR() Return the last DOS error number
DOW() Convert a date value to a numeric day of the week
DTOC() Convert a date value to a character string
DTOS() Convert a date value to a string formatted as yyyymmdd
EMPTY() Determine if the result of an expression is empty
EOF() Determine when end of file is encountered
ERRORBLOCK() Post a code block to execute when a runtime error occurs
ERRORLEVEL() Set the CA-Clipper return code
EVAL() Evaluate a code block
EXP() Calculate e**x
FCLOSE() Close an open binary file and write DOS buffers to disk
FCOUNT() Return the number of fields in the current .dbf file
FCREATE() Create and/or truncate a binary file to zero-length
FERASE() Delete a file from disk
FERROR() Test for errors after a binary file operation
FIELDBLOCK() Return a set-get code block for a given field
FIELDGET() Retrieve the value of a field using the field position
FIELDNAME() Return a field name from the current database (.dbf) file
FIELDPOS() Return the position of a field in a work area
FIELDPUT() Set the value of a field variable using the field position
FIELDWBLOCK() Return a set-get code block for a field in a given work area
FILE() Determine if files exist in the default directory or path
FKLABEL()* Return function key name
FKMAX()* Return number of function keys as a constant
FLOCK() Lock an open and shared database file
FOPEN() Open a binary file
FOUND() Determine if the previous search operation succeeded
FREAD() Read characters from a binary file into a buffer variable
FREADSTR() Read characters from a binary file
FRENAME() Change the name of a file
FSEEK() Set a binary file pointer to a new position
FWRITE() Write to an open binary file
GBMPDISP() Display a bitmap (.BMP) file on screen
GBMPLOAD() Load a bitmap (.bmp) or icon (.ico) file into memory
GELLIPSE() Draw an ellipse or circle
GETACTIVE() Return the currently active Get object
GETAPPLYKEY() Apply a key to a Get object from within a reader
GETDOSETKEY() Process SET KEY during GET editing
GETENV() Retrieve the contents of a DOS environment variable
GETPOSTVALID() Postvalidate the current Get object
GETPREVALID() Prevalidate a Get object
GETREADER() Execute standard READ behavior for a Get object
GFNTERASE() Erase a font from memory
GFNTLOAD() Load a font file into memory
GFNTSET() Set an already loaded font as active
GFRAME() Draw a frame with a 3-D look
GGETPIXEL() Get color information for a pixel
GLINE() Draw a line in graphic mode
GMODE() Switch video mode
GPOLYGON() Draw a polygon on screen
GPUTPIXEL() Draw a pixel on the screen
GRECT() Draw a rectangle in graphic mode
GSETCLIP() Define the allowed display area
GSETEXCL() Define a screen region to be excluded from display
GSETPAL() Change components of a color
GWRITEAT() Draw graphic text without background
HARDCR() Replace all soft carriage returns with hard carriage returns
HEADER() Return the current database file header length
I2BIN() Convert a CA-Clipper numeric to a 16-bit binary integer
IF() Return the result of an expression based on a condition
IIF() Return the result of an expression based on a condition
INDEXEXT() Return index extension defined by the current database driver
INDEXKEY() Return the key expression of a specified index
INDEXORD() Return the order position of the controlling index
INKEY() Extract a character from the keyboard buffer or a mouse event
INT() Convert a numeric value to an integer
ISALPHA() Determine if the leftmost character in a string is alphabetic
ISCOLOR() Determine if the current computer has color capability
ISDIGIT() Determine if the leftmost character in a string is a digit
ISLOWER() Determine if the leftmost character is a lowercase letter
ISPRINTER() Determine whether LPT1 is ready
ISUPPER() Determine if the leftmost character in a string is uppercase
L2BIN() Convert a CA-Clipper numeric value to a 32-bit binary integer
LASTKEY() Return INKEY() value of last key extracted from the keyboard
LASTREC() Determine the number of records in the current .dbf file
LEFT() Extract substring beginning with first character in a string
LEN() Return the length of a string or number of array elements
LOG() Calculate the natural logarithm of a numeric value
LOWER() Convert uppercase characters to lowercase
LTRIM() Remove leading spaces from a character string
LUPDATE() Return the last modification date of a database (.dbf) file
MAX() Return the larger of two numeric or date values
MAXCOL() Determine the maximum visible screen column
MAXROW() Determine the maximum visible screen row
MCOL() Determine the mouse cursor's screen column position
MDBLCLK() Determine the double-click speed threshold of the mouse
MEMOEDIT() Display or edit character strings and memo fields
MEMOEDIT() continued...
MEMOLINE() Extract a line of text from a character string or memo field
MEMOREAD() Return the contents of a disk file as a character string
MEMORY() Determine the amount of available free pool memory
MEMOSETSUPER() Set an RDD inheritance chain for the DBFMEMO database driver
MEMOTRAN() Replace carriage return/linefeeds in character strings
MEMOWRIT() Write a character string or memo field to a disk file
MEMVARBLOCK() Return a set-get code block for a given memory variable
MENUMODAL() Activate a top bar menu
MHIDE() Hide the mouse pointer
MIN() Return the smaller of two numeric or date values
MLCOUNT() Count the number of lines in a character string or memo field
MLCTOPOS() Return position of a string based on line and column position
MLEFTDOWN() Determine the press status of the left mouse button
MLPOS() Determine the position of a line in a string or memo field
MOD()* Return the dBASE III PLUS modulus of two numbers
MONTH() Convert a date value to the number of the month
MPOSTOLC() Return line/ column position of a string based on a position
MPRESENT() Determine if a mouse is present
MRESTSTATE() Re-establish the previous state of a mouse
MRIGHTDOWN() Determine the status of the right mouse button
MROW() Determine a mouse cursor's screen row position
MSAVESTATE() Save the current state of a mouse
MSETBOUNDS() Set screen boundaries for the mouse cursor
MSETCLIP() Define an inclusion region
MSETCURSOR() Determine a mouse's visibility
MSETPOS() Set a new position for the mouse cursor
MSHOW() Display the mouse pointer
MSTATE() Return the current mouse state
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson