[^^Up^^] [Menu] [About The Guide]
ABS() Returns the absolute value of a numeric expression
ACHOICE() Executes a pop-up menu
ACOPY() Copies elements from one array to another
ADEL() Deletes an array element
ADIR() Fills arrays with directory information
AFIELDS() Fills arrays with field definition information
AFILL() Fills an array with a chosen value
AINS() Inserts an undefined element into an array
ALIAS() Obtains specified work area alias name
ALLTRIM() Removes leading and trailing spaces
ALTD() Executes the Debugger
ASC() Returns ASCII value of character expression
ASCAN() Scans an array for a specific value
ASORT() Sorts array contents in ascending order
AT() Returns starting position of a character string
BIN2I() Converts a 16-bit signed integer to a numeric value
BIN2L() Converts a 32-bit signed integer to a numeric value
BIN2W() Converts a 16-bit unsigned integer to numeric values
BOF() Returns .T. when beginning of file is encountered
CDOW() Converts a date value to the name of the day of week
CHR() Converts an ASCII code to a character
CMONTH() Converts a date value to the name of the month
COL() Returns the current cursor screen column position
CTOD() Converts a date string to a date value
CURDIR() Returns the current DOS directory
DATE() Returns the system date as a date value
DAY() Returns the day of the month as a numeric value
DBEDIT() Browses records in a table layout
DBFILTER() Returns the current filter expression
DBRELATION() Returns the expression of the current relation
DBRSELECT() Returns target work area of a specified relation
DELETED() Returns deletion status of the current record
DESCEND() Creates and SEEKs descending order indexes
DISKSPACE() Returns the number bytes available
DOSERROR() Returns the number of the last DOS error
DOW() Returns the day of the week as a numeric value
DTOC() Returns a date value as a character string
DTOS() Returns an 8 character string in "YYYYMMDD" format
EMPTY() Returns (.T.) if the result of an expression is empty
EOF() Returns (.T.) if End Of File is encountered
ERRORLEVEL() Returns the current DOS error level setting
EXP() Calculate e**x
FCLOSE() Closes an open file and writes DOS buffers to disk
FCOUNT() Returns the number of fields in the current (.dbf)
FCREATE() Creates and/or truncates a file to zero length
FERROR() Tests for a DOS error after a file function
FIELD() Returns field name in the current (.dbf)
FILE() Determines if a file exists in the Clipper path
FLOCK() Locks the shared database file in USE
FOPEN() Opens a file
FOUND() Determines if previous search operation succeeded
FREAD() Reads characters from a DOS file into a memvar
FREADSTR() Read characters from a file
FSEEK() Sets the DOS file pointer to a new position
FWRITE() Writes a buffer variable to a specified file
GETE() Retrieves contents of a DOS environmental variable
HARDCR() Replaces all soft carriage returns with hard
HEADER() Returns the header length of the current database
I2BIN() Converts a numeric data type to a 2-byte integer
IF() / IIF() Returns results of expressions based on a condition
INDEXEXT() Returns the index type that is currently in use
INDEXKEY() Returns the key expression of a specified index
INDEXORD() Returns the position of the controlling index
INKEY() Reads a character from the keyboard buffer
INT() Converts a numeric expression to an integer
ISALPHA() Returns (.T.) if leftmost character is alphabetic
ISCOLOR() Returns (.T.) if computer has color graphics
ISLOWER() Returns (.T.) if leftmost character is lower case
ISPRINTER() Determines whether LPT1 is ready
ISUPPER() Returns (.T.) if leftmost character is upper case
L2BIN() Returns a 4-byte string as a 32-bit binary integer
LASTKEY() Returns the ASCII value of the last key fetched
LASTREC() Returns the number of records in the current (.dbf)
LEFT() Returns leftmost characters from a string
LEN() Returns the length of a character expression
LOG() Calculates natural logarithm of a numeric value
LOWER() Converts upper case characters to lower case
LTRIM() Remove leading blanks from a character string
LUPDATE() Returns last (.dbf) modificiation date
MAX() Returns the larger of two numeric or date values
MEMOEDIT() Displays/edits character strings and memo fields
MEMOLINE() Extracts a line of text from a string or memo field
MEMOREAD() Reads the contents of a text file from disk
MEMORY() Determine the amount of available memory
MEMOTRAN() Replaces carriage return/line feed pairs
MEMOWRIT() Writes a character string to a specified disk file
MIN() Returns the smaller of two numeric or date values
MLCOUNT() Counts the number of word-wrapped lines in string
MLPOS() Returns the line number position in a string
MONTH() Converts a date value to the number of the month
NETERR() Determines whether a networking command has failed
NETNAME() Determines the current workstation identification
NEXTKEY() Reads the next keystroke from the keyboard buffer
PCOL() Returns the column position of the print head
PCOUNT() Returns the number of actual parameters passed
PROCLINE() Returns the current source code line number
PROCNAME() Returns the name of the current program executed
PROW() Returns the current row position of the print head
RAT() Returns the last instance of a substring
READEXIT() Toggles the Uparrow/Dnarrow keys as READ exit keys
READINSERT() Returns the current insert mode setting
READVAR() Returns the current GET/MENU variable
RECCOUNT() Returns the number of records in the current (.dbf)
RECNO() Returns the record number of the current work area
RECSIZE() Returns the record length of the current database
REPLICATE() Repeats a string a specified number of times
RESTSCREEN() Displays a saved screen to a specified screen area
RIGHT() Returns a string at the rightmost character
RLOCK() Locks the current record in the current work area
ROUND() Returns a value rounded to specified decimal places
ROW() Returns the current row position of the cursor
SAVESCREEN() Saves a screen region to a memory variable
SCROLL() Designates the direction of screen region scrolling
SECONDS() Returns the number of seconds since 12:00 AM
SELECT() Returns the work area number of an alias
SETCANCEL() Toggles program termination with Alt-C, on or off
SETCOLOR() Returns the current color setting
SETPRC() SETs the PROW() and PCOL() to the specified values
SOUNDEX() Converts a character string to soundex form
SPACE() Returns a string of spaces
SQRT() Returns the square root of a numeric expression
STR() Converts a numeric expression to a character string
STRTRAN() Searches and replaces within a character string
STUFF() Deletes/inserts/replaces characters in a string
SUBSTR() Returns a portion of a character string
TIME() Returns the system time
TONE() Sounds a speaker tone for a specified frequency
TRANSFORM() Formats the results of any data type expression
TRIM() / RTRIM() Removes trailing spaces from the result of a string
TYPE() Returns the character expression type
UPDATED() Determines if pending GETs changed during a READ
UPPER() Converts lower case characters to upper case
USED() Determines if a database file is in USE
VAL() Converts numbers from character to numeric type
WORD() Converts CALL command parameters from double to int
YEAR() Returns the year of the specified date value
Online resources provided by: http://www.ClipX.Net --- NG 2 HTML conversion by Dave Pearson