| Função | Descrição |
|
|
| AADD() | Adiciona um novo elemento ao final de uma matriz ou vetor |
| ABS() | Retorna o valor absoluto de uma expressão numérica |
| ACHOICE() | Executa um menu do tipo pop-up |
| ACLONE() | Duplica uma matriz ou vetor multidimensional |
| ACOPY() | Copia elementos de uma matriz ou vetor para outra(o) |
| ADEL() | Deleta um elemento de uma matriz ou vetor |
| ADIR()* | Preenche uma matriz com as informações de um diretório |
| AEVAL() | Executa um bloco de código para cada elemento de uma matriz ou vetor |
| AFIELDS()* | Preenche uma matriz com a estrutura do arquivo de dados atual |
| AFILL() | Preenche uma matriz com um valor especificado |
| AINS() | Insere um elemento NIL em uma matriz ou vetor |
| ALERT() | Mostra uma caixa de diálogo modal simples |
| ALIAS() | Retorna o alias da área de trabalho especificada |
| ALLTRIM() | Remove os espaços do início e do fim de uma cadeia de caracteres |
| ALTD() | Invoca o CA-Clipper debugger |
| ARRAY() | Cria um vetor ou matriz não inicializado de um tamanho especificado |
| ASC() | Converte um character para seu valor ASCII |
| 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 |
| 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 |
| NETERR() | Determine if a network command has failed |
| NETNAME() | Return the current workstation identification |
| NEXTKEY() | Read the pending key in the keyboard buffer |
| NOSNOW() | Toggle snow suppression |
| ORDBAGEXT() | Return the default order bag RDD extension |
| ORDBAGNAME() | Return the order bag name of a specific order |
| ORDCOND() | Specify conditions for ordering |
| ORDCONDSET() | Set the condition and scope for an order |
| ORDCREATE() | Create an order in an order bag |
| ORDDESCEND() | Return and optionally change the descending flag of an order |
| ORDDESTROY() | Remove a specified order from an order bag |
| ORDFOR() | Return the FOR expression of an order |
| ORDISUNIQUE() | Return the status of the unique flag for a given order |
| ORDKEY() | Return the key expression of an order |
| ORDKEYADD() | Add a key to a custom built order |
| ORDKEYCOUNT() | Return the number of keys in an order |
| ORDKEYDEL() | Delete a key from a custom built order |
| ORDKEYGOTO() | Move to a record specified by its logical record number |
| ORDKEYNO() | Get the logical record number of the current record |
| ORDKEYVAL() | Get key value of the current record from controlling order |
| ORDLISTADD() | Add orders to the order list |
| ORDLISTCLEAR() | Clear the current order list |
| ORDLISTREBUI() | Rebuild all orders in the order list of the current work area |
| ORDNAME() | Return the name of an order in the order list |
| ORDNUMBER() | Return the position of an order in the current order list |
| ORDSCOPE() | Set or clear the boundaries for scoping key values |
| ORDSETFOCUS() | Set focus to an order in an order list |
| ORDSETRELAT() | Relate a specified work |
| ORDSKIPUNIQUE() | Move record pointer to the next or previous unique key |
| OS() | Return the operating system name |
| OUTERR() | Write a list of values to the standard error device |
| OUTSTD() | Write a list of values to the standard output device |
| PAD() | Pad character, date, and numeric values with a fill character |
| PCOL() | Return the current column position of the printhead |
| PCOUNT() | Determine the position of the last actual parameter passed |
| PROCLINE() | Return source line number of current or previous activation |
| PROCNAME() | Return name of the current or previous procedure or function |
| PROW() | Return the current row position of the printhead |
| QOUT() | Display a list of expressions to the console |
| RAT() | Return the position of the last occurrence of a substring |
| RDDLIST() | Return an array of the RDDs |
| RDDNAME() | Return name of RDD active in current or specified work area |
| RDDSETDEFAULT() | Set or return the default RDD for the application |
| READEXIT() | Toggle Up arrow and Down arrow as READ exit keys |
| READFORMAT() | Return and optionally set code block to implement format file |
| READINSERT() | Toggle the current insert mode for READ and MEMOEDIT() |
| READKEY()* | Determine what key terminated a READ |
| READKILL() | Return and optionally set whether current READ can be exited |
| READMODAL() | Activate a full-screen editing mode for a GetList |
| READUPDATED() | Determine whether any GET variables changed during a READ |
| READVAR() | Return the current GET/MENU variable name |
| RECCOUNT()* | Determine the number of records in the current database file |
| RECNO() | Return the identity at the position of the record pointer |
| RECSIZE() | Determine the record length of a database (.dbf) file |
| REPLICATE() | Return a string repeated a specified number of times |
| RESTSCREEN() | Display a saved screen region to a specified location |
| RIGHT() | Return a substring beginning with the rightmost character |
| RLOCK() | Lock the current record in the active work area |
| ROUND() | Return a numeric value rounded to a specified number of digit |
| ROW() | Return the screen row position of the cursor |
| RTRIM() | Remove trailing spaces from a character string |
| SAVESCREEN() | Save a screen region for later display |
| SCROLL() | Scroll a screen region up or down, right or left |
| SECONDS() | Return the number of seconds elapsed since midnight |
| SELECT() | Determine the work area number of a specified alias |
| SET() | Inspect or change a system setting |
| SETBLINK() | Toggle * interpretation between blinking/background intensity |
| SETCANCEL() | Toggle Alt+C and Ctrl+Break as program termination keys |
| SETCOLOR() | Return the current colors and optionally set new colors |
| SETCURSOR() | Set the cursor shape |
| SETKEY() | Assign an action block to a key |
| SETMODE() | Change display mode to a specified number of rows and columns |
| SETPOS() | Move the cursor to a new position |
| SETPRC() | Set PROW() and PCOL() values |
| SOUNDEX() | Convert a character string to "soundex" form |
| SPACE() | Return a string of spaces |
| SQRT() | Return the square root of a positive number |
| STR() | Convert a numeric expression to a character string |
| STRTRAN() | Search and replace characters within a string or memo field |
| STUFF() | Delete and insert characters in a string |
| SUBSTR() | Extract a substring from a character string |
| TIME() | Return the system time |
| TONE() | Sound a speaker tone for a specified frequency and duration |
| TRANSFORM() | Convert any value into a formatted character string |
| TRIM() | Remove trailing spaces from a character string |
| TYPE() | Determine the type of an expression |
| UPDATED() | Determine whether a GET changed during a READ |
| UPPER() | Convert lowercase characters to uppercase |
| USED() | Determine whether a database file is in USE |
| VAL() | Convert a character number to numeric type |
| VALTYPE() | Determine the data type returned by an expression |
| VERSION() | Returns CA-Clipper version |
| WORD()* | Convert CALL command numeric parameters from double to int |
| YEAR() | Convert a date value to the year as a numeric value |
