Book 1
Introduction
Window Functions
Extended Drivers
Serial Communication
String Manipulation
Book2
Number / Bit Manipulation
Video Functions
Disk Utilities
Printer Functions
Date / Time Functions
Database Functions
Book3
Set Status
System Informations
Miscellaneous Functions
Mathematical Functions
Peek / Poke Functions
Get / Read Functions
Introduction GET/READ Functions COUNTGETS() Determines the number of posted GET fields CURRENTGET() Determines the number of the currently active GET field GETFLDCOL() Determines the screen column of a GET field GETFLDROW() Determines the row of a GET field on the screen GETFLDVAR() Determines the name of a GET field GETINPUT() Keyboard input function similar to a GET field GETSECRET() Keyboard input function for hidden input similar to a GET field RESTGETS() Restores GET settings from an array RESTSETKEY() Restores SET KEY..TO settings from an array SAVEGETS() Saves the GET settings of the active environment SAVESETKEY() Saves SET KEY..TO settings in an array
Introduction PEEK/POKE Functions INBYTE() Reads an 8 byte from a port INWORD() Reads in a 16-bit word from a port OUTBYTE() Sends a byte to a port OUTWORD() Sends a 16-bit word to a port PEEKBYTE() Reads a byte from memory PEEKSTR() Reads a byte sequence from memory PEEKWORD() Reads a 16-bit word from memory POKEBYTE() Writes a byte to memory POKEWORD() Writes a 16-bit word to memory
Introduction Mathematical Functions ACOS() Computes the cosine arc ASIN() Computes the sine arc ATAN() Computes the tangent arc ATN2() Computes the angle size from the sine and cosine CEILING() Rounds up to the next integer COS() Computes the cosine COT() Computes the cotangent DTOR() Converts from a degree to radian measure FACT() Computes the factorial FLOOR() Rounds down to the next integer FV() Computes future value of capital GETPREC() Determines the level of precision that is set LOG10() Computes the common logarithm PAYMENT() Computes the periodic payment amount PERIODS() Computes number of payment periods necessary to repay a loan PI() Returns pi with the highest degree of accuracy PV() Computes the cash present value after interest charges RATE() Computes the interest rate for a loan RTOD() Converts from a radian to degree measure SETPREC() Sets the precision level for trigonometric functions SIGN() Determines the mathematical sign of a number SIN() Computes the sine of a radian value TAN() Computes the tangent of a radian value
Introduction Miscellaneous Functions ALLOFREE()* Determines the maximum memory size allocation BLANK() Creates a blank value for each data type COMPLEMENT() Forms the complement value of a data type DATATYPE()* Determines the data type of a variable or UDF GETTIC() Determines the number of timer ticks KBDDISABLE() Locks/unlocks the keyboard KBDEMULATE() Inserts characters into BIOS keyboard buffer to emulate input KBDSPEED() Sets keyboard auto repeat speed KBDSTAT() Tests for key shift state status, such as Ctrl and Shift KBDTYPE() Determines the type of keyboard in use KEYSEC() Triggers a key trap after a time delay KEYTIME() Triggers a key trap at a specific clock time MILLISEC() Time delay in milliseconds NUL() Converts the value returned by a function into a null string SCANKEY() Queries scan code of keyboard input SETTIC() Increases number of time ticks SHOWKEY() Continuously displays the INSERT and LOCK status SOUND() Creates tones (melodies) by designating frequency and duration SPEED() A comparison value used to determine the processor speed STACKFREE() Determines the remaining stack space TOOLVER() Queries the version number of the Clipper Tools in use XTOC() Converts an expression of any data type into a string
Introduction System Information BIOSDATE() Determines the system BIOS date BOOTCOLD() Triggers a cold boot BOOTWARM() Triggers a warm start of the system CPUTYPE() Determines what type of microprocessor in use DOSPARAM() Retrieves the DOS command line as a string ENVPARAM() Reads the entire DOS environment table into a string ERRORACT() Recommends action for a DOS error that has occurred previously ERRORBASE() Source of the most-recent DOS error ERRORCODE() Identifies a DOS error that has occurred previously ERRORORG() Origin of the most-recent DOS error EXENAME() Returns name and directory of the current Clipper program FILESFREE() Specifies the number of files you can open FILESMAX() Specifies maximum number of files that can be open at one time GETCOUNTRY() Queries country setting for the operating system ISANSI() Tests to see if the ANSI screen driver is installed ISAT() Determines if a program is running on an AT ISMATH() Determines if a math coprocessor is installed MEMSIZE() Determines size of conventional or extended memory NUMBUFFERS() Determines the BUFFERS= setting NUMFILES() Determines maximum number of files you can open simultaneously OSVER() Returns the DOS version number PCTYPE() Returns the type of computer in use SSETBREAK() Sets and checks the DOS BREAK switch SSETVERIFY() Sets and checks the DOS VERIFY switch
Introduction Set Status CSETALL() Saves all ON/OFF switch settings CSETCLIP() Determines the content of Clipper environmental variables CSETDATE()* Queries the SET DATE setting CSETDECI()* Queries the setting for SET DECIMALS TO CSETDEFA()* Queries the setting for SET DEFAULT CSETFUNC()* Queries the setting for SET FUNCTION TO CSETKEY()* Queries the setting for SET KEY TO CSETLDEL()* Queries the setting for the left delimiters CSETMARG()* Queries the setting for SET MARGIN TO CSETPATH()* Queries the setting for SET PATH TO CSETRDEL()* Queries the setting for the right delimiter CSETRDONLY()* Queries/sets the read-only mode switch CSETSAFETY() Queries/sets the safety mode switch CSETSNOW() Helps prevent snow on the screen CSETxxxx()* Queries SET position of an ON/OFF switch and optionally sets it ISDEBUG() Determines if the debugger is available in the application KSETCAPS() Queries/sets the system setting for CAPS LOCK KSETINS() Queries/sets the system setting for "INSERT" KSETNUM() Queries/sets the system setting for NUMLOCK KSETSCROLL() Queries/sets the system setting for SCROLL LOCK LASTKFUNC() Returns the function name that created the most-recent key trap LASTKLINE() Returns the line number of the most-recent key trap LASTKPROC() Returns the procedure name that was interrupted NUMFKEY() Determines the number of function keys SETLASTKEY() Sets the value for LASTKEY()
Introduction Database Functions DBFDSKSIZE() Determines the size of a selected (.dbf) file on a disk drive DBFSIZE() Determines the size of a selected (.dbf) file in memory FIELDDECI() Determines the number of decimal places in a field FIELDNUM() Determines field number for a specific field in a database file FIELDSIZE() Determines the size of a field FIELDTYPE() Determines the data type for a field ISDBT() Determines if a memo file (.dbt) is present
