PROGRAM SUMMARY PROGRAM SUMMARY S T A R T E C H S Y S T E M S D Y N A M E N U S Y S T E M P R O G R A M S U M M A R Y ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ ßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßß ASCICHRS - DISPLAYS THE ASCII CHARACTERS AND THE ASSOCIATED DECIMAL AND HEX CODES. THE SOURCE CODE IS PROVIDED. BDSHELPR - THE HELP SYSTEM MENU DISPLAY - PROVIDES FOR SELECTION OF FILES/HELP BY MAJOR SUBJECT, CATEGORY, PROGRAM, DATABASE AND HELP FILE NAME. BROWHELP - THE HELP DISPLAY PROGRAM FOR THE HELP SYSTEM. DISPLAYS THE FILE AT THE LINE NUMBER INDICATED BY THE PASSED PARAMETERS. PARAMETERS AS FOLLOWS: INFILE - .INF FILE TO BROWSE. PASS '.INF'. INRECNO - LINE NUMBER TO POSITION CURSOR TO. PASS 0 FOR FIRST LINE. SRCHTEXT - TEXT SEARCH TOKEN FOR FINDING LIKE INFO. PASS '' FOR NONE. DIRCTCALL - .T. IF CALL WAS NOT FROM BDSHELPR. PAINTSCRN - .T. IF SCREEN SHOULD BE RESTORED ON EXIT. MAY BE CALLED DIRECTLY FROM ANY PROGRAM. BUILDPRT - BUILD/INSTALL PRINTERS FOR USE WITH PRTMENU - USES PRTRSRCE.DBF. ALSO SEE HELP FILE SYSTEM.INF. CALC - A FULL FUNCTIONED DBASE BUSINESS CALCULATOR WITH SIGNIFICANT HELP SCREENS. STORES 10 FORMULAS; EACH FORMULA HAS 20 STORED/ASSOCIATED REGISTERS. NETWORK USERS EACH HAVE THEIR OWN SET OF FORMULAS/REGISTERS. EACH FORMULA CAN BE 253 CHARACTERS LONG. PROVIDES FOR ALL DBASE MATH FUNCTIONS INCLUDING DATE CALCULATIONS. CHKPROGS - A MENU UTILITY TO REVIEW ALL ITEMS (PROGRAM CALLS) ON FILE IN THE CURRENT USER'S MENU - DISPLAYS CALLS ALPHABETICALLY WITH COLUMN/CELL NUMBER REFERENCES. THIS IS A VERY USEFUL TOOL TO REVIEW HOW OTHER CALLS HAVE BEEN SET UP IN THE MENU. THE VERY FIRST LINE TO BE VIEWED CONTAINS POINTERS TO GROUPS OF RECORDS AVAILABLE FOR USE AS EXTENDED MENUS. IF THE COLUMN LABELED 'PROGRAM' IS BLANK IT MEANS THERE ARE NO CURRENTLY UNUSED RECORDS IN THE DYNAMENU FILE IN USE. IN THAT CASE, THE NEXT ADDITION OF AN EXTENDED MENU WILL EXPAND THE DYNAMENU FILE WITH 15 NEW RECORDS. ALL DELETED EXTENDED MENUS FORCE A RECORD POINTER TO APPEAR IN THIS FIELD. THE COLUMN LABELED 'COLUMN' REPRESENTS THE COLUMN REFERENCES (1-8) AND CELLS (1-15) IN WHICH YOU WILL FIND THE PROGRAM CALL BEING DISPLAYED. FROM THE MENU MOVE THE CURSOR TO THAT CELL AND PRESS TO VIEW THAT SAME CALL INFORMATION DIRECTLY. AN X APPEARING IN THE COLUMN LABELED 'COLUMN' MEANS THAT REFERENCE POINTS TO AN EXTENDED MENU - THERE SHOULD BE A CELL REFERENCE IN THE COLUMN LABELED 'EXT_CELL'. USE THE 'REARRANGE MENU' PROGRAM (TOKNMOVE) TO COPY A PARTICULAR CALL TO A BLANK CELL. BE SURE TO SPECIFY 'N' WHEN ASKED TO CLEAR OLD CELL INFORMATION. THIS SAVES FROM HAVING TO TYPE THE ENTIRE INFORMATION ABOUT THE CALL. CLEARBOX - UTILITY BOX CLEARING PROGRAM WITH OPTIONAL GET AND BELL. SEE HELP FILE MENUINFO.INF FOR DETAILS. COLRSCRN - PROGRAM TO SET SYSTEM COLOR WITH GRAPHIC SELECTION PROCESS. USE KEY COMBINATION AT THE MAIN MENU. CREAHELP - CREATE HELP PROVIDES FOR ADDITIONS/DELETIONS OF HELP .INF FILES. CREATES .INF FILES AND INDEX REFERENCES AS DETERMINED BY THE CONTROL CODES IN THE RELATED .TXT FILES. HELP CONTROL CODES ARE DEFINED AS FOLLOWS: MINOR CATEGORIES = CHR(1) = ALT-1 on most word procs. MAJOR CATEGORIES = CHR(2) = ALT-2 ³ ³ PROGRAM NAMES = CHR(3) = ALT-3 ³ ³ DATABASE NAMES = CHR(4) = ALT-4 ³ ³ Characters should appear in the .TXT files as follows: CHR(4)CHR(3)CHR(1)<20 chars of text>CHR(1)CHR(3)CHR(4) One or two of these might apply to the same token, however, as many as 3 can be used on one token in descending/ascending order. CHR(1) & CHR(2-4) should be used exclusively of each other because the MINOR category TAG (CHR(1)) includes all category references (CHR(1) thru CHR(4)). These characters are stripped from the text at .INF file creation time. If the next space to the right of the specified text is satisfactory for use as a delimiter, a second control code is not required. The default input file extension is .TXT, however, any may be used. Please keep in mind that within the help system, the .EXT is not significant. This means that all input files are converted to .INF without regard for differences in the originating .EXT name and therefore all input text file names should be unique even if they are stored in other directories. The text in the input files should maintain a maximum 65 column width. CREAUSER - USE ON NETWORK TO SET UP A NEW USER FOR THE DYNAMENU SYSTEM. AFTER VERIFYING THE EXISTANCE OF THE USER, IT COPIES DYNAMENU.DBF, FORMULA.MEM, PERSNAME.* AND CONFIG.DB TO THE NEW USER'S DIRECTORY. DOSCMMND - A DOS INTERFACE PROGRAM - RESETS DRIVE AND DIRECTORY ON EXIT. IF YOU ARE LOGGED OFF OF A NETWORK AND USING THIS PROGRAM ON A LOCAL DRIVE AND YOUR NETWORK DRIVERS ARE IN MEMORY DBASE WILL INFORM YOU THAT YOU HAVE INSUFFICIENT MEMORY. THE ONLY PROPER WAY TO HANDLE THIS IS TO REBOOT WITHOUT THE NETWORK DRIVERS IN MEMORY. DYNAMENU - THE MAIN MENU SYSTEM PROGRAM - ALSO SEE HELP FILE MENUINFO.INF. THIS PROGRAM PROVIDE FOR INDIVIDUAL MENUS FOR EACH USER IN A NETWORKED ENVIRONMENT. EXPORT - A UNIVERSAL EXPORT FILE TO CREATE SDF OR COMMA DELIMITED COPIES OF YOUR DATA BASES. USED ON THE MENU UNDER 'NAMES' TO EXPORT MISCNAME.DBF & PERSNAME.DBF AS A COMMA DELIMITED FILE OUTPUT TO DRIVE A:. USAGE IS: DO EXPORT WITH 'FILEIN','FILOUT',SDFILE,'' WHERE: FILEIN=A DBASE FILE WITH .DBF EXTENSION FILEOUT=NAME OF TEXT FILE WITH/WITHOUT EXTENSION SDFILE=.T. FOR SDF OUTPUT OR .F. COMMA DELIMITED OUTPUT DRIVE=ANY VALID DRIVE (NO ':') F1BROWSE - HELP SCREEN PROGRAM THAT IS CALLED FROM FILEBROW. FILEBROW - UNIVERSAL BROWSE WINDOW PROGRAM WITH ACCESS LEVELS FOR INSURING AGAINST ACCIDENTAL DELETES AND CHANGES. PARAMETERS AS FOLLOWS: EDITFILE,OKTOADD,OKTOEDIT,ALLOK,WINDSIZE,MINDEXES, SEEKVAR,UPRLOWR EDITFILE - MAIN FILE TO BROWSE - DON'T INCLUDE '.DBF' OKTOADD - BROWSE LET'S YOU APPEND RECORDS if (T)rue OKTOEDIT - BROWSE LET'S YOU EDIT RECORDS if (T)rue ALLOK - BROWSE LET'S YOU DELETE RECORDS if (T)rue WINDSIZE - SIZE OF WINDOW IN LINES (2-11) MINDEXES - PASS INDEX FILE FIRST 'INDXFILE1,2,ùùùùù' IF TAG ORDER IS REQUIRED ALSO ADD TAGNAME 'TAG TAGNAME'. THE REST OF THE TAGS TAKE CARE OF THEMSELVES. IF NO INDEXES JUST PASS TAG AS ABOVE. SEEKVAR - PASS THE DATABASE VARIABLE NAME THAT IS A SIMPLE KEY WORKS BEST. USED IN A SEEK OF THIS DATA BASE KEYS LIKE LOWER() ALSO WORK. PASS ONLY VARIABLE NAME AND NOT THE KEY (CHARS & DATE VARS ONLY). UPRLOWR - PASS WHICH CASE TO SEEK ON - MUST BE 'U' OR 'L' FOR NDX REFERENCES OR 0-9 FOR KEY OFFSET REFERENCES IN MDX FILES. PROGRAM WILL CONVERT THE INPUT TO COINCIDE WITH THIS REFERENCE. FORMLETR - A PROGRAM FROM WHICH TO CREATE AND SEND LETTERS TO INDIVIDUALS IN THE DATABASE MISCNAME.DBF - CREATE THE BODY OF THE LETTER IN AN ASCII TEXT FILE WITH YOUR WORD PROCESSOR FIRST. TEXT FILE SHOULD INCLUDE YOUR SALUTATION, COMPANY NAME AND ENCLOSURES REMARKS AS AS APPROPRIATE. THE PARAMETERS USED IN THE CALL ARE FOR USE IN A FUTURE RELEASE. GSYS_DAT - DYNAMENU PUBLIC VARIABLES AND SET UP PROGRAM. KEEPS MEMORY REQUIREMENTS AT A MINIMUM BECAUSE IT'S NOT IN LINE - SEE FILE MENUINFO.INF. HLPINTFC - THE HELP INTERFACE BETWEEN APPLICATION PROGRAMS AND THE HELP SYSTEM. CALL THIS PROGRAM WITH: ON KEY LABEL SHIFT-F1 DO HLPINTFC WITH '','','' WHERE MAY BE: 'MAJORCAT' (MAJOR SYSTEM REFERENCES) 'MINORCAT' (MINOR SYSTEM REFERENCES) - MOST COMMON 'PROGRAMS' (SYSTEM PROGRAM REFERENCES) 'DTABASE' (SYSTEM DATABASE REFERENCES) WHERE MAY BE: *** KEY TO HELP SYSTEM TEXT RELATIVE TO THE PROGRAM NEEDING HELP AND KNOWN TO BE INCLUDED AMONG THE REFERENCES PREPARED FOR THE SPECIFIED . THIS VALUE WOULD NORMALLY CHANGE AT VARIOUS LOCATIONS THROUGHOUT THE APPLICATION PROGRAM - SIMPLY RESTATE THE ON KEY LABEL COMMAND WHERE NECESSARY. WHERE MAY BE: A WINDOW THAT COULD BE OPEN WHEN THE USER CALL FOR FOR HELP FROM THE APPLICATION PROGRAM. NO ERROR IS ENCOUNTERED IF THE WINDOW IS NOT OPEN AT THE TIME THE CALL FOR HELP IS MADE. THIS VALUE WOULD NORMALLY CHANGE AT VARIOUS LOCATIONS THROUGHOUT THE APPLICATION PROGRAM - SIMPLY RESTATE THE ON KEY LABEL COMMAND WHERE NECESSARY. ON KEY IN HELP THE APPLICATION CALL MUST ANTICIPATE THE NEED TO RESTORE ON KEY REQUIREMENTS UPON RETURN FROM THE HELP SYSTEM. THIS IS DONE ON EXIT FROM HELP IF THE APPLI- CATION PROGRAM HAS PROVIDED ITS REQUIREMENTS IN THE PUBLIC ARRAY ONKEYS[6,2]. SUPPOSE THE APPLICATION REQUIRES THE FOLLOWING ON KEY CONDITIONS: ON KEY LABEL SHIFT-F1 DO HLPINTFC WITH; 'PROGRAMS','FILEBROW','x' ON KEY LABEL F1 DO F1BROWSE ON KEY LABEL CTRL-F7 DO SEEKREC THE ONKEYS ARRAY SHOULD BE INITIALIZED AS FOLLOWS: ONKEYS[1,1]='F1' ONKEYS[1,2]='F1BROWSE' ONKEYS[2,1]='CTRL-F7' ONKEYS[2,2]='SEEKREC' THIS DATA WILL BE USED TO RESET ON KEY CONDITIONS EXISTING PRIOR TO THE CALL FOR HELP. UNDERSTAND THAT NO ON KEY CONDITIONS MAY BE ACTIVE WHILE THE HELP SYSTEM IS PERFORMING ITS FUNCTION. IMPTNAME - WILL IMPORT A COMMA OR SPACE DELIMITED ASCII FILE TO MISCNAME.DBF. SEE DYNAHELP SYSTEM FILE MAILNAME.INF. THE PARAMETERS USED IN THE CALL ARE FOR USE IN A FUTURE RELEASE. INKEYTST - PRODUCES A SMALL WINDOW THAT IS USEFUL IN DETERMINING INKEY VALUES JULDATE - CONVERTS ANY DATE TO A JULIAN DATE - IE., yyddd. LABLMRKD - UNIVERSAL PRINT LABEL PROGRAM FOR ALL DATABASES IN THE SYSTEM THAT ARE PRIMARILY FOR NAMES. PARAMETERS AS FOLLOWS: EDITFILE,MINDEXES,SEEKVAR,UPRLOWR EDITFILE - MAIN FILE TO BROWSE - DON'T INCLUDE '.DBF' MINDEXES - PASS INDEX FILE FIRST 'INDXFILE1,2,ùùùùù' IF TAG ORDER IS REQUIRED ALSO ADD TAGNAME 'TAG TAGNAME'. THE REST OF THE TAGS TAKE CARE OF THEMSELVES. IF NO INDEXES JUST PASS TAG AS ABOVE. SEEKVAR - PASS THE DATABASE VARIABLE NAME THAT IS A SIMPLE KEY WORKS BEST. USED IN A SEEK OF THIS DATA BASE KEYS LIKE LOWER() ALSO WORK. PASS ONLY VARIABLE NAME AND NOT THE KEY (CHARS & DATE VARS ONLY). UPRLOWR - PASS WHICH CASE TO SEEK ON - MUST BE 'U' OR 'L' FOR NDX REFERENCES OR 0-9 FOR KEY OFFSET REFERENCES IN MDX FILES. PROGRAM WILL CONVERT THE INPUT TO COINCIDE WITH THIS REFERENCE. THE USE OF DIFFERENT PRINTERS WILL GENERATE A PRINTER .MEM FILE THE FIRST TIME A PRINTER NAME IS USED. SUBSEQUENT USE OF THOSE PRINTERS WILL DISPLAY THE LAST LABEL SETTINGS USED FOR A GIVEN PRINTER NAME. LISTSTRU - PREPARES A TEXT FILE SUITABLE FOR PRINTING THAT CONTAINS INFORMATION ABOUT ALL DATABASE STRUCTURES IN THE DEFAULT DIRECTORY AND THE ASSOCIATED INDEXING KEYS FROM THE PRODUCTION .MDX FILE. THE FILE IS CALLED DBFSTRUC.TXT LOCKERR - A SAMPLING OF RECORD AND FILE LOCKING PROCEDURES. ALSO HAS A PROCEDURE FOR ABNORMAL ABORT WHEN ALL ELSE FAILS. THE SOURCE CODE IS PROVIDED. MEMORY - PRODUCES A SMALL WINDOW TO PROVIDE FOR DISPLAYING THE AMOUNT OF MEMORY AVAILABLE. ANY AMOUNT BELOW 100 WHEN VIEWED FROM THE DYNAMENU MAIN SCREEN IS A POTENTIAL PROBLEM. APPLICATIONS OF SIGNIFICANT SIZE WILL REQUIRE MOST OF THIS MEMORY ALLOCATION. IF YOU ARE ON A NETWORK, CONSIDER USING A MEMORY MANAGER SUCH AS QEMM OR 386MAX TO LOAD YOUR NETWORK DRIVERS (AND OTHER TSR'S) INTO HIGH DOS. MENUCHGS - A MENU CHANGES PROGRAM THAT ALLOWS FOR INITIALIZING EACH CELL, CHANGING COLUMN NAMES, NUMBER OF ACTIVE CELLS IN A COLUMN, DEFAULT COLORS, CREATING/DELETING EXTENDED MENUS - SEE FILE MENUINFO.INF IN THE HELP SYSTEM. MENUEXTD - PROGRAM FOR DISPLAYING MENU ENTRIES THAT ARE PART OF AN EXTENDED MENU - SEE FILE MENUINFO.INF IN THE HELP SYSTEM. MISCENVL - MISCELLANEOUS ENVELOPE PROGRAM - STORES LAST ENVELOPE PREPARED IN FILE HOLDENVL.MEM. MISCNAME - A MAILING LIST PROGRAM - SEE FILE MAILLIST.INF. NAMENMBR - A PERSONAL NAME PROGRAM FOR FINDING PHONE NUMBERS. NORECDBF - A DISPLAYED MESSAGE THAT THERE ARE NO RECORDS IN THE SELECTED DBF. PERSLIST - THE MAIN PROGRAM FOR ADDING NAMES TO THE DATABASE PERSNAME.DBF. IS VERY SIMILAR TO THE OPERATION OF PROGRAM MISCNAME. PAPERINS - PROMPT FOR INFORMING USER TO INSERT ANOTHER PIECE OF PAPER WHEN THE SELECTED PRINTER IS NOT OF CONTINUOUS FEED. PARSTRNG - A STRING PARSING PROGRAM - AS PUBLISHED IN DBMS MAGAZINE IN THE OCTOBER 1990 ISSUE. SOURCE CODE PROVIDED. PERSENVL - A UTILITY PROGRAM TO PRINT AN ENVELOPE FROM THE PERSNAME DATABASE. PASTENAM - A CUT AND PASTE LABEL PROGRAM FOR THE PERSONAL NAME DATABASE. PLHSCRN - A HELP SCREEN FOR THE DYNAMENU SYSTEM. PROVIDES A SCREEN OF INFORMATION ABOUT THE CURSOR KEY CONTROLS FOR THE DYNAMENU MAIN AND EXTENDED MENUS. PRINTENV - A UTILITY PROGRAM TO PRINT AN ENVELOPE FROM THE MISCNAME DATABASE. PRTMENU - THE PRINTER SELECTION PROGRAM THAT CAN BE CALLED FROM ANYWHERE TO ALLOW THE USER TO DESIGNATE THE PRINTER TO USE. THE SOURCE CODE IS PROVIDED. PRTREDIT - PROVIDES FOR EDITING FILE PRTROPTS.DBF - SOME RESTRICTIONS ON EDITS ARE INVOKED AND YOU MAY VOID CHANGES BY PRESSING ESCAPE. THERE IS A 'PRINTER MAINTNCE' CELL ON THE MENU WHICH IS A CALL ON PROGRAM 'FILEBROW' AND HAS NO RESTRICTIONS OR ABORT CHANGES OPTION. PRTRTEST - PRINTER SELECT FOR CALLING TEST PRINTER - SEE FILE SYSTEM.INF. PSPOOLER - CALLS CAPTURE ON A NOVELL NETWORK WHEN SELECTED PRINTER IS ON THE SERVER AND NOT A LOCAL PORT AS DETERMINED BY FIELD 'LOCALPRTR'. OTHERWISE SETS THE PRINTER TO THE PORT AS DEFINED IN GLOBAL FIELD 'MPORTOUT'. THE SOURCE CODE IS PROVIDED. RANDPACK - UNIVERSAL PACKING PROGRAM THAT CAN BE USED TO PACK ANY DBASE DATABASE FROM A PROGRAM OR FROM A DYNAMENU CELL (PASS ALL NDX FILENAMES SEPARATED BY A COMMA). REDKYTST - PRODUCES A SMALL WINDOW THAT'S USEFUL IN DETERMINING RESULTING READKEY VALUES. THE SAME KEY COMBINATIONS MAY PRODUCE DIFFERENT VALUES IF THE FIELD WAS CHANGED SINCE THE INITIALIZATION OF THE GET. RESETPRT - WILL RESET THE SELECTED PRINTER TO DEFAULT STATE. SETDEVPT - CHECKS STATUS OF SELECTED TO DETERMINE IF OK TO SET DEVICE TO PRINTER. IF PRINTER NOT READY DISPLAYS AVAILABLE OPTIONS. SETPRT - SET PRINTER ON/OFF PROGRAM - CHECK STATUS FIRST AS ABOVE. SETSCREE - USED TO CREATE THE DYNAMENU BACKGROUND SCREEN AND INFORMATION. TESTPRTR - TEST PRINTER - SEE HELP FILE SYSTEM.INF. TOKNMOVE - TOKEN MOVE PROGRAM - PROVIDES FOR MOVING MENU CELL INFORMATION FROM ONE CELL TO ANOTHER. IF YOU SPECIFY 'N' WHEN ASKED IF YOU WANT THE OLD CELL INFORMATION CLEARED, YOU WILL IN EFFECT HAVE COPIED THE INFORMATION TO THE NEW LOCATION. WIDRPTCK - DETERMINES IF THE WIDTH OF THE SELECTED PRINTER IS ABLE TO SUPPORT THE REPORT ABOUT TO BE PRINTED. PARAMETER INFORMATION IS SUPPLIED WITH SOURCE CODE. YLYYIELD - A UTILITY TO CONVERT INTEREST RATES AND YIELDS TO TO TAX FREE AND AFTER TAX YIELDS. INPUT MODES ARE TOGGLED BY PRESSING AND . THE OPTIONS ARE: SIMPLE RATE SIMPLE YIELD TAX FREE YIELD AFTER TAX YIELD THE MODE USED TO CALUCLATE THE DESCRIBED OUTPUT IS HIGHLIGHTED ON THE SCREEN. THE 'SIMPLE RATE' IS ALWAYS HELD CONSTANT. WHEN A YIELD IS ENTERED, IT IS CONVERTED TO A SIMPLE RATE BASED ON THE DAILY COMPOUNDING FORMULA. THE RATE RESULTING FROM THIS CONVERSION IS ALSO HELD CONSTANT FOR SUBSEQUENT CALCULATIONS OF ALL YIELDS INCLUDING DAILY, MONTHLY AND QUARTERLY COMPOUNDING. ALL YIELD OUTPUTS ARE ALLOWED TO FLOAT REGARDLESS OF WHICH INPUT MODE IS IN EFFECT, WHICH IS WHY YIELDS THAT ARE INPUT MAY NOT APPEAR EXACTLY ON OUTPUT. THE YIELD THAT CORRESPONDS TO THE INPUT MODE WILL APPEAR MOST PRECISE (TO THAT OF THE ACTUAL INPUT) IN THE DAILY COMPOUNDING RESULTS. PRESSING WILL ALLOW THE TAXABLE BASIS TO BE CHANGED. THE DEFAULT IS 25% AND ANY TAXABLE RATE MAY BE ENTERED. THIS FACTOR IS USED TO GENERATE THE 'TAX FREE' AND 'AFTER TAX' YIELDS.