[^^Up^^]
[Menu]
[About The Guide]
ABS Returns the absolute value of a numeric expression.
ACHOICE Executes a pop-up menu using character string array.
ACOPY Copies elements from one array to another.
ADEL Deletes an array element.
ADIR Fills a series of arrays with file information.
AFIELDS Fills a series of arrays with field definitions.
AFILL Fills any array with one value.
AINS Inserts a new position into an array.
ALIAS Returns the alias of a work area.
ALLTRIM Removes all leading and trailing spaces.
ALTD Executes the Clipper Debugger within a program.
ASC Returns the ASCII code value of a character.
ASCAN Searches for a specific value within an array.
ASORT To sort an array in ascending order.
AT Returns the position of a string within another string.
BIN2I Converts binary two-byte character string to numeric.
BIN2L Converts binary four-byte character string to numeric.
BIN2W Converts binary four-byte character string to numeric.
BOF Indicates the beginning of a file.
CDOW Returns the name of the day of the week from a date value.
CHR Returns a character for the specified ASCII code.
CMONTH Returns the name of the month from a date value.
COL Returns the current column position of the cursor.
CTOD Converts a character string to a date value.
CURDIR Returns current DOS directory path of specified drive.
DATE Returns system date in the form "mm/dd/yy".
DAY Returns the numeric value of the day of the month from date.
DBEDIT Displays and edits records using browse-style editor.
DBFILTER Determines active filter expression in current area.
DBRELATION Determines the linking expression of specified relation.
DBRSELECT Determines target work area of a specified relation.
DESCEND To create and SEEK descending order indexes.
DELETED Returns the deletion status of the current record.
DISKSPACE Determines available memory on specified disk drive.
DOSERROR Determines error number of the last DOS error.
DOW Returns a number representing day of the week.
DTOC Converts a date value to character string.
DTOS Converts a date value to character string format
EMPTY Returns true if an expression is blank.
EOF Returns true if the end of file is reached.
ERRORLEVEL Returns current DOS error level.
EXP Calculates number based on natural logarithm.
FCLOSE Closes the DOS file corresponding to the specified handle.
FCOUNT Returns the number of fields in the current database file.
FCREATE Creates a new DOS file or truncates existing file to zero.
FERROR Returns the DOS error number after file function terminates.
FIELD Returns the name of specified field in current work area.
FILE Returns true if a specified filename exists.
FLOCK Locks a database file in a network environment.
FOPEN Opens a DOS file.
FOUND Returns true if previous SEEK, FIND, LOCATE was successful.
FREAD Reads characters from a DOS file into character variable.
FREADSTR Reads characters from a DOS file.
FSEEK Moves the file pointer to new position in a DOS file.
FWRITE Writes a buffer variable to a specified DOS file.
GETE Retrieve the contents of a DOS environmental variable.
HARDCR Replaces soft carriage returns with hard carriage returns.
HEADER Determines length of header area of current database file.
I2BIN Converts integer to two-byte character string.
IF/IIF Provides for conditional processing of expressions.
INDEXEXT Returns "NTX" or "NDX" to indicate current type of index.
INDEXKEY Returns the key expression of a specified index.
INDEXORD Returns the controlling index as a numeric value.
INKEY Returns numeric ASCII value of the key pressed.
INT Converts any numeric expression into an integer.
ISALPHA Returns true if first character in string is alphabetic.
ISCOLOR Returns true if a color display is installed.
ISLOWER Returns true if first character in string is lowercase.
ISPRINTER Determines whether LPT1 is ready.
ISUPPER Returns true if first character in string is uppercase.
L2BIN Converts integer to four-byte character string.
LASTKEY Returns numeric ASCII value of the last key pressed.
LASTREC/RECCOUNT Returns number of records in current work area.
LEN Returns number of characters in character string.
LEFT Extracts characters from left side of character string.
LOG Returns natural logarithm of a given number.
LOWER Converts upper case characters to lower case.
LTRIM Removes leading blanks from a character expression.
LUPDATE Determines date that current database was last modified.
MAX Returns the greater of two numeric or date expressions.
MEMOEDIT Displays and edits memofields and long strings.
MEMOLINE Returns formatted line from memofield or character exp.
MEMOREAD Returns the specified disk file as a character string.
MEMORY Returns the available free pool memory.
MEMOTRAN Returns character string with all CRs and LFs replaced.
MEMOWRIT Writes character string to specified disk file.
MIN Returns the lesser of two numeric or date expressions.
MLCOUNT Returns number of lines in a memofield or character exp.
MLPOS Returns position of specified line number in memo field.
MONTH Returns number representing month from a date variable.
NETERR Returns true if network environmental error occurs.
NETNAME Returns text of the computer name.
NEXTKEY Reads the next keystroke without removing it from buffer.
PCOL Returns the current column position on printer.
PCOUNT Returns number of actual parameters passed to a function.
PROCLINE Returns source code line number of current program.
PROCNAME Returns name of current program or procedure.
PROW Returns current row position on printer.
RAT Searches character string for last instance of a substring.
READVAR Returns the name of the current GET/MENU variable.
READEXIT Toggles the Uparrow and Dnarrow as READ exit keys.
READINSERT Toggle/report current insert mode setting for READs.
RECNO Returns the current record number of the current work area.
RECSIZE Determines record length of current database file.
REPLICATE Repeats a character expression a specified number of times.
RESTSCREEN Displays a previously saved screen region.
RIGHT Extracts characters from right side of character string.
RLOCK/LOCK Attempts to lock the current record.
ROUND Returns rounded numbers to specified number of decimals.
ROW Returns current screen row location of the cursor.
RTRIM Removes trailing blanks from a character expression.
SAVESCREEN Saves specified screen region to be redisplayed.
SCROLL Uses window coordinates to scroll or blank part of screen.
SECONDS Returns system time in seconds and hundredths.
SELECT Returns the number of the current work area.
SETCANCEL Toggle program termination with Alt-C, on or off.
SETCOLOR Determines current or previous color setting.
SETPRC Sets PROW() and PCOL() functions to specified values.
SOUNDEX Converts character string to soundex form for searching.
SPACE Create character string of specified number of spaces.
SQRT Returns the square root of a given positive number.
STR Converts numeric expression to character string.
STRTRAN Searches and replaces within a character string.
STUFF To manipulate characters within a character string.
SUBSTR Extracts a specified part of a character string.
TIME Returns the system time in the format "hh:mm.ss".
TONE Sounds speaker for specified tone and duration.
TRANSFORM Returns character string with specified picture format.
TRIM Removes trailing blanks from a character expression.
TYPE Returns data type of variable, expression or field.
UPDATED Returns true if last READ changed any data in GETS.
UPPER Converts lower case characters to upper case.
USED Determines if a database is in USE in current work area.
VAL Converts a character string to a number value.
WORD Converts numeric arguments from type DOUBLE to type INT.
YEAR Returns complete numeric value of the year from a date.
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson