Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- The Guide To Clipper - Norton Guide http://www.X-Hacker.org [^^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.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson