═══ 1. Asynchronous Functions ═══ SETBAUDRATE sets baud rate GETBAUDRATE gets baud rate SETLINECTL control serial port GETLINECTL control serial port XMIT control serial port XMITIIM control serial port SETBRK control serial port MDMCTL control serial port SETDCB control serial port GETDCB control serial port GETCOMMERROR control serial port GETCOMMEVENT control serial port GETCOMMSTATUS control serial port GETLINESTATUS control serial port GETMDMINP control serial port GETMDMOUTP control serial port GETOUTQCNT control serial port ═══ 2. Clipper ═══ DBSTRUCT() Clipper functions for Clipper compatibility DBUNLOCK() Clipper functions for Clipper compatibility DBUNLOCKALL() Clipper functions for Clipper compatibility DBCLEARFILTER() Clipper functions for Clipper compatibility DBCLEARINDEX() Clipper functions for Clipper compatibility DBCLEARRELATION() Clipper functions for Clipper compatibility DBCLOSEALL() Clipper functions for Clipper compatibility DBCLOSEAREA() Clipper functions for Clipper compatibility DBCOMMIT() Clipper functions for Clipper compatibility DBCOMMITALL() Clipper functions for Clipper compatibility DBDELETE() Clipper functions for Clipper compatibility DBFILTER() Clipper functions for Clipper compatibility DBGOTOP() Clipper functions for Clipper compatibility DBGOBOTTOM() Clipper functions for Clipper compatibility DBRECALL() Clipper functions for Clipper compatibility DBREINDEX() Clipper functions for Clipper compatibility DBGOTO() Clipper functions for Clipper compatibility DBSETFILTER() Clipper functions for Clipper compatibility DBSETINDEX() Clipper functions for Clipper compatibility DBSETORDER() Clipper functions for Clipper compatibility DBSKIP() Clipper functions for Clipper compatibility DBSELECTAREA( ) Clipper functions for Clipper compatibility DBRELATION() Clipper functions for Clipper compatibility DBAPPEND() Clipper functions for Clipper compatibility DBSEEK() Clipper functions for Clipper compatibility DBCREATEINDEX() Clipper functions for Clipper compatibility DBSETRELATION() Clipper functions for Clipper compatibility DBUSEAREA() Clipper functions for Clipper compatibility BIN2I() Clipper functions for casting numbers as strings and visa versa. BIN2W() Clipper functions for casting numbers as strings and visa versa. BIN2L() Clipper functions for casting numbers as strings and visa versa. I2BIN() Clipper functions for casting numbers as strings and visa versa. L2BIN() Clipper functions for casting numbers as strings and visa versa. ═══ 3. Database and Field Related ═══ ACTIVATE BROWSE Activates the specified, or last accessed browse window ALIAS() alias for work area APPEND add records APPEND FROM ARRAY adds contents of an array to a database AVERAGE average numeric database field BOF() beginning-of-file BOXBROWSE() browse database in a box BROWSE browse database in full screen BROWSE() browse database in a box BRSACTIVATE() Activates specified window except selected record is returned BRSCOLUMN() Causes specified browse to position to specified column BRSKEYINJECT() Causes specified browse to react as if specified key were pressed BRSRECORD() Causes browse to position to specified record and refresh display BRSREFRESH() Causes specified browse to refresh its display CLOSE close specified types of files COPY FILE TO copy any type of file COPY STRUCTURE duplicate file structure COPY TO copy database COPY TO ARRAY reate array to hold the maximum number of fields for record COUNT tally record count CREATE create a new database DBEVAL() evaluates given codeblock for specified database DBF() current database name DELETE mark records/file for deletion DELETED() test for deleted record DELETE FILE deletes a file DELETE TAG deletes automatic indices DISPLAY display record number/field data EOF() end-of-file FCOUNT() count of fields in current database FIELDNAME() name of field # FIND position pointer to first record FOUND() return success of last seek FLOCK() lock current file GOTO positions to specified record HEADER() size of current dbf header INDEX ON create index expression INDEXKEY() current index expression INDEXORD() active index order INSERT Insert blank record into database immediately after current record LASTREC() last database record number LIST display contents of database LOCATE position to specified record LOCATE() Return LOCATE FOR expression for current or specified work area LOCK() lock current record LUPDATE() date database last updated MAP2TEXT() convert bitmap to text MKMAP() bitmap sets of key ranges NDX() name of active index file PACK remove records marked for delete RECALL reinstates records flagged for deletion RECCOUNT() number of records in .dbf file RECIMAGE() record as a character string RECNO() current record number RECSIZE() size (in bytes) of record REINDEX rebuild existing index files REPLACE change contents of fields REPORT FORM report from .FRMfile RLOCK() same as LOCK SCAN Process records in the current workarea SEEK search for key value SEEK() search for a key value and return success SELECT switch to/define work area SELECT() work area selected SKIP advance/back-up pointer SORT sort records/output to new table SUFFIX() Set or query default file suffixes SUM sum of numeric expression TAG syntax for referring to a specific index by its tag name TOTAL ON summarize groups of records UNLOCK remove record/file locks USE specifies database to be opened USED() test for an open database ZAP remove all records ═══ 4. Set Options - Database ═══ SET COMPRESS turn on/off key file compression SET DEFAULT TO specify alternative path SET DELETED hide records marked for deletion SET CACHE TO write cache of specified number of records for opened work area SET EXACT comparison of character strings SET EXCLUSIVE limit users of database SET FILTER filter database records SET INDEX TO activate index files SET INDEX MAP set record range using map file SET INDEX RANGE set locked record range for active index SET LINK port applications from another O/S SET MEMOWIDTH define text default line length SET ORDER TO determines controlling index SET PATH TO specify default directory SET RELATION link two databases by key SET SOFTSEEK set return when SEEK match not found SET UNIQUE indicies will never be allowed to contain duplicate key values p. ═══ 5. Input/Output ═══ @ display result on next line ?? display result on same line @...BOX draw a box @...PROMPT create sliding lightbar menus @...SAY display text or bitmaps at row,column @...GET accept data at row,column @...GET...SIZE input multi-line entry field @...GET * push buttons @...GET *3 three-way check box @...GET *C check box @...GET *R radio buttons @...GET CLIDER circular slider @...GET SLIDER horizontal slider @...GET SPINNER spinner @...GET & list box @...GET ~ combo box @...GET ^ drop down combo box @...GET ] notebook @...TO erase screen and/or draw boxes ACCEPT ... TO prompt for input string BOX() draw a rectangular to elliptical region CHRSAW() test for characters in keyboard buffer CLEARGETS() clear specified get field CLPCLOSE() close clipboard CLPGET() gets contents of the clipboard CLPOPEN() open clipboard CLPPUT() store data in the clipboard CLPQUERYFMT() checks for data of a specified format in the clipboard COL() cursor column EJECT send formfeed to printer GETBOX() get rectangular frame GETKEY() return keypress GETNUM() returns @...GET field number associated with a symbol GETWINDOW() save screen window INKEY() return key press (timeout enabled) INPUT enters expression into memory KEYBOARD stuff characters into keyboard LINE() Connect a series of points with lines, or plot a single point LISTADD() interactive add to list box LISTDEL() interactive delete to list box LISTQUERY() returns an array of strings associated with contents of a list or list box MENU TO activate menu MOVEBOX() same as GETBOX() except sizing is not supported MSGBOX() display PM message box NBADDPG() adds a notebook page NBEND() End the READ of the current notebook from within one of its pages NOTEBOOK() add notebook page ON CLOSE intercept closing of a window ON DROP invoke function when object dropped ON PAGE invoke page when notebook page selected ON SLIDE invoke function when SLIDER control changes value ON SPIN invoke function when SPINNER control changes value PICKFILE() pick file control PICKFONT() pick font control POINTER() change the pointer icon POSGET() positions a GET object POSOBJ() positions a GET object PRINTER() printer query PROW() printer line number PUTWINDOW() put window saved by GETWINDOW READ initiates entry to GETs READKEY() keystroke used to exit last read RESTORE SCREEN repaint screen RGBCOLOR() adjust screen colors ROW() cursor row SAVE SCREEN TO saves screen window to variable SCROLL() scroll screen window SETGET() enable/disable GET field SETOBJ() enable/disable GET field SETPRC() set prow() and pcol() values SETWIN() set window size SHOWGETS() re-display oustanding GETS SYSTEM(7000) set system colors SYSTEM(7001) set title bar text SYSTEM(7003) available fonts SYSTEM(8000) allocated memory SYSTEM(8001) allocated memory after collection SYSTEM(8002) internal stack depth SYSTEM(8003) active window handle SYSTEM(8004) is down SYSTEM(8005) is down SYSTEM(8006) is down SYSTEM(8007) LASTGET info SYSTEM(9000) single step lines TONE() play a note on the speaker TYPE display contents of file to screen WINTITLE() set title on OnCmd application window ═══ 6. Set Options - Input/Output ═══ . SET() Returns the value(s) associated with specified SET SET ALTERNATE TO creates output file SET BORDERS display delimiters SET BREAK keyboard break exceptions SET CLOSE window close control SET COLOR TO assign screen colors SET CONFIRM exiting input fields SET CONSOLE send/suspend output to screen SET DELIMITERS display delimiters SET DEVICE TO set output device SET DROP TO set pattern for accepting dropped objects SET FONT set default fonts SET FULLREAD exiting templates SET FUNCTION assign expression to function key SET GETS display cleared gets SET KEY TO specified key execution SET MARGIN TO determine left margin of printer SET MENU enable/disable mouse clicks on frame menu SET MESSAGE TO sets screen display row SET SAY TO direct output to other than the active window SET SCOREBOARD activate title bar at bottom of screen ═══ 7. Low Level File Operations ═══ DISKSPACE() free space on disk ERASE remove file from system FCHSIZE() grow or shrink a file FCLOSE() close flat file FCOMPRESS() compress file FCREATE() make new flat file FCRYPT() encrypt file FDECOMPRESS() decompress file FDECRYPT() decrypt file FEOF() test end of file FERROR() File Error Status FILE() test file existence FOPEN() open flat file FREAD() read flat file (into memvar) FREADSTR() read flat file FSEEK() position file pointer FWRITE() write to flat file RENAME assign new name to file ═══ 8. Multi-Media ═══ MCI() media control interface PLAY() play a sound or video file RECORD() create a wave file ═══ 9. Network ═══ NODE() returns local machine name USER() returns local user name DOMAIN() returns domain name GROUP() returns lan group name ═══ 10. Pen ═══ @...GET ? OS/2 pen handwriting recognition @...KEYBOARD OS/2 Virtual keyboard SKETCH() capture pen and mouse sketches ═══ 11. Programming - General ═══ #DEFINE define constants for compiler substitution #INCLUDE include for compiler _ARG array to access command line arguments & macros (run-time expressions/functions) AEVAL() evaluates given codeblock for specified elements of the array AND() boolean AND function for testing bits BLOCK a codeblock which may be passed to EVAL(), AEVAL, or DBEVAL() built-in functions CANCEL return to the operating system CLEAR clear the CRT screen CLEAR ALL close all files, indexes, relations CLEAR GETS deactivate input fields CLEAR MEMORY clear memory variables CLEAR MENU end popup or PROMPT menu CLEAR READ end READ CLEARTMR() remove specified timer(s) CLEAR TYPEAHEAD empty keyboard input buffer CONTINUE skip to next record CURDIR() current directory path DEVCTL() device control function DLL() call 'C' functions DLLMOD() call a DLL function DO execute a program DO CASE execute one of several paths DO WHILE allows a structured loop EMPTY() test for empty or 'nil' expression END same as ENDDO, ENDIF, ENDSCAN, ENDCASE ENDFOR specify start of FOR/NEXT ENDREAD same as CLEAR READ ERROR() runtime error number EVAL() evaluating codeblocks EXIT escape loops FOR specify start of FOR/NEXT FULLPATH() Returns full path for filename, or directory if no filename specified FUNCTION declare start of function GATHER store data into array or variable GETENV() get environment variable IF conditional execution of program commands IIF() shortcut for IF ISALPHA() test for letter ISCOLOR() test for color monitor ISCONSOLE() test for console (else terminal) ISDIGIT() test for '0' - '9' ISLOWER() test for lower case ISPRINTER() test existence of printer ISUPPER() test for upper case KEYPRINT() index representation of numerics LASTFIELD() number of last input field LASTKEY() keystroke used to exit a read LOCAL variable scopes similarly to 'C' automatic (stack) variables LOOP jump to end of FOR or DO loop MEMVAR keyword to tell the compiler which symbols are memory variables MESSAGE() last runtime error message NOTE/*/&& insert non-executing comments OD interactive source level debugger ON BREAK invoke function on ON CLICK trap mouse clicks ON ERROR invoke function on error ON ESCAPE invoke function on ON FOCUS trap screen activation and deactivation OR() boolean OR function for testing bits OS() operating system OTYPE() data type PARAMETERS declare parameters PCOL() printer column position PRIORITY() change priority of OnCmd application PRIVATE protect memory variables PROCEDURE define start of procedure PROCLINE() procedure line PROCNAME() procedure name PUBLIC make procedure or memory variable known PUTENV() modify environment variables QUIT close all files and exit RELEASE clear memory variables RESTORE FROM retrieve saved memory variables RETURN ends a program RUN (or !) execute other programs SAVE TO save memory variables SCATTER copy data to array or variable SETMENU() set attributes for selected frame menu items STATIC scope of current function that only module which declared can access STORE assign expression values SYSTEM(8008) query process id of most recently RUN command SYSTEM(8009) kill process that was RUN with /W flag SYSTEM(8500) OnCmd licence number SYSTEM(8501) product owner company SYSTEM(8502) product owner name SYSTEM(8600) no interrupts allowed SYSTEM(8601) interrupts allowed SYSTEM(8602) no nesting of interrupts allowed SYSTEM(8603) nesting of interrupts allowed TMPNAM() Returns a unique filename each invocation TRANSFORM() convert C or N or BITMAP using PICTURE TYPE() data type of this object VERSION() OnCmd version number WAIT supend program till keypress WAITEVENT() mainline blocking mechanism WHILE allows a structured loop ═══ 12. Set Options - Programming ═══ SET CENTURY display dates with century included SET CODEPAGE TO set code page to new value SET DATE define date formats SET DEBUG Enables and disables the "Debug" option on the System menu SET DECIMALS TO assign number of decimals SET FIXED decimal accuracy SET PRINT send/suspend output to printer SET PRINT TO set printed output destination SET PRINTER TO support for graphics printing SET PROCEDURE TO opens procedure file SET SCOREBOARD display bottom status line SET WRAP wrap or exit from lightbar menus ═══ 13. Programming - Inter Process Communication ═══ DDECLIENT() become OnCmd DDE client DDEPOST() post message to DDE partner DDESERVER() become OnCmd DDE server NAME_ATTACH() associate a name with a task NAMEATTACH() associate a name with a task NAME_DETACH() disconnect a name from a task NAMEDETACH() disconnect a name from a task NAME_LOCATE() locate a task based on a name NAMELOCATE() locate a task based on a name RECEIVE() accept a message from another task REPLY() send a reply message to a task RESOURCE() allow OnCmd application programs containing OS/2 resources to access those resources SEND() send a message to another task TMR() time activated subroutines VFORMAT() format binary data VSCAN() scan binary data into variables XEVENT() external event handling ═══ 14. Rexx ═══ REXXMOD() instead of DLLMOD() for Rexx REXX() instead of DLL() for Rexx RXINTERPRET() Rexx script contained in a C type variable RXTOKENIZE() Returns pre-interpreted Rexx code ═══ 15. SOM ═══ SOM() longer calls SOM method function. SOMMOD() This object should be freed using SOMFREE() once it is no needed SOMSTOI() Convert a character string to a somId for use in SOM calls. SOMCLASS() Create a SOM class for use in SOM calls. SOMUNREGC() Free all resources associated with a SOM class SOMNEW() Create a new instance of a som class object for use with SOM() calls. SOMFREE() Free object once it is no longer needed ═══ 16. TCP/IP ═══ TCPACCEPT() accepts a connection request from a remote host TCPBIND() assigns a local address to the socket TCPCONNECT() requests a connection to a remote host TCPENDENT() closes the HOSTS, NETWORKS, PROTOCOL, or SERVICES file TCPGETENT() returns information from the HOSTS, NETWORKS, PROTOCOL, or SERVCES file TCPGETHOSTBYADDR() returns information about a host specified by an internet address TCPGETHOSTBYNAME() returns information about a host specified by a host name TCPGETHOSTID() returns the unique identifier of the current host TCPGETHOSTNAME() returns the standard host name for the local host machine TCPGETNETBYADDR() returns the NETWORKS file entry that contains the specified address TCPGETNETBYNAME() returns the NETWORKS file entry that contains the specified name TCPGETPEERNAME() returns the address and port of the peer connected to a socket TCPGETPROTOBYNAME() returns a protocol entry specified by name TCPGETPROTOBYNUMBER() returns a protocol entry specified by number TCPGETSERVBYNAME() returns a service entry specified by name TCPGETSERVBYPORT() returns a service entry specified by port number TCPGETSOCKNAME() gets the local address and port of a socket TCPGETSOCKOPT() gets socket options associated with a socket TCPHTON() translates byte order from host to network for a short or long integer TCPINETADDR() constructs an internet host or network address from character strings representing numbers expressed in standard dotted-decimal notation TCPINETMAKEADDR() constructs an internet address from a network number and a local address TCPINETNET() returns the network (or local network) number portion of the internet host address TCPINETNTOA() returns a pointer to a string in dotted-decimal notation TCPIOCTL() performs special operations on a socket TCPLISTEN() completes the binding necessary for a socket and creates a connection request queue for incoming requests TCPNTOH() translates byte order from network to host for a short or long integer TCPREADV() reads data on a socket and stores it in a set of specified buffers TCPRECV() receives messages on a connected socket TCPRECVFROM() receives messages on a datagram socket, regardless of its connection status TCPRECVMSG() receives messages on a socket and stores them in a msghd structure TCPRESINIT() reads TCPIP\ETC\RESOLV file for default domain name TCPREXEC() executes a command on a remote machine TCPSELECT() monitors read, write, and exception status on a group of sockets TCPSEND() sends packets on a connected socket TCPSENDMSG() sends a msghdr structureon a specified socket TCPSENDTO() sends packets on a datagram socket, regardless of its connection status TCPSETENT() opens and rewinds the HOSTS, NETWORKS, PROTOCOL, or SERVICES file TCPSETSOCKOPT() sets options associated with a socket TCPSHUTDOWN() shuts down all or part of a duplex connection TCPSOCKERRNO() returns the error code set by a socket call TCPSOCKINIT() initializes the socket data structures and checks whether INET.SYS is running TCPSOCKET() creates an endpoint for communication and returns a socket descriptor representing the endpoint TCPSOCLOSE() shuts down a socket and frees resources allocated to that socket TCPSWAP() swaps bytes in a short integer or a long integer TCPWRITEV() writes data on a socket with descriptor s ═══ 17. Text Manipulation ═══ COMPRESS() compress data string CRYPT() encrypt character string DECOMPRESS() decompress data string DECRYPT() decrypt character string EDITTEXT() editor in a box EVAL() embedded expression substitution MEMOLINE() extract lines of text MEMOREAD() read text file into string MEMOWRIT() write text file MLCOUNT() count lines of text OCCURS() count occurances of string in text RATCLINE() case insensitive text search from bottom RATLINE() text search from bottom SOUNDEX() convert text string to soundex value TEXT display/substitute text (form letters) ═══ 18. Variables - Arrays ═══ ACHOICE() select a string from an array ACLONE() Create an exact copy of an array and all its sub-arrays ACOPY() copy array elements ADEL() remove an element from an array ADIR() return directory information AFIELDS() load an array with db field info AFILL() initialize an array AINS() add an element into an array ASCAN() search arrays ASORT() sort an array ATAIL() Returns the highest element of an array DECLARE define array memory variable MKARRAY() declare and initialize an array STRBK() break a string into an array STRMK() build a string from an array ═══ 19. Variables - Character ═══ ALLTRIM() remove leading/trailing blanks ASC() character to ASCII code AT() position of Nth occurance of substring ATC() case insensitive AT() ATLINE() line search in text ATCLINE() case insensitive ATLINE() BETWEEN() range test CHR() ASCII code to character CHRTRAN() character translations INLIST() compare with list LEFT() extract left portion of string LEN() length of string LIKE() file pattern comparison LOWER() convert to lower case LTRIM() strip leading spaces MEMOLINE() return specified text line MLCOUNT() count lines of text PADC() pad with centering PADL() pad from left (right justify) PADR() pad on right (left justify) P1OPER() format proper name RAT() string search from left RATC() case insensitive RAT() REPLICATE() repeat character(s) n times RIGHT() extract right characters of string RTRIM() strip trailing spaces STRTRAN() string translations SPACES() create blank character string STRCAT() add strings together STUFF() replace characters in a string SUBSTR() substring TRIM() strip trailing spaces UPPER() convert to upper case VAL() character to numeric ═══ 20. Variables - Numeric ═══ ABS() absolute value CBRT() cube root CEIL() nearest higher integer CFORMAT() Identical to 'C' SPRINTF() function EXP() exponential e to the n EXP2() exponential 2 to the n EXP10() exponential 10 to the n FLOAT() convert any numeric to float class FLOOR() nearest lower integer INT() integer conversion (truncate decimals) LOG() natural logarithm LOG2() base 2 logarithm LOG10() base 10 logarithm MAX() greatest of list of values MIN() lowest of list of values MOD() modulus (remainder) RAND() random numbers ROUND() round a value SQRT() square root STR() numeric to character string TRIGONOMETRY determine trigonometric values ═══ 21. Variables - Time & Date ═══ CDOW() character day of week CMONTH() character month CTOD() character to date CTOT() character to time DATE() system date DAY() day of month DOW() day of week DTOC() date to character DTOS() date to literal string GOMONTH() add or subtract months from date MONTH() month of the year SECONDS seconds since midnight TIME() system time TTOC() seconds since midnight into char. string YEAR() from date ═══ 22. Voice Recognition ═══ VCEERRMSG() voice recognition error message VCEGETCXT() load voice recognition context file VCEINIT() voice recoginition initialization VCELISTEN() initiate voice recognition listen state VCEREMCTX() remove voice recognition context file VCETERM() terminate voice recognition conversation VCEWORDS() return voice recognition words ═══ 23. Windowing ═══ ACTIVATE WINDOW to display and activate a window CLOSEWIN() remove (destroy) a window DEFINE WINDOW define and create windows ON SIZE Calls the specified User-Defined-Function when window is resized OPENWIN() create new window RELEASEWIN() deactivate window RELEASE WINDOW deactivate window SELECTWIN() activate window SETWIN() change window size and position SHOWWIN() display window