Clipper Tools

Book 1

Window Functions
Extended Drivers
Serial Communication
String Manipulation


Number / Bit Manipulation
Video Functions
Disk Utilities
Printer Functions
Date / Time Functions
Database Functions


Set Status
System Informations
Miscellaneous Functions
Mathematical Functions
Peek / Poke Functions
Get / Read Functions

Tools — 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

Tools – PEEK/POKE Functions

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

Tools — Mathematical Functions

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

Tools – Miscellaneous Functions

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

Tools – System Information

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

Tools — Set Status

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()

Tools — Database Functions

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