Category : Dbase (Clipper, FoxBase, etc) Languages Source Code
Archive   : LINGO.ZIP
Filename : LINGO.DBF

 
Output of file : LINGO.DBF contained in archive : LINGO.ZIP

Wס`CMDCä{DESCCä{<TYPECRä{
SOURCEC\ä{
ADEL() SHIFT ARRAY ELEMENTS DOWN. DBU.LIB ARRAYS CLIP ADIR() FILL AN ARRAY WITH DISK DIR FILENAMES. DBU.LIB ARRAYS CLIP AFILL() FILL ARRAY ELEMENTS WITH ONE VALUE. DBU.LIB ARRAYS CLIP AINS() SHIFT ARRAY ELEMENTS UP. USE DBU.LIB ARRAYS CLIP ARRREST() RESTORE CLIPPER ARRAY FROM DISK FILE ARRAYS RETTIG ARRSAVE() SAVE CLIPPER ARRAY TO DISK FILE ARRAYS RETTIG ARRSORT() CALL C ROUTINES TO SORT AN ARRAY BY DATA ARRAYS RETTIG ASCAN() SEARCH FOR SPECIFIC VALUE WITHIN AN ARRAY. DBU.LIB ARRAYS CLIP ATYPE() DATA TYPE OF A C,IPPER ARRAY ELEMENT ARRAYS RETTIG CREACHAR ALLOCATE MEMORY FOR C CHARACTER ARRAY ARRAYS RETTIG DECLARE CREATES A ONE-DIMENTIONAL ARRAY. ELEMENTS CAN BE MIXED ARRAYS CLIP FREECHAR RELEASE MEMORY ALLOCATED WITH CREACHAR ARRAYS RETTIG PASSARR PASS NUMERIC/DATE/LOGICAL ARRAY FROM CLIPPER TO C ARRAYS RETTIG PASSCHAR PASS CHARACTER ARRAY FROM CLIPPER TO C ARRAYS RETTIG READARRC READ CHARACTER ARRAY FROM DISK FILE ARRAYS RETTIG READARRN READ NUMERIC/DATE/LOGICAL ARRAY FROM DISK FILE ARRAYS RETTIG RETARR PASS NUMERIC/DATE/LOGICAL ARRAY FROM C TO CLIPPER ARRAYS RETTIG RETCHAR PASS CHARACTER ARRAY FROM C TO CLIPPER ARRAYS RETTIG SORTARRN SORT NUMERIC/DATE/LOGICAL ARRAY BY DATA ARRAYS RETTIG WRITARRC WRITE CHARACTER ARRAY TO DISK FILE ARRAYS RETTIG WRITARRN WRITE NUMERIC/DATE/LOGICAL ARRAY TO DISK FILE ARRAYS RETTIG DEPDB() DEPRECIATION BY DECLINING-BALANCE METHOD BUSINESS RETTIG DEPSL() DEPRICIATION BY STRAIGHT-LINE METHOD BUSINESS RETTIG DEPVALDB() DEPRECIATED VALUE BY DECLINING-BALANCE METHOD BUSINESS RETTIG DEPVALSL() DEPRECIATED VALUE BY STRAIGHT-LINE METHOD BUSINESS RETTIG EFFYIELD() EFFECTIVE YIELD (EFFETIVE RATE OF INTEREST) BUSINESS RETTIG EOQ() ECONOMIC ORDER QUANTITY (OF INVENTORY ITEM) BUSINESS RETTIG INCTIME() TIME TO INCREASE INVESTMENT BY SPECIFIED AMOUNT BUSINESS RETTIG TOMONEY() "...DOLLARS AND ...CENTS" WORD FROM (EXPN) BUSINESS RETTIG ALLTRIM() REMOVE ALL LEADING AND TRAILING BLANK SPACES CHARACTER RETTIG ASC() CHARACTER TO ASCII CODE CHARACTER PLUS AT() SUBSTRING SEARCH CHARACTER PLUS ATLAST() POSITION OF LAST OCCURRENCE OF SPECIFIED CHARACTER CHARACTER RETTIG ATNEXT() POSITION OF (N) OCCURRENCE OF SPECIFIED CHARACTER CHARACTER RETTIG CAPFIRST() UPPERCASE FIRST LETTER OF WORDS. LOWERCASE REST CHARACTER RETTIG CENTER() PRECEDE WITH SPACES TO CENTER IN (N) WIDTH CHARACTER RETTIG CHR() ASCII CODE TO CHARACTER CHARACTER PLUS CHRCOUNT() NUMBER OF TIMES CHARACTER APPEARS IN STRING CHARACTER RETTIG CHRFOUND() ARE ALL STRING-1 CHARS ALSO IN STRING-2 IN ANY ORDER? CHARACTER RETTIG CHRSWAP() REPLACE ALL OCCURRENCES OF SPECIFIED CHARACTER CHARACTER RETTIG CTOD() CHARACTER TO DATE CONVERSION CHARACTER PLUS DECRYPT() RESTORE STRINGS PROTECTED WITH ENCRYPT() CHARACTER RETTIG DTOC() DATE TO CHARACTER CONVERSION CHARACTER PLUS ENCRYPT() PREVENT READING DATA WITHOUT PASSWORD CHARACTER RETTIG EXPAND() INSERT (N) SPACES BETWEEN EACH CHARACTER CHARACTER RETTIG ISALPHA() EVALUATE FOR LETTER CHARACTER PLUS ISLOWER() EVALUATE FOR LOWER CASE CHARACTER PLUS ISUPPER() EVALUATE FOR UPPER CASE CHARACTER PLUS LEADCHAR() REPLACE LEADING BLANKS WITH SPECIFIED CHARACTER CHARACTER RETTIG LEFT() SUBSTRING SELECTION FROM LEFT SIDE CHARACTER PLUS LEN() LENGTH OF CHARACTER STRING CHARACTER PLUS LJUST() LEFT JUSTIFY STRING; MOVE LEADING BLANKS TO END CHARACTER RETTIG LOWER() FORCES LOWER CASE CHARACTER PLUS LTRIM() REMOVE LEADING BLANKS CHARACTER PLUS PEEKCHAR() READ CHARACTER FROM MEMORY ADDRESS CHARACTER RETTIG PEEKSTR() READ STRING FROM MEMORY ADDRESS CHARACTER RETTIG POKECHAR() WRITE CHARACTER TO MEMORY ADDRESS CHARACTER RETTIG POKESTR() WRITE STRING TO MEMORY ADDRESS CHARACTER RETTIG REPLICATE() REPEAT CHARACTER EXPRESSION CHARACTER PLUS RIGHT() SUBSTRING SELECTION FROM RIGHT SIDE CHARACTER PLUS RJUST() RIGHT JUSTIFY STRING: MOVE TRAILING BLANKS TO FRONT CHARACTER RETTIG RTRIM() REMOVE TRAILING BLANKS CHARACTER PLUS SPACE() GENERATES BLANK SPACES CHARACTER PLUS STUFF() REPLACE PORTION OF STRING CHARACTER PLUS SUBSTR() SUBSTRING SELECTION CHARACTER PLUS TRIM() REMOVE TRAILING BLANKS CHARACTER PLUS UPPER() FORCES UPPER CASE CHARACTER PLUS VAL() CHARACTER TO NUMERIC CHARACTER PLUS WRAP() POSITION OF LAST SPACE LESS THAN (N) WIDTH CHARACTER RETTIG ALIAS() RETURNS ALIAS OF A SELECT AREA DATABASE CLIP APPEND ADDS DATA AT THE END OF A DATABASE FILE DATABASE PLUS APPEND BLANK NETWORKING SAFETY FEATURES DATABASE CLIP APPEND FROM ADDS RECORDS FROM OTHER FILES DATABASE PLUS APPEND FROM USPPORTS FIELD LIST AS OPTIONAL ARGUMENT DATABASE CLIP BOF() BEGINNING-OF-FILE DATABASE PLUS BROWSE ADDS DATA AT THE END OF A DATABASE FILE DATABASE PLUS BROWSE DISPLAYS UP TO 17 RECORDS PER SCREEN DATABASE PLUS CHANGE EDITS SPECIFIED FIELDS AND RECORDS IN A DATABASE DATABASE PLUS CLOSE CLOSES A SPECIFIED TYPE OF FILE DATABASE PLUS CONTINUE POSITIONS TO THE NEXT RECORD MEETING LOCATE CONDITIONS DATABASE PLUS COPY COPIES DATABASE IN USE TO A NEW DATABASE DATABASE PLUS COPY FILE DUPLICATES ANY KIND OF FILE DATABASE PLUS COUNT COUNTS AND DISPLAYS THE NUMBER OF RECORDS SPECIFIED DATABASE PLUS CREATE CREATES A NEW DATABASE FILE DATABASE PLUS CREATE CREATES AN EMPTY STRU EXTENDED FILE [ALSO STAND-ALONE UTIL] DATABASE CLIP CREATE QUERY CREATES A QUERY FILE DATABASE PLUS CREATE VIEW CREATES A VIEW FILE DATABASE PLUS DBEDIT() FULL SCREEN EDITING OF ONE OR MORE DATAFILES DATABASE CLIP DBF() NAME OF DATABASE FILE IN USE DATABASE PLUS DELETE MARKS RECORDS FOR DELETION DATABASE PLUS DELETED() DELETED RECORD DATABASE PLUS DISPLAY DISPLAYS RECORDS AND FIELDS DATABASE PLUS DISPLAY DISPLAYS RECORDS AND FIELDS DATABASE PLUS DISPLAY FIELD LIST REQUIRED. TO PRINT AND TO FILE CAPABILITIES DATABASE CLIP DISPLAY STRUCTURE DISPLAYS STRUCTURE OF A DATABASE FILE IN USE DATABASE PLUS EDIT ALTERS DATA FIELDS IN A DATABASE DATABASE PLUS EOF() END-OF-FILE DATABASE PLUS ERASE DELETES FILES FROM THE DIRECTORY DATABASE PLUS EXPORT CREATES A PFS FILE FROM A DATABASE DATABASE PLUS FCOUNT() NO. OF FIELDS IN CURRENT DBF DATABASE CLIP FIELD() NAMES OF FIELDS IN DATABASE FILES DATABASE PLUS FIELDNAME() RETURN NAME OF DATABASE FIELD FROM FIELD DATABASE CLIP FIND POSITIONS TO THE RECORD WITH AN INDEX KEY DATABASE PLUS FLDCOUNT() NUMBER OF FIELDS IN FILE STRUCTURE DATABASE RETTIG FOUND() RESULT OF DATABASE FILE SEARCH DATABASE PLUS GETAREA() FUNCTION RESULT FROM UNSELECTED WORK AREA DATABASE RETTIG GO POSITIONS DIRECTLY TO A SPECIFIC RECORD DATABASE PLUS HEADER() NUMBER OF BYTES IN FILE HEADER DATABASE RETTIG IMPORT CREATES DATABASE AND FORMAT FILES FROM PFS FILES DATABASE PLUS INDEX CREATES AN INDEX FILE DATABASE PLUS INDEX CAUTION WITH USE OF TRIM() [ALSO STAND ALONE UTIL] DATABASE CLIP INDEXKEY() KEY EXPRESSION OF INDEX DATABASE CLIP INSERT INSERTS DATA INTO A DATABASE FILE DATABASE PLUS JOIN COMBINES SPECIFIED RECORDS AND FIELDS FROM TWO DATABASES DATABASE PLUS LABEL FORM WILL IGNORE ANYTHING FOLLOWING A COMMA (UNLIKE PLUS) DATABASE CLIP LASTREC() RETURNS NUMBER OF RECORDS IN DATABASE DATABASE CLIP LIST LISTS RECORDS AND FIELDS DATABASE PLUS LIST FIELD LIST REQUIRED. TO PRINT AND TO FILE SUPPORTED DATABASE CLIP LOCATE POSITIONS TO A RECORD THAT MEETS A CONDITION DATABASE PLUS LUPDATE() LAST UPDATE OF DATABASE FILE DATABASE PLUS MODIFY QUERY MODIFIES A QUERY FILE DATABASE PLUS MODIFY STRUCTURE CREATES A BACKUP OF A DATABASE FILE OR MEMO FILE DATABASE PLUS MODIFY STRUCTURE ALTERS THE DATABASE STRUCTURE DATABASE PLUS MODIFY VIEW MODIFIES A VIEW FILE DATABASE PLUS NDX() NAMES OF OPEN INDEX FILES DATABASE PLUS NDXSIZE() POTENTIAL MAXIMUM SIZE OF PLUS INDEX FILE DATABASE RETTIG NEXTAREA() LOWEST AVAILABLE WORK AREA: USE WITH SELECT DATABASE RETTIG NTXSIZE() POTENTIAL MAXIMUM SIZE OF CLIPPER INDEX FILE DATABASE RETTIG PACK REMOVES RECORDS MARKED FOR DELETION DATABASE PLUS RECALL UNDELETES RECORDS DATABASE PLUS RECNO() CURRENT RECORD NUMBER DATABASE PLUS RECOUNT() NO. OF RECORDS IN DATABASE DATABASE PLUS RECSIZE() SIZE OF RECORD DATABASE PLUS REINDEX REBUILDS EXISTING INDEX FILES DATABASE PLUS RENAME RENAMES A FILE DATABASE PLUS REPLACE REPLACES DATA FIELDS WITH SPECIFIED VALUES DATABASE PLUS REPLACE SUPPORTS REPLACES IN ANOTHER AREA IS ALIAS IS USED DATABASE CLIP SEEK POSITIONS TO A RECORD WITH AN INDEX KEY DATABASE PLUS SELECT SWITCHES AMONG UP TO 10 USE FILES DATABASE PLUS SELECT SELECT 0 WILL SELECT FIRST UNUSED AREA DATABASE CLIP SET CATALOG TO CREATES A NEW CATALOG DATABASE PLUS SET INDEX INDEX FILES MAY BE SPECIFIED BY USING MACROS DATABASE CLIP SET ORDER ORDER OF INDEXES BEING USED DATABASE CLIP SET UNIQUE on/OFF Causes first/ALL record(s) with identical keys to be indexedDATABASE PLUS SKIP POSITIONS FORWARD OR BACKWARD DATABASE PLUS SKIP SUPPORTS "SKIP 0" AND ALIAS (TO MOVE POINTER IN UNSELD AREA)DATABASE CLIP SORT CREATES A SORTED VERSION OF THE ACTIVE DATABASE FILE DATABASE PLUS SORT CREATES A COPY OF A DATABASE FILE TO BE USED DATABASE PLUS SOUNDEX() INDEX ON SOUNDEX CODE FROM NAME DATABASE RETTIG STREET() INDEX ON STREET NAME FROM ADDRESS FIELD DATABASE RETTIG TOTAL CREATES A TOTAL$ SUMMARY OF PRESORTED FILES DATABASE PLUS UPDATE ALLOWS BATCH UPDATES OF A DATABASE DATABASE PLUS USE Specifies database to be used until another USE DATABASE PLUS ZAP REMOVES ALL RECORDS FROM ACTIVE DATABASE FILE DATABASE PLUS BOQTR() BEGINNING-OF-QUARTER: FIRST DAY OF YEAR'S QUARTER DATE RETTIG BOW() BEGINNING-OF-WEEK: DATE OF PREVIOUS MONDAY DATE RETTIG CDOW() DAY OF WEEK DATE PLUS CDTOS() CONVERT ANY FORMAT CHARACTER DATE TO DATE STRING DATE RETTIG CMONTH() CALENDAR MONTH DATE PLUS CMONTHN() CHARACTER MONTH FROM NUMERIC MONTH DATE RETTIG CTOD() CHARACTER TO DATE CONVERSION DATE PLUS DAY() DAY OF MONTH DATE PLUS DOW() NUMBER OF DAY OF THE WEEK DATE PLUS DTOC() DATE TO CHARACTER CONVERSION DATE PLUS DTOS() STRING IN YYYYMMDD FORMAT DATE CLIP EOQTR() END-OF-QUARTER: LAST DAY OF YEAR'S QUARTER DATE RETTIG EOW() END-OF-WEEK: DATE OF NEXT SUNDAY DATE RETTIG INMONTHS() NUMER OF MONTHS BETWEEN TWO DATES DATE RETTIG INWEEKS() NUMBER OF WEEKS BETWEEN TWO DATES DATE RETTIG INWKDAYS() NUMBER OF NON-WEEKEND DAYS BETWEEN TWO DATES DATE RETTIG ISDSDATE() IS DATE STRING A VALID DATE? DATE RETTIG ISLEAP() IS DATE OR YEAR A LEAP YEAR? DATE RETTIG ISWKEND() IS DATE ON A SATURDAY OR SUNDAY? DATE RETTIG LASTDAY() LAST DAY OF THE MONTH DATE RETTIG MAKEDATE() ADD/SUBTRACT MONTHS: MAKE INVALID DATES VALID DATE RETTIG MONTH() MONTH OF YEAR DATE PLUS NTOD() NUMERIC YEAR, MONTH, DAY TO DATE TYPE DATE RETTIG QUARTER() QUARTER OF YEAR OF SPECIFIED DATE DATE RETTIG STOD() CONVERT DATE STRING TO DATE TYPE DATE RETTIG WEEKDAYS() ADD/SUBTRACT NON-WEEKEND DAYS TO/FROM DATES DATE RETTIG YEAR() YEAR DATE PLUS DISPLAY HISTORY Displays the commands stored in HISTORY DEBUG PLUS INT3 BREAKPOINTS TO DEBUG ASM/C CODE AT RUN-TIME DEBUG RETTIG LIST HISTORY Lists the commands stored in HISTORY DEBUG PLUS MEMDUMP HEX DUMP (LIKE DEBUG) OF MEMVAR STORAGE DEBUG RETTIG RESUME Causes a SUSPENDed program to resume execution DEBUG PLUS SET DEBUG Sends display of ECHO to the printer DEBUG PLUS SET DOHISTORY on/OFCommand files are recorded/are NOT recorded in HISTORY DEBUG PLUS SET ECHO Displays command lines before executing them DEBUG PLUS SET HISTORY TO Specifies the number of executed commands stored in HISTORY DEBUG PLUS CURDIR() CURRENT DEFAULT DIRECTORY DISK RETTIG CURDRIVE() CURRENT DEFAULT DRIVE DISK RETTIG DIRMAKE() CREATE DIRECTORY UNLESS IT ALREADY EXISTS DISK RETTIG DISKSPACE() FREE SPACE (BYTES) ON DISK DISK PLUS FILE() FILE EXISTENCE DISK PLUS ISDRIVE() IS DISK DRIVE VALUD AND FULLY OPERATIONAL? DISK RETTIG ISFIXED() IS DISK DRIVE A FIZED OR "HARD" DISK? DISK RETTIG DISPLAY STATUS DISPLAYS CURRENT INFORMATION ABOUT THE FILES IN USE ENVIRON PLUS SELECT() NUMERIC VALUE OF CURRENTLY SELECTED AREA ENVIRON CLIP SET MENU SYSTEM TO SET CONTROL PARAMETERS ENVIRON PLUS SET ALTERNATE TO Creates a file for saving output ENVIRON PLUS SET ALTERNATE on/OFSends/DOES NOT SEND output to a file ENVIRON PLUS SET BELL ON/off Bell RINGS/does not ring during data entry ENVIRON PLUS SET CARRY on/OFF Writes/DOES NOT WRITE last record into an APPEND ENVIRON PLUS SET CATALOG ON/off ADDS/does not add files to the open catalog ENVIRON PLUS SET CATALOG TO Creates, opens, and closes a catalog ENVIRON PLUS SET CENTURY on/OFF Shows/DOES NOT SHOW the century in date displays ENVIRON PLUS SET COLOR ON/OFF Sets output to color or monochrome monitor ENVIRON PLUS SET COLOR TO Sets screen displays attributes ENVIRON PLUS SET CONFIRM on/OFF Requires/DOES NOT REQUIRE carriage return ENVIRON PLUS SET CONSOLE ON/off SENDS/suspends all output to the screen ENVIRON PLUS SET DATE Determines the format for date expressions ENVIRON PLUS SET DEBUG on/OFF Sends/DOES NOT SEND output of ECHO to the printer ENVIRON PLUS SET DECIMALS TO Determines the number of decimals displayed ENVIRON PLUS SET DEFAULT TO Specifies the default drive for file search ENVIRON PLUS SET DELETED on/OFF Does not display/DISPLAYS records marked for deletion ENVIRON PLUS SET DELIMITERS TO Specifies delimiters for fields and variable displays ENVIRON PLUS SET DELIMITERS on/FUses/DOES NOT USE specified entry delimiters ENVIRON PLUS SET DEVICE TO SC/prSends the results of an @..SAY command to the SCREEN/printerENVIRON PLUS SET DOHISTORY on/OFCommand files are recorded/are NOT recorded in HISTORY ENVIRON PLUS SET ECHO on/OFF Echos/DOES NOT ECHO command lindes to the screen ENVIRON PLUS SET ESCAPE OFF TURNS OFF ABILITY FOR CNTL-C TO TERMINATE EXECUTION ENVIRON CLIP SET ESCAPE ON/off STOPS/continues command file execution when Esc is pressed ENVIRON PLUS SET EXACT on/OFF Requires/DOES NOT REQUIRE exact matches in character comparsENVIRON PLUS SET FIELDS TO Determines which fields are accessible ENVIRON PLUS SET FIELDS on/OFF Respects/IGNORES specified field list ENVIRON PLUS SET FILTER TO Filters out database records not satisfying the condition ENVIRON PLUS SET FIXED on/OFF Fixes/DOES NOT FIX the number of decimals to be displayed ENVIRON PLUS SET FORMAT CMDS ALLOWED IN .FMT FILES. SCREEN NOT CLEARED WHEN CALLED ENVIRON CLIP SET FORMAT TO Opens a format file for data entry ENVIRON PLUS SET FUNCTION FUNCTION 1 CANNOT BE CHANGED; IT'S USED BY HELP ENVIRON CLIP SET FUNCTION TO Sets function key values ENVIRON PLUS SET HEADING ON/off Field names DISPLAY/do not in LIST or DISPLAY ENVIRON PLUS SET HELP ON/off PROMPTS/does not prompt user for help when an error occurs ENVIRON PLUS SET HISTORY ON/off Turns command history feature on and off ENVIRON PLUS SET HISTORY TO Specifies number of commans to store in HISTORY ENVIRON PLUS SET INDEX TO Opens named INDEX files ENVIRON PLUS SET INTENSITY ON/ofUSES/does not use the enhanced display ENVIRON PLUS SET KEY EXECUTE FROM WAIT STATES: WAIT,READ,INPUT,ACCEPT,MENU ENVIRON CLIP SET MARGIN TO Sets the left margin of a printer ENVIRON PLUS SET MEMOWIDTH TO Adjusts the column width of a memo field output ENVIRON PLUS SET MENUS ON/off DISPLAYS/does not idsplay a menu diring full-screen commandsENVIRON PLUS SET MESSAGE USED WITH @..PROMPT AND MENU ENVIRON CLIP SET MESSAGE TO Displays user-defined message on screen ENVIRON PLUS SET ODOMETER TO Controlls file count screen display with TALK ON ENVIRON PLUS SET ORDER TO Sets up any open index file as the controlling file ENVIRON PLUS SET PATH DOES NOT SUPPORT CONTINUATION OF A LINE WITH SEMICOLON ENVIRON CLIP SET PATH TO Specifies a path for a file search ENVIRON PLUS SET PRINT on/OFF Sends/DOES NOT SEND output to a printer ENVIRON PLUS SET PRINTER SETS ONE OF 3 DESTINATIONS FOR PRINT OUTPUT ENVIRON CLIP SET PRINTER TO Redirects output to the specified device ENVIRON PLUS SET PROCEDURE TO Opens a named procedure file ENVIRON PLUS SET RELATION TO Links two databases according to a key expression ENVIRON PLUS SET SAFETY ON/off PROMPTS/does not when a file is about to be overwritten ENVIRON PLUS SET SCOREBOARD ON/fdBASE III PLUS messages APPEAR/do not on the status line ENVIRON PLUS SET STATUS ON/off DISPLAYS/does not display the status line from dot prompt ENVIRON PLUS SET STEP on/OFF Halts/DOES NOT HALT execution after each command processed ENVIRON PLUS SET TALK ON/off SENDS/does not send the results of commands to the screen ENVIRON PLUS SET TITLE ON/off PROMPTS/does not prompt for a catalog file title ENVIRON PLUS SET TYPEHEAD TO Specifies the size of the type-ahead buffer ENVIRON PLUS SET UNIQUE on/OFF Causes first/ALL record(s) with same keys to be indexed ENVIRON PLUS SET VIEW TO Opens a view (.vue) file ENVIRON PLUS LINES() NUMBER OF LINES IF OUTPUT AT (N) WIDTH MEMO RETTIG TABSTRIP() REPLACE TAB CHARACTER WITH (N) SPACES MEMO RETTIG WPSTRIP() REPLACE CR, LF, AND TAB CHARACTER WITH SPACES MEMO RETTIG ACCEPT STORES A CHARACTER STRING INTO A MEMORU VARIABLE MEMVAR PLUS AVERAGE STORE THE ARITHMETIC MEAN OF TO MEMORY VARIABLE MEMVAR PLUS CLEAR ALL INITIALIZES DBASE III PLUS MEMVAR PLUS CLEAR MEMORY ERASES THE CURRENT MEMORY VARIABLES MEMVAR PLUS COUNT STORES COUNTS INTO MEMORY VARIABLES MEMVAR PLUS DISPLAY MEMORY DISPLAYS CURRENT MEMORY VARIABLES MEMVAR PLUS DISPLAY MEMORY DISPLAYS CURRENT MEMORY VARIABLES MEMVAR PLUS INPUT STORES AN EXPRESSION INTO A MEMORY VARIABLE MEMVAR PLUS READ PERMITS ENTRY TO GET FIELD OR VARIABLE MEMVAR PLUS READ ALLOWS DATA ENTRY INTO AN @...GET VARIABLE MEMVAR PLUS RELEASE ERASES CURRENT MEMORY VARIABLES FROM A DISK FILE MEMVAR PLUS RESTORE RETRIEVES SETS OF SAVED MEMORY VARIABLES MEMVAR PLUS SAVE COPIES CURRENT MEMORY VARIABLES TO A MEMORY FILE MEMVAR PLUS SAVE SAVES THE CURRENT MEMORY VARIABLES TO A FILE MEMVAR PLUS STORE STORES EXPRESSIONS INTO MEMORY VARIABLES MEMVAR PLUS SUM STORES SUMS INTO MEMORY VARIABLES MEMVAR PLUS WAIT ACCEPTS A SINGLE CHARACTER INTO A MEMORY VARIABLE MEMVAR PLUS ASSIST MENU-DRIVEN MISC PLUS BLANK() EMPTY VALUE OF ANY DATA: USE WITH REPLACE MISC RETTIG CREATE LABEL CREATES A LABEL FORM FILE MISC PLUS CREATE REPORT CREATES A REPORT FORM FILE MISC PLUS CREATE SCREEN CREATES A SCREEN,FORMAT FILE, AND OPTIONALLY A DATABASE FILEMISC PLUS FKLABEL() NAMES OF FUNCTION KEYS MISC PLUS FKMAX() MAXIMUM NO., OF FUNCTION KEYS MISC PLUS HARDCR() SOFT CR (141) REPLACED WITH HARD CR (13). IN MEMO.LIB MISC CLIP LABEL DISPLAYS DATA IN THE FORM OF LABELS MISC PLUS MODIFY COMMAND CREATES A COMMAND, FORMAT OR PROCEDURE FILE MISC PLUS MODIFY COMMAND A WORD PROCESSOR; EDITS ASCII-TEXT FILES MISC PLUS MODIFY LABEL EDITS A LABEL FORM FILE MISC PLUS MODIFY REPORT MODIFIES A REPORT FORM FILE MISC PLUS MODIFY SCREEN MODIFIES A SCREEN FILE MISC PLUS PASSWORD() ENCODE PASSWORD THAT CANNOT BE DECODED MISC RETTIG REPORT DISPLAYS A REPORT OF DATA MISC PLUS STATUS() VALUE OF SPECIFIED SET COMMAND MISC RETTIG VERSION() DBASE III PLUS VERSION NUMBER MISC PLUS ABS() ABSOLUTE VALUE NUMERIC PLUS AVERAGE COMPUTES AND DISPLAYS THE ARITHMETIC MEAN NUMERIC PLUS BASE() VALUE OF DECIMAL NUMBER IN SPECIFIED BASE NUMERIC RETTIG BASE10() DECIMAL NUMBER OF SPECIFIED BASE VALUE NUMERIC RETTIG BIN() BINARY VALUE (BASE 2) OF DECIMAL NUMBER NUMERIC RETTIG CEILING() INTEGER JUST ABOVE SPECIFIED VALUE NUMERIC RETTIG DEC() DECIMAL VALUE (BASE 10) OF HEXADECIMAL NUMBER NUMERIC RETTIG EXP() EXPONENTIAL (EX) NUMERIC PLUS EXPONENT() POWER OF 2 USED TO REPRESENT NUMBER NUMERIC RETTIG FACT() FACTORIAL OF NUMBER (N!) NUMERIC RETTIG FLR() INTEGER JUST BELOW SPECIFIED VALUE (FLOOR) NUMERIC RETTIG HEX() HEXADECIMAL VALUE VALUE (BASE16) OF DECIMAL NUMBER NUMERIC RETTIG INFINITY() 2 1024 (8087/80287 ERROR RETURN VALUE) NUMERIC RETTIG INT() INTEGER NUMERIC PLUS LOG() LOGARITHM NUMERIC PLUS LOGNBASX() LOG OF (N) TO THE BASE NUMERIC RETTIG LOGTEN() LOG OF TO THE BASE 10 NUMERIC RETTIG MANTISSA() MANTISSA TIMES 2 TO THE EXPONENT() GIVES NUMBER NUMERIC RETTIG MAX() GREATER OF TWO VALUES NUMERIC PLUS MIN() SMALLER OF TWO VALUES NUMERIC PLUS MOD() MODULUS NUMERIC PLUS PEEKDBL() READ 8-BYTE FLOATING-POINT FROM MEMORY ADDRESS NUMERIC RETTIG PEEKINT() READ INTEGER FROM MEMORY ADDRESS NUMERIC RETTIG PEEKLONG() READ LONG INTEGER FROM MEMORY ADDRESS NUMERIC RETTIG POKEDBL() WRITE 8-BYTE FLOATING-POINT TO MEMORY ADDRESS NUMERIC RETTIG POKEINT() WRITE INTEGER TO MEMORY ADDRESS NUMERIC RETTIG POKELONG() WRITE LONG INTEFER TO MEMORY ADDRESS NUMERIC RETTIG POWER() RAISE NUMBER TO SPECIFIED POWER NUMERIC RETTIG ROOT() TH ROOT OF NUMBER NUMERIC RETTIG ROUND() ROUNDS OFF NUMERIC PLUS SQRT() SQUARE ROOT NUMERIC PLUS STR() NUMERIC TO CHARACTER NUMERIC PLUS STR() PARAMETERS NOT REQUIRED NUMERIC CLIP SUM COMPUTES AND DISPLAYS THE SUM OF AN EXPRESSION NUMERIC PLUS SUM USE OF MEMVAR IS MANDATORY NUMERIC CLIP VAL() CHARACTER TO NUMERIC NUMERIC PLUS EJECT EJECTS A PAGE ON THE PRINTER PRINTER PLUS ISPRINTER() IS THE PRINTER ON-LINE AND READY? PRINTER RETTIG LPTSWAP SWITCH LPT1 AND LPT2 PRINTER RETTIG PRNSTATUS() CURRENT STATUS OF PRINTER PRINTER RETTIG PRTSC PRINT CURRENT SCREEN PRINTER RETTIG SETPRC() SETS INTERNAL PROW() AND PCOL() TO SPECIFIED VALUES PRINTER CLIP TOF() IS PRINTER AT TOP OF FORM? (USE WITH NOEJECT) PRINTER RETTIG & - MACRO SUBST USE ANYWHERE IN DO WHILE. NESTED AND RECURSIVE ALLOWED PROGRAMMG CLIP ? DISPLAYS AN EXPRESSION LIST PROGRAMMG PLUS @...BOX DRAW AND FILL BOX WITH ANY CHR() - FOR BOXES ONLY USE @..TO PROGRAMMG CLIP @...PROMPT PLACE MENU SELECTIONS ON SCREEN PROGRAMMG CLIP @...SAY DISPLAYS USER-FORMATTED DATA ON THE SCREEN OR PRINTER PROGRAMMG PLUS @...TO DRAWS A BOX PROGRAMMG PLUS @..GET..SAY SUPPORTS VALID, GETS INTO ALIAS AREA, @E, @), K, Sn PROGRAMMG CLIP ACCEPT ALLOWS INPUT OF CHARADTER DATA INTO A MEMORY VARIABLE PROGRAMMG PLUS CALL CALL SEPARATELY COMPILED OR ASSEMBLED ROUTINES [WITH WORD()]PROGRAMMG CLIP CANCEL TERMINATES COMMAND FILE EXECUTION PROGRAMMG PLUS CASE ONE OF THE PATHS PROGRAMMG PLUS DO CAUSES A PROGRAM OR PROCEDURE TO BE EXECUTED PROGRAMMG PLUS DO CASE ALLOWS EXECUTION OF ONLY ONE OF SEVERAL POSSIBLE PATHS PROGRAMMG PLUS DO WHILE ALLOWS STRUCTURED LOOPS IN PROGRAMS PROGRAMMG PLUS ELSE ALLOWS AN ALTERNATE PATH OF EXECUTION WITHIN IF PROGRAMMG PLUS EMPTY() TRUE IF FIELD OR EXPRESSION(C,N,D,L) IS EMPTY PROGRAMMG CLIP ENDCASE TERMINATES A DO CASE COMMAND PROGRAMMG PLUS ENDDO TERMINATES A DO WHILE COMMAND PROGRAMMG PLUS ERROR() NUMBER FOR ON ERROR CONDITION PROGRAMMG PLUS EXIT TO LEAVE DO WHILE PROGRAMMG PLUS EXTERNAL DECLARE A SYMBOL FOR THE LINKER PROGRAMMG CLIP FOR NEXT LOOP WITH OPTIONAL INCREMENTS AND DECREMENTS PROGRAMMG CLIP FUNCTION DECLARES USER-DEFINED FUNCTIONS PROGRAMMG CLIP IF ALLOWS CONDITIONAL EXECUTION OF COMMANDS PROGRAMMG PLUS IF() CONDITIONAL PROCESSING OF EXPRESSIONS. IIF() ALSO SUPPRTD PROGRAMMG CLIP IIF() ONE EXPRESSION OR ANOTHER PROGRAMMG PLUS INKEY() KEYPRESS DURING PROGRAM EXECUTION PROGRAMMG PLUS INKEY() RETURNS NUMERIC VALUE FOR KEY PRESSED PROGRAMMG CLIP INPUT ALLOWS INPUT OF AN EXPRESSION INTO A MEMORY VARIABLE PROGRAMMG PLUS KEYBOARD STUFFS KEYBOARD INPUT BUFFER WITH STRING. SIMUL. RET TO MSTRPROGRAMMG CLIP LASTKEY() RETURNS NUMERIC VALUE FOR LAST KEY PRESSED PROGRAMMG CLIP LOOP SKIPS TO HE BEGINNING OF A DO WHILE LOOP PROGRAMMG PLUS MEMOEDIT() EDIT MEMOS. MEMO.LIB PROGRAMMG CLIP MEMOREAD() RETURN CONTENTS OF DISK TEXT FILE. MEMO.LIB PROGRAMMG CLIP MEMOTRAN() REPLACE CR AND LF WITH SEMICOLON OR SPACE. MEMO.LIB PROGRAMMG CLIP MEMOWRIT() WRITES STRING TO DISK. MEMO.LIB PROGRAMMG CLIP MESSAGE() ON ERROR MESSAGE STRING PROGRAMMG PLUS OTHERWISE ALTERNATIVE TO ALL OTHER CASES PROGRAMMG PLUS PARAMETERS SPECIFIES OPTIONAL PARANETERS TO BE USED BY A PROGRAM PROGRAMMG PLUS PARAMETERS MORE THAN ONE PARAM CAN BE PASSED FROM DOS PROGRAMMG CLIP PCOL() PRINTER COLUMN POSITION PROGRAMMG PLUS PCOUNT() NO. OF PARAMETERS PASSED FROM CMD LINE OR ANOTHER PROC. PROGRAMMG CLIP PRIVATE HIDES A MEMORY VARIABLE FROM HIGHER-LEVEL COMMAND FILES PROGRAMMG PLUS PROCEDURE MARKS THE BEGINNING OF A PROCEDURE IN A PROCEDURE FILE PROGRAMMG PLUS PROCEDURE FILE MUST HAVE UNIQUE NAME. CAN PUT AT BOTTOM OF .PRG FILE PROGRAMMG CLIP PROCLINE() RETURNS SOURCE CODE LINE NUMBER PROGRAMMG CLIP PROCNAME() RETURNS NAME OF PROGRAM OR PROCEDURE PROGRAMMG CLIP PROW() PRINTER ROW POSITION PROGRAMMG PLUS PUBLIC MAKES A MEMORY VARIABLE GLOBAL PROGRAMMG PLUS PUBLIC CLIPPER TO PUT CLIPPER ENHANCEMENTS IN INTERPRETED PLUS .PRG PROGRAMMG CLIP QUIT CLOSES ALL FILES AND EXITS DBASE III PLUS PROGRAMMG PLUS READKEY() FULL-SCREEN EXITING KEYPRESS PROGRAMMG PLUS READVAR() NAME OF CURRENT GET/MENU. USEFUL WITH SET KEY PROGRAMMG CLIP RETRY RETURNS TO CALLING PROGRAM AND REEXECUTES SAME COMMAND PROGRAMMG PLUS RETURN RETURNS CONTROL TO CALLING PROGRAM AND EXECUTES NEXT COMMANDPROGRAMMG PLUS SUSPEND HALTS EXECUTION OF .PRG AND PRESENTS DOT PROMPT PROGRAMMG PLUS TEXT DISPLAYS A BLOCK OF TEXT DATA IN A COMMAND FILE PROGRAMMG PLUS TEXT TO PRINT AND TO FILE ARE ADDED FEATURES PROGRAMMG CLIP TYPE DOS REDIRECTION NOT SUPPORTED. TO PRINT AND TO FILE ADDED PROGRAMMG CLIP TYPE() VALIDATES EXPRESSION PROGRAMMG PLUS UPDATED() TRUE IS LAST READ CHANGED DATA IN ASSOCIATED GETS PROGRAMMG CLIP WAIT SUSPENDS PROGRAM PROCESSING UNTIL A KEY IS ENTERED PROGRAMMG PLUS @..TO DRAWS BOXES AND LINES AND CLEARS. SAME AS PLUS SCREEN CLIP BIOSATTR() CURRENT SCREEN ATTRIBUTES FROM BIOS SCREEN RETTIG CLEAR ERASES THE CRT SCREEN SCREEN PLUS COL() CURRENT SCREEN COLUMN POSITION SCREEN PLUS CURSOR TURN CURSOR OFF AND ON SCREEN RETTIG MENU HIGHLIGHT @...PROMPT SCREEN CLIP RESTORE SCREEN RESTORE A SCREEN SAVED TO BUFFER WITH SAVE SCREEN SCREEN CLIP RESTSCR() RESTORE SCREEN FROM DISK FILE SCREEN RETTIG ROW() CURRENT SCREEN ROW POSITION SCREEN PLUS SAVE SCREEN SAVE SCREEN TO BUFFER. USE WITH RESTORE SCREEN. SCREEN CLIP SAVESCR() SAVE SCREEN TO DISK FILE SCREEN RETTIG SCRATTR() CURRENT SET COLOR VALUES SCREEN RETTIG SCROLL SCROLL PORTION OF SCREEN: FAST CLEAR INSIDE OF BOX SCREEN RETTIG SET COLOR CAN HAVE DIFF SCREEN ATTRIBS FOR SELECTED AND OTHER GETS SCREEN CLIP TRANSFORM() CHARACTER/NUMBER IN PICTURE FORMAT SCREEN PLUS ALLOCATE() ALLOCATE MEMORY SYSTEM RETTIG BUFFERS() NUMBER OF BUFFERS SET IN CONFIG-SYS SYSTEM RETTIG CALL Executes a binary file (module) placed in memory with LOAD SYSTEM PLUS COUNTRY() COUNTRY NUMBER SET IN CONFIG-SYS SYSTEM RETTIG DATE() SYSTEM DATE SYSTEM PLUS DEALLOC() RELEASE MEMORY OBTAINED WITH ALLOCATE() SYSTEM RETTIG DIR SHOWS FILES SYSTEM PLUS DOSFUNC DOS INT 21H FUNCTION CALL SYSTEM RETTIG DOSVERS() DOS VERSION NUMBER SYSTEM RETTIG FILEATTR CHANGE ANY OR ALL FILE ATTRIBUTES SYSTEM RETTIG FILEREAD() READ A TEXT FILE FROM DISK SYSTEM RETTIG FILES() NUMBER OF FILES SET IN CONFIG-SYS SYSTEM RETTIG FILESIZE() SIZE OF DISK FILE IN BYTES SYSTEM RETTIG FILEWRITE() WRITE A TEXT FILE TO DISK SYSTEM RETTIG FLOCK() NETWORKING SYSTEM CLIP GETENV() OPERATING SYSTEM ENVIRONMENT VARIABLES SYSTEM PLUS ISCOLOR() EVALUATE FOR COLOR MODE SYSTEM PLUS LASTDRIVE() LETTER OF LAST DRIVE SET IN CONFIG-SYS SYSTEM RETTIG LOAD Places a binary file in memory SYSTEM PLUS LOCK() NETWORKING SYSTEM CLIP MEMORY () AMOUNT OF AVAILABLE MEMORY SYSTEM RETTIG MEMORY() AVAIL MEMORY IN K BYTES SYSTEM CLIP NETERR() NETWORKING SYSTEM CLIP NETNAME() NETWROKING SYSTEM CLIP OFF() OFFSET ADDRESS OF MEMORY VARIABLE SYSTEM RETTIG OFFSET OFFSET ADDRESS OF MEMORY VARIABLE SYSTEM RETTIG OS() NAME OF OPERATING SYSTEM SYSTEM PLUS PEEKBYTE() READ HEX BYTE FROM MEMORY ADDRESS SYSTEM RETTIG POKEBYTE() WRITE HEX BYTE TO MEMORY ADDRESS SYSTEM RETTIG REG() READ CONTENTS OF SPECIFIED CPU REGISTER SYSTEM RETTIG RLOCK() NETWORKING SYSTEM CLIP ROMBIOS EXECUTE ROM BIOS INTERRU[T SYSTEM RETTIG SEG() SEGMENT ADDRESS OF MEMORY VARIABLE SYSTEM RETTIG SEGMENT SEGMENT ADDRESS OF MEMORY VARIABLE SYSTEM RETTIG SET EXCLUSIVE NETWORKING FEATURE SYSTEM CLIP TIME() SYSTEM TIME SYSTEM PLUS UNLOCK NETWORKING SYSTEM CLIP USE...EXCLUSIVE NETWORKING SYSTEM CLIP DTOSS() DAYS TO SECONDS TIME RETTIG HTOSS() HOURS TO SECONDS TIME RETTIG ISTSTIME() IS TIME STRING VALID? TIME RETTIG MAKETIME() MAKE INVALID TIME STRING VALID TIME RETTIG MTOSS() MINUTES TO SECONDS TIME RETTIG SECONDS() SYSTEM TIME AS SECONDS AND HUNDRETHS OF SEC TIME CLIP SSTOD() SECONDS TO DAYS TIME RETTIG SSTOH() SECONDS TO HOURS TIME RETTIG SSTOM() SECONDS TO MINUTES TIME RETTIG TIMESTR() CREATE TIME STRING FROM SECONDS TIME RETTIG TSTOH() TIME STRING TO HOURS TIME RETTIG TSTOM() TIME STRING TO MINUTES TIME RETTIG TSTOS() TIME STRING TO SECONDS TIME RETTIG