Programmer 7500

home *** CD-ROM | disk | FTP | other *** search

/ Programmer 7500 / MAX_PROGRAMMERS.iso / CLIPPER / DATABASE / MYB_203.ZIP / MYB_203.EXE / MYBASE.TXT < prev next >

Wrap

Text File | 1993-05-04 | 94.9 KB | 2,483 lines

▄▄▄ ▄▄▄ ▄▄▄▄▄▄▄ ▄▄▄ ▄▄▄▄▄ ▄▄▄▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄▄▄▄▄▄ ▄▄▄ ▄▄▄▄▄▄▄ ▄▄▄▄▄▄ ▄▄▄▄▄ ▄▄▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄▄▄ ▄▄▄▄ ▄ ▄▄▄ ▄▄▄▄▄ ▄▄▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄ ▄▄ ▄▄ ▄▄▄▄ ▄▄▄ ▄▄▄▄▄▄ ▄▄▄▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄▄▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄▄▄ ▄▄▄▄▄▄ ▄▄▄▄▄▄▄▄▄▄▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄▄▄▄▄ ▄▄ ▄▄ ▄▄▄▄▄ ▄▄▄▄▄▄ ▄▄▄ ▄▄▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄▄▄▄▄▄▄ ▄▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄ ▄▄ ▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄▄▄▄▄▄▄ ▄ ▄▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄▄ ▄▄▄▄▄▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄▄▄▄▄ ▄▄▄▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄▄▄▄▄ ▄▄▄ ▄▄▄ ▄▄▄▄▄ ▄▄▄▄▄▄ ▄▄▄ ▄▄▄ Copyright (C) 1992-1993, Armada Systems ▄▄▄ USER'S GUIDE AND REFERENCE MANUAL Release 2.03 ___________________________________________________________________________ This software is provided to you for evaluation use only. If you find the software useful, please register it. With your registration you will not only receive technical support and the latest version of software, but you will also be sponsoring the continued support and future enhancements of this product. ___________________________________________________________________________ MyBASE Intuitive, multipurpose database system. Program Serial No. 93124A0, Release 2.03 May 04, 1993 Changes are periodically made to the information herein; these changes will be incorporated in new editions of this publication. A Product Comment Form is provided at the front of this publication. If this form has been removed, you can mail any comments to the address below: Armada Systems P.O. Box 637, Station A Downsview, Ontario M3M 3A9 Canada Tel. (416) 889-2617 or (905) 889-2617 after October 4, 1993 MyBASE, DAS, DMM, PCM and DME are Trademarks of Armada Systems. Copyright (C) 1992-1993, Armada Systems All Rights Reserved. Made in Canada. For your records: NAME ____________________________ TITLE __________________________________ COMPANY _________________________ DEPARTMENT _____________________________ DATE PROGRAM RECEIVED ___________ OBTAINED FROM __________________________ TABLE OF CONTENTS PAGE ARMADA SYSTEMS LICENSE AGREEMENT .......................... i PRODUCT COMMENT FORM ...................................... ii GETTING STARTED ........................................... iii INSTALLING MyBASE ON HARD DISK iii DISK CONTENTS iv 1.0 MyBASE, WHAT IS IT? .................................. 1 1.1 QUICK OVERVIEW OF FEATURES 1 1.2 LOADING A DATABASE 2 1.3 USING MyBASE IN MICROSOFT WINDOWS 3 1.4 NETWORK INSTALLATION 4 1.5 IF YOU EXPERIENCE PROBLEMS 4 2.0 DATABASE BROWSE TABLE ................................ 5 2.1 FUNCTION KEYS 5 2.2 ALT+KEY FUNCTIONS 6 2.3 INSERTING, DELETING AND EDITING RECORDS 7 2.4 NAVIGATING THROUGH THE DATABASE 8 2.5 MEMO EDITOR 8 2.5.1 COMPRESSING MEMO FILES 9 3.0 DATABASE VIEW WINDOWS ................................ 10 3.1 VIEW WINDOW SETUP 10 4.0 FILTERING, SEARCHING AND REPLACING DATA .............. 12 4.1 DATABASE FILTER 12 4.2 LOCATE RECORDS IN DATABASE 12 4.3 SEARCH AND REPLACE DATA 12 4.4 ENTERING A FILTER, SEARCH OR REPLACE CONDITION 13 4.5 RELATIONAL OPERATORS 13 5.0 MERGING, PRINTING AND EXPORTING DATA ................. 14 5.1 PRINT DRIVER SETUP 14 6.0 CREATING AND MODIFYING A DATABASE STRUCTURE .......... 17 TABLE OF CONTENTS PAGE 7.0 SETUP AND UTILITIES .................................. 22 7.1 VIDEO DISPLAY SETUP 22 7.2 SET DATE FORMAT 22 7.3 TELEPHONE DIALING 22 7.4 SOUND (ON/OFF) 23 7.5 DELETED RECORDS (SHOW/HIDE) 23 7.6 STARTUP VIEW MODE (TABLE/RECORD) 24 7.7 COLUMN SPACING (NORMAL/TIGHT) 24 7.8 NETWORK MODE (SINGLE/MULTI-USER) 24 7.9 DATABASE SCREEN HEADING 24 7.10 DATABASE DIRECTORY SETUP 24 7.11 PASSWORD ACCESS 24 7.12 PACK DATABASE 25 7.13 ZAP DATABASE 26 7.14 MyBASE ORDER FORM 26 7.15 USER NOTES 26 7.16 SHELL TO DOS 26 APPENDIX A: MERGE PRINTING ................................. 27 APPENDIX B: OPERATORS ...................................... 35 APPENDIX C: CODE BLOCKS AND ARRAYS ......................... 37 APPENDIX D: FUNCTION REFERENCE ............................. 39 APPENDIX E: REGISTERING MyBASE ............................. 40 APPENDIX F: OTHER SOFTWARE FROM ARMADA SYSTEMS ............. 42 ARMADA SYSTEMS SOFTWARE REGISTRATION AND ORDER FORM ....... 46 MyBASE i ARMADA SYSTEMS LICENSE AGREEMENT ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Read this agreement carefully. Use or distribution of this product consti- tutes your acceptance of the terms and conditions of this agreement! GENERAL LICENSE TERMS This documentation and the software described in it are copyrighted with all rights reserved worldwide by Armada Systems. Under the copyright laws, neither the documentation nor the software may be copied, photocopied, reproduced, translated, modified, reverse engineered, or reduced to any electronic medium or machine readable form, in whole or in part, except as specifically authorized below, without the prior written consent of Armada Systems. Armada Systems specifically authorizes individuals and organizations to make complete unaltered copies of this software, for the purpose of free distribution to other individuals or organizations. This software and documentation may not be sold, no fee must be involved in the distribution of this software except, for a small reasonable fee to cover the cost of any distribution media and service charges. This software which consists of application programs, data files and documentation, are a complete entity which must not be separated or altered in any way shape or form. Individuals or organizations who wish to distribute or market this software for the purpose of financial or other material gain, must first receive the authorization to do so by contacting Armada Systems. Armada Systems authorizes the use of this software for non-commercial, educational, and evaluation purposes only. If you are using or intend to use this software for any other purposes, then you must register with Armada Systems by purchasing the commercial version of the software. Copying (except for back-up purposes) and distribution of software provided to registered users is not permitted. DISCLAIMER This documentation and the software described in it are provided "as is," without any warranty as to their performance, accuracy, or freedom from error, or as to any results generated through their use. Armada Systems excludes without limitation any and all implied warranties, including warranties of merchantability and fitness for a particular purpose. You assume the entire risk as to the results and performance of the software and documentation. Armada Systems will under no circumstances be liable for any direct, indirect, special, incidental, or consequential damages arising out of the use or inability to use the software or documentation, even if advised of the possibility of such damages. GENERAL Should you have any questions concerning this Agreement, you may contact Armada Systems by writing to the address given at the front of this manual. 2.03 - 93124A0 MyBASE ii PRODUCT COMMENT FORM ~~~~~~~~~~~~~~~~~~~~ Use this form if you have any comments or suggestions regarding the MyBASE program or this manual. Mail your comments to: Armada Systems P.O. Box 637, Station A Downsview, Ontario M3M 3A9 Canada NAME_________________________________ TITLE________________________________ COMPANY______________________________ DEPARTMENT___________________________ ADDRESS____________________________________________________________________ CITY_________________________________ STATE/PROVINCE_______________________ ZIP/POSTAL CODE______________________ COUNTRY______________________________ PHONE________________________________ FAX__________________________________ COMPUTER TYPE________________________ DOS VERSION__________________________ DATE PROGRAM RECEIVED________________ OBTAINED FROM________________________ COMMENTS/SUGGESTIONS: MyBASE iii GETTING STARTED ~~~~~~~~~~~~~~~ Before doing anything, it is suggested that you make a copy of the disk supplied to you. You should then keep the original disk as a back-up copy in a safe place where it will not come in contact with any heat, dust, or magnetic radiation. In the event that the copy is ever damaged or destroyed, you can always make a new copy from the original disk. INSTALLING MyBASE ON HARD DISK ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Although MyBASE does not necessarily require a hard disk to operate, as it will run off floppy disks, the performance may not be acceptable. It is therefore recommended that the program be installed on a hard disk as a minimum. To install MyBASE on a hard disk, do the following: 1. Boot-up DOS operating system (you should see the C> prompt appear on screen). 2. Insert MyBASE floppy disk into drive A. 3. Type the following: MD\MYBASE CD\MYBASE COPY A:*.* C: 4. To start using MyBASE, type the following: CD\MYBASE MYBASE MyBASE iv DISK CONTENTS ~~~~~~~~~~~~~ MYBASE.EXE - MyBASE program. MYBASE.HLP - Context sensitive help system. MYBASE.DBT MYBASE.PIF - Program Information File for running MyBASE in Microsoft Windows. MYBASE.ICO - Windows icon. MYBASE.TXT - This manual. MANUAL.EXE - Program to print this manual. *.MYB - Database configuration file. These are the files which MyBASE displays in the main database picklist menu. *.DBS - Database structure definition file. *.DBF - dBASE III compatible database file. *.DBT - Database memo file (for databases with memo fields only). *.MRG - Sample merge print files. PERMANENT FILES GENERATED BY MyBASE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ MYBASE.CFG - User configuration file for screen colors and print drivers. TEMPORARY FILES GENERATED BY MyBASE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~*.TMP - Index files and miscellaneous. BAK*.DB* - Database backup file created when database structure is modified or when packing memo files. MyBASE Pg. 1 1.0 MyBASE, WHAT IS IT? ~~~~~~~~~~~~~~~~~~~~~~~~ MyBASE is a very easy to use and extremely versatile multipurpose database system. With MyBASE you can easily define new ways of viewing your data on screen and in printed reports. MyBASE offers both indexing and filter methods for searching, grouping, browsing and retrieving selected data. You can build any type of index or filter you need to gain rapid-fire search and retrieval of data. MyBASE also features a fully programmable merge utility which will allow you to merge text and data as well as execute almost any type of external program. All automatically! 1.1 QUICK OVERVIEW OF FEATURES ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Items with an asterisk (*) denote new features for version 2.03. - Context sensitive and user customizable help system. Push F1 at any time to display or edit the help information which relates to the current task. * Ability to completely define your own database structure. This includes descriptive column headings, field edit validation, default field values, field edit functions/templates and execute/run functions which may be invoked by pushing Alt+E or Alt+R in the database browse table. The F2 key in the main file selection menu toggles between opening a database and creating/modifying a database structure. * Enhanced network support for multi-user systems. * Enhanced memory management and ability to shell to DOS (Alt+Z) or run external programs from within MyBASE with less than 8K of memory overhead. * Enhanced error management and error recovery. - Database specific, three level password access system. Each database maintains it's own independent password access system which may be turned ON or OFF. To set passwords, push F9 and select 'Password access'. - Quick and simple way of defining new ways of looking at data. Unique view windows may be defined for each database. The view windows will control how the data will be displayed on screen and in printed reports. To define your own view windows, push F2 and select 'Setup...'. * View data in table or record view mode (F3/TAB toggles between modes). * Merge print function to allow merging of text from an external text file with data from the database. Commands may be embedded in the external merge file to control how records and data are processed, where the output is sent to, and what external procedures to call (ex. DOS func- tions, word processors, FAX software, label printers, and so on). MyBASE Pg. 2 - User configurable print drivers (push F8 and select 'Setup...'). Export data to printer or a DBF or ASCII delimited file. The ability to export data to a file is extremely useful since the exported data will be based on the current database view and filter conditions which you have set (ie. what you see is what you get). The exported data may then be imported into a word processor, spreadsheet, desktop publishing package, telecommunications or fax software, etc... - Tag individual records for printing, merging or replacing (push F4). - Filter database to display or print a group of selected data (push F5). - Skip through database, searching for specific data (push F6). - Quick, database wide, search and replacement of data (push F7). - For each database record, you may attach, display, edit, import and export free-form notes which may be as large as 64K bytes in size each. - Copy (Alt+C/Alt+O) and paste (Alt+P) data for faster data input. - Automatically dial a telephone number (ALT+D). - Count number of records displayed and calculate totals and averages for a column (Alt+S). - Customize screen colors (push F9). * Enhanced video support for displaying more data on screen (push F9). - Change the date format (push F9). * Turn sound on or off (push F9). - Display or hide records marked for deletion (push F9). - NOTE: MyBASE is continually updated and refined. The version of MyBASE which you currently have may not be the latest version. To obtain the latest version, please send your order form and registration to Armada Systems (push F9 and select "MyBASE order form"). 1.2 LOADING A DATABASE ~~~~~~~~~~~~~~~~~~~~~~~ A database may be loaded into MyBASE in one of two ways: (1) Directly from the command line. For example, to open the "CONTACT" database, type the following: C:\MYBASE\MYBASE C:\MYBASE\CONTACT MyBASE will open the database automatically, bypassing the database picklist menu. MyBASE Pg. 3 NOTE: A second parameter may also be specified when a database is loaded from the command line. The second parameter will tell MyBASE where to create temporary files. For example, to open the "CONTACT" database and use to use D:\TEMP\ for any temporary files, type: C:\MYBASE\MYBASE C:\MYBASE\CONTACT D:\TEMP\ (2) Through a database picklist menu. This is the default method and it will display to you a complete list of database configuration files (files with extension MYB) which are found in the specified directory. (a) To display a list of all databases which are found in the current directory, type: C:\MYBASE\MYBASE (b) To display a list of all databases in a different subdirectory, for example in; C:\MYBASE\DATA, type: C:\MYBASE\MYBASE C:\MYBASE\DATA\ Note: a subdirectory name must end with a backslash "\". Use the cursor keys to select a database file and push ENTER to open it. To exit MyBASE, push ESC, ALT+X or F10. 1.3 USING MyBASE IN MICROSOFT WINDOWS ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Although MyBASE is not a true windows application, it may nevertheless be installed to run under Windows. MS Windows 3.x can operate in standard and 386 enhanced modes. However, the modes in which your Windows system may operate in, are restricted by the amount of RAM and type of processor installed in your computer. If you have an Intel 80386 processor or higher and at least 2MB of memory, you can run Windows in the 386 enhanced mode. This mode will allow you to run MyBASE in a window, with full multitasking capabilities. If you cannot run Windows in the 386 enhanced mode, then you will only be able to run MyBASE in full- screen mode. You will also not be able to run any other tasks in the back- ground while you are using MyBASE. To simplify the Windows setup procedure, a Windows 3.0 PIF file has been included with the MyBASE distribution package. The PIF file assumes that you have installed MyBASE in subdirectory, "C:\MYBASE". If this is not the case, then you may edit the MYBASE.PIF file using the Windows PIF Editor. Consult your Windows User's Guide if you are unsure of how to do this. MyBASE Pg. 4 To install MyBASE in Windows 3.x, do the following: 1. Start Windows. 2. Select the program group where you would like to install MyBASE. 3. Select 'File, New' menu option in Program Manager. 4. Select 'Program Item', click 'OK'. 5. Type "MYBASE" in 'Description' block. 6. Type "C:\MYBASE\MYBASE.PIF" in 'Command Line' block. 7. If you would like to change the icon, select 'Change Icon'. 8. When finished, click on 'OK'. To start MyBASE from Windows, position your mouse pointer on the MyBASE Windows icon, and double-click the mouse button. 1.4 NETWORK INSTALLATION ~~~~~~~~~~~~~~~~~~~~~~~~~ If you have a multi-user version of MyBASE, you may install it on a network. To install MyBASE on a network server, simply copy all files named "MYBASE.*" to the server. Then change the file attribute of MYBASE.EXE to read only. At the DOS prompt, type: ATTRIB +R MYBASE.EXE 1.5 IF YOU EXPERIENCE PROBLEMS ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ In many cases, problems which you experience while running MyBASE may be a direct result of incompatibilities between MyBASE and disk caching software or other memory resident programs. To test if this is the case, boot your computer with no disk caching or memory resident programs loaded, then run MyBASE. If the problem disappears, then you can be 100% certain that one of the memory resident programs is the culprit. If the problem remains, then please let Armada Systems know of the problem. Use the Product Comment Form included at the front of this publication to let Armada Systems know of any problems that you experience. This information is extremely valuable in allowing Armada Systems to better improve the product in the future. As an incentive for sending in those problem reports, all registered users who are first to submit to Armada Systems a unique problem, will receive a free upgrade once the problem is fixed. If you send a problem report to Armada Systems, please try to be as detailed as possible. Keep in mind that a problem which cannot be duplicated, cannot be fixed. Be sure to include details such as the type of computer, hard disk, amount of memory, DOS version, EMS drivers, size of RAM disk if used, and most importantly the steps required to recreate the problem. MyBASE Pg. 5 2.0 DATABASE BROWSE TABLE ~~~~~~~~~~~~~~~~~~~~~~~~~~ The database browse table is the screen displayed when a database is loaded into MyBASE. The columns of this table are called database fields. The type of data which may be entered into a column is controlled by the field type of the column. Five types of fields are possible: * Character: Fixed length fields which may hold any alpha-numeric data. * Numeric: These fields are used to store numbers only. Totals and averages may be calculated for numeric fields. * Date: These fields are only used for storing dates. Column averages may be calculated for date fields. * Logical: Logical fields are used for storing binary data such as True/False or Yes/No. * Memo: Variable length fields which may be as large as 64K bytes in size. They may hold any alpha-numeric data. 2.1 FUNCTION KEYS ~~~~~~~~~~~~~~~~~~ F1 - Help Display/Edit context sensitive help. F2 - NewView Select new database view window. View windows allow viewing and printing of the database in different ways. To create a view window, select 'Setup...' in the view window picklist. F3, TAB - Table Toggle between table and record view modes. F4 - TagRec√ Tag current record for printing or for search and replace. If current record is already tagged, pushing this key will untag it. ** To clear all tags in the database, push: SHIFT+F4. F5 - SetFilter Enter a database filter. When a database filter is in use, only those records which match the specified condition will be displayed and/or printed. ** To clear the filter condition, push: SHIFT+F5. F6 - Find Enter a database search condition to locate specific data. ** To find the next record, push: SHIFT+F6. MyBASE Pg. 6 F7 - Replace Assign new data to the current field. The replace operation will be performed on each record matching the specified scope or condition. F8 - Print Print report, merge file or export data to an ASCII or DBF file using current index and filter conditions (ie. same as screen). F9 - Util+ MyBASE setup, utilities, and order form. F10, ALT+X - Quit Close current database and return to main database menu. 2.2 ALT+KEY FUNCTIONS ~~~~~~~~~~~~~~~~~~~~~~ ALT+S - Field statistics Count number of records displayed and determine column totals and averages. ALT+C, ALT+O - Copy Copy currently displayed record into copy/paste buffer. NOTE: * Only the displayed fields (columns) are copied to the buffer. * The copy buffer is cleared each time the database view is changed. ALT+P - Paste Paste data from the copy/paste buffer to the current record. If a new record is being appended, then the paste function will update all fields (columns). If however, an existing record is being edited, then the paste operation will only update the current field (column). ALT+D - Dial telephone number Dial telephone number located at the current cursor position. To use this function, you will need a modem connected your computer and telephone. To customize the settings of the telephone dialer, select 'Telephone dialing' in the 'F9-Util+' menu. ALT+E, ALT+R - Execute/Run function. Execute or run the function which has been defined in the database structure table for the current field. For example if the current field contains the name of a graphics file, a function may be defined to view this file on screen whenever the ALT+E or ALT+R keys are pushed. ALT+Z - Shell to DOS. MyBASE Pg. 7 2.3 INSERTING, DELETING AND EDITING RECORDS ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ INS - Toggle append mode. DEL - Toggle deleted status of current record. A deleted record will be flagged in the first column with a 'm' character. Records flagged as deleted, may be permanently removed from the database by selecting 'PACK database' in the 'F9-Util+' menu. ESC - Refresh screen, cancel append. BEFORE ENTERING EDIT MODE: ENTER - Enter edit mode. If the field is empty and a default value has been defined in the database structure file, then the default value will be shown. If the default value is an array, then a popup selection box will be displayed of available choices. NOTE: To automatically select the first item in an array, push CTRL+ENTER. CTRL+ENTER - Replace contents with default value. If the field is empty and the default value is an array, then automatically select the first item in the array. If the field is NOT empty and the default value is an array, then display a popup selection box of available choices. IN EDIT MODE: ESC, F10 - Cancel edit, don't save changes. CTRL+T - Delete one word to the right. CTRL+Y - Delete rest of line. F6 - Search database. Note: Once a match is found, the search may be continued by pushing Alt+F6. CTRL+ENTER - Add 7 days to current date (in DATE fields only). ENTER - Save changes, quit edit. MyBASE Pg. 8 2.4 NAVIGATING THROUGH THE DATABASE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ TABLE VIEW MODE UP/DOWN - Move up/down one record. LEFT/RIGHT - Move left/right one field. HOME/END - Jump to first/last field on screen (current record). CTRL+HOME - Jump to first field in current record. CTRL+END - Jump to last field in current record. PGUP/PGDN - Scroll up/down one screen CTRL+PGUP - Goto first record in database (top of list). CTRL+PGDN - Goto last record in database (bottom of list). RECORD VIEW MODE UP/DOWN - Move up/down one field. LEFT/RIGHT - Goto to previous/next record. CTRL+LEFT - Goto first record in database. CTRL+RIGHT - Goto last record in database. PGUP/PGDN - Scroll up/down one screen. CTRL+PGUP - Jump to first field (same record). CTRL+PGDN - Jump to last field (same record). 2.5 MEMO EDITOR ~~~~~~~~~~~~~~~~ The memo editor allows editing variable length, free-form database character fields, called MEMO fields. All the memo fields in a database are stored in a separate file with the extension '.DBT'. Each memo record may be up to 64K bytes in size, and the entire DBT file may be as large as 16M bytes. FUNCTION AND EDIT KEYS: F1 - Display/edit context sensitive help. F2, Ctrl+B - Reform paragraph F3 - Print today's date. F4 - Print current time. F5, Ctrl+Y - Delete current line. F6, Ctrl+T - Delete one word to the right. F7 - Append memo from a disk file. F8 - Print memo to disk file or printer. F9, Ctrl+W - Save changes and exit the memo editor. F10, Esc - Quit without saving changes. Ins, Ctrl+V - Toggle insert mode. Del - Delete character at cursor. Backspace - Delete character to left of cursor. Return - Move to beginning of next line. ALT+D - Dial telephone number located at current cursor position. ALT+Z - Shell to DOS. MyBASE Pg. 9 NAVIGATION KEYS: Up/Down - Move up/down one line. Left/Right - Move left/right one character. Ctrl+Left/Ctrl+Right - Move left/right one word. Home/End - Move to beginning/end of current line. Ctrl+Home/Ctrl+End - Move to top/end of current window. PgUp/PgDn - Move up/down one window. Ctrl+PgUp/Ctrl+PgDn - Move to beginning/end of memo. 2.5.1 COMPRESSING MEMO FILES ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ For data portability reasons, memo databases created in MyBASE have been designed to be fully compatible with the dBASE III standard. This format however does not provide a mechanism for reusing old space in the file. Consequently, as memo fields are edited, the old space in the memo (DBT) file is not recycled, which causes the memo file to increase in size each time data is saved to the file. If you perform a lot of editing on memo fields and you notice that the memo (*.DBT) file is getting too large, then you may compress this file by selecting PACK in the Setup and Utilities menu (push F9-Util+). MyBASE Pg. 10 3.0 DATABASE VIEW WINDOWS ~~~~~~~~~~~~~~~~~~~~~~~~~~ A new view window will allow you to look at the database in a different way. A view window controls how the database is indexed and how the database fields are displayed on screen and in printed reports. Up to 32 different view windows may be defined. To define a new view window or to make changes to an existing one, select 'Setup...'. To make a selection, use the cursor keys to position the cursor on the appropriate window title, and push ENTER. To abort selection push ESC. 3.1 VIEW WINDOW SETUP ~~~~~~~~~~~~~~~~~~~~~~ This is a very powerful utility which will allow you to easily customize up to 32 different ways of viewing the database. Here, you may define new ways of indexing the data and specify how fields are displayed on screen and in printed reports. VIEW No. View window number. Up to 32 different view windows are possible, range 00-99. The first view window will be the one used at start-up. After making changes to the view numbers, you may sort the display by pushing F2. UNIQUE INDEX When checked (√), it is used to indicate that only unique index key records will be displayed and/or printed in reports. To toggle ON/OFF, push the space bar. VIEW WINDOW TITLE AND SCREEN HEADING This will be the window title displayed on screen. The window titles are also used in the pop-up selection list, which is displayed when the F2 NewView key is pushed. FIELD NAME A listing of all fields (columns) in the current database. VIEW ORDER Indicates the order by which the displayed (SHOW IT) fields will be listed on screen and in reports. SHOW IT When checked (√), the field will be displayed in the current view window. To toggle ON/OFF, push the space bar. INDEX ON IT When checked (√), this field will be used for indexing the database. Note that if 2 or more fields are checked, the index key will be based on the VIEW ORDER by which the fields are listed. Note also that you may index on a field which is not SHOWN. To toggle ON/OFF, push the space bar. MyBASE Pg. 11 VALID KEYS ARROW KEYS - Move up/down, left/right. SPACE BAR - Toggle ON/OFF (√/φ). F1 - Help (this screen). F2 - Sort display by view window number F3, TAB - Move cursor to next window. F4, DEL - Reset or delete current view window. F10, ALT+X - Exit view window setup screen. At this point you may elect to permanently save your changes to disk. NOTE: Even if you do not save your changes to disk, they will still remain in effect while the current database is open. Once the database is closed however, these changes will be lost! MyBASE Pg. 12 4.0 FILTERING, SEARCHING AND REPLACING DATA ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 4.1 DATABASE FILTER ~~~~~~~~~~~~~~~~~~~~ A database filter will allow you to display or print only those records in the database which satisfy the filter condition. For example, in a database of customer addresses, if the filter is set to; CITY = 'TORONTO', then only those customers from the city of Toronto will be listed, on screen and printed reports. NOTE: If a record is edited while a filter is active, and after editing the record no longer satisfies the filter condition, that record will seem to disappear. In fact, the edited record is still in the database, however, since it no longer satisfies the filter condition, it is hidden. To clear a filter condition, push; SHIFT+F5. 4.2 LOCATE RECORDS IN DATABASE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ This function will allow you to locate all the records in the database which meet the specified search condition. Once a search condition is entered, the database will be scanned, starting at the top of the list, for a record which meets the required condition. If the search is unsuccessful, the cursor will be positioned to the bottom of the list. If a record is found which satisfies the search condition, then the cursor will be positioned on this record. To continue the search from the current record to the end of the list, push; SHIFT+F6. NOTE: Only the visible records are searched, so if a filter is active and some records are hidden, then the hidden records will not be processed. 4.3 SEARCH AND REPLACE DATA ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ This function will allow you to assign new data to the current field throughout the entire database. The replace operation will be applied to each database record that matches the scope or condition you specify. To perform the search and replace operation on the current field, type in the new field value, push ENTER, and then select one of the following scope or replace conditions: MyBASE Pg. 13 TAGGED √ - apply change to all visible tagged records. CURRENT CONDITION - use last entered replace condition. ENTER CONDITION - enter a new replace condition ALL RECORDS - apply change to all visible records. CANCEL - quit with no change. NOTE: Only the visible records are searched, so if a filter is active and some records are hidden, then the hidden records will not be processed. 4.4 ENTERING A FILTER, SEARCH OR REPLACE CONDITION ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ To enter a new filter, search or replace condition, do the following: 1. Select a field. 2. Select a relational operator; =, $, >, <, >=, <=, <> 3. Enter the desired field value. For your convenience, MyBASE will display the field value of the current database record, this value may be edited. 4. Select <END> if finished, or a logical operator; .OR., .AND. If a logical operator is selected, continue as in step 1. Push ESC any time to return to the database with no changes. As an expression is entered, it will be displayed at the bottom of the popup window under the heading NEW EXPRESSION. An expression which is currently in use, will be displayed under the heading CURRENT EXPRESSION. NOTE: The maximum length of a filter, search or replace condition is 250 characters, expressions longer than this will be truncated. 4.5 RELATIONAL OPERATORS ~~~~~~~~~~~~~~~~~~~~~~~~~ A = B A is equal to B 'CANADA' = 'CANADA' A $ B A is contained in B 'SMITH' $ 'MR. E. SMITH' A > B A is greater than B 12.5 > 10.1 A < B A is less than B 'SHORT' < 'TALL' A >= B A is greater than or equal to B 1993/12/23 >= 1992/12/23 A <= B A is less than or equal to B 'TO' <= 'TORONTO' A <> B A is not equal to B 'SILLY' <> 'GOOD' MyBASE Pg. 14 5.0 MERGING, PRINTING AND EXPORTING DATA ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Printed outputs are based on the current database view and filter conditions which you have set. Outputs may be directed to either a printer or an ASCII or DBF disk file. SELECT PRINT DRIVER Select the appropriate printer driver that you wish to use. To make changes to the print drivers, select 'Setup...'. PRINT ONLY TAGGED RECORDS (√) If you have tagged any records by pushing F4 in the database table, then the program will ask if you want to print only those records which have been tagged. If you answer NO, then all records displayed in the database table will be printed. CANCEL PRINT Printing may be canceled at any time by pushing ESC. 5.1 PRINT DRIVER SETUP ~~~~~~~~~~~~~~~~~~~~~~~ This utility will allow you to create custom print drivers for both physical printers as well as disk files. PRINT DRIVER NAME ~~~~~~~~~~~~~~~~~ This is a listing of all the currently defined print drivers. Select the print driver you wish to change by using the UP/DOWN cursor keys. - To edit the printer title push ENTER. - To change the print driver type, use the LEFT/RIGHT cursor keys. - To change the printer options, push F3 or the TAB key, the cursor will move to the lower part of the screen. PRINT DRIVER TYPE ~~~~~~~~~~~~~~~~~ * REPORT (default file extension .PRN) Reports will look similar to your screen display and may be directed to either a printer or disk file. In addition you may specify print formatting commands in the OPTIONS box. * FILE MERGE This print driver type will allow you to merge text from an external merge file with data from the database. The merge file will contain both text and commands. All commands must be enclosed in angled brackets, example: < DATE() >. When this command is encountered it will simply print the system date. MyBASE Pg. 15 Data from the database may be merged with text in the merge file by simply enclosing a database field name in the angled brackets; example: < NAME > You may also perform calculations; example: < AMT_BILLED - AMT_PAID > or conditions; example: < IF(AMT_OWING == 0, "Thank-you.", "Pay now, or else!") > In addition, commands may be embedded in merge files to control how records and data are processed, where the output is sent to, and what external procedures to call (ex. DOS functions, word processors, FAX software, label printers, and so on). For more information, consult the appendix section at the end of this manual. * ASCII (default file extension .TXT) This format is used to export data from your database for use in other software programs which do no support the DBF format. Records are variable length, each separated by a CR+LF. Fields are variable length and separated by commas. Character strings are enclosed in quotation marks. Leading and trailing spaces for character and numeric fields are truncated, date fields are written in the form YYYYMMDD, and logical fields are written as T or F. Example: "Character",12.30,19931225,T * DBF (default file extension .DBF) This format is used to copy the entire database or a select group of records, in the index order, to a secondary database file. OPTIONS ~~~~~~~ * Merge file: Here you may enter either the name of a merge file, or a file filter such as *.MRG to list a group of merge files located on disk which you may later select from. * Output to: Printed outputs may be directed to either a physical printer or a disk file. PRN is the default DOS printer, LPT1/2/3 are parallel ports, COM1/2 are serial ports. * Columns/line: This number is used to indicate the maximum number of columns printed on each line. The program will automatically truncate any lines which are longer than this maximum. If you do not want output truncated, then enter a value of 0. MyBASE Pg. 16 * Lines/page: This number is used to indicate the maximum number of lines printed on each page. A title is printed at the top of each page. To create a continuous form report, with a title only at the beginning of the report, enter a value of 0. * Printer setup/reset strings: These character strings are sent to the printer at the start/end of printing. The intent is to setup the printer (select font, page orientation, margins, etc...) at the start of printing and to reset it when printing is completed. ASCII characters in the range [0-255] may be entered. To enter a numeric ASCII value push ALT+A. * Record start/end strings: These character strings are sent to the printer at the beginning/end of each database record. ASCII characters in the range [0-255] may be entered. To enter a numeric ASCII value push ALT+A. MyBASE Pg. 17 6.0 CREATING AND MODIFYING A DATABASE STRUCTURE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ FIELD NAME ~~~~~~~~~~ These will be the columns of the new database, try to be as descriptive as possible. Field names must be unique, begin with an alphabetic character, and can not contain blank spaces between characters. TYPE ~~~~ Push the space bar or one of the following letters: C,N,D,L,M to select a field type. * Character: Fixed length fields which may hold any alpha-numeric data. * Numeric: These fields are used to store numbers only. Totals and averages may be calculated for numeric fields. * Date: These fields are only used for storing dates. Column averages may be calculated for date fields. * Logical: Logical fields are used for storing binary data such as True/False or Yes/No. * Memo: Variable length fields which may be as large as 64K bytes in size. They may hold any alpha-numeric data. LENGTH ~~~~~~ Date, logical, and memo fields have preset lengths. Character and numeric are the only field types where the length may be set by the user. For numeric types, the field length includes all digits and decimal point if any. DECIMALS ~~~~~~~~ Number of decimal spaces for numeric fields. For example the number "12.3456" would have: LENGTH = 7, and DECIMALS = 4. FIELD COLUMN HEADING ~~~~~~~~~~~~~~~~~~~~ Here you may enter a more descriptive title for the current field. To create multi-line headings use the semicolon (;) character. MyBASE Pg. 18 EDITABLE ~~~~~~~~ √ - allow editing to current field. · - do not allow editing to this field. Push the space bar to toggle ON/OFF. EDIT PICTURE TEMPLATE ~~~~~~~~~~~~~~~~~~~~~ Picture templates are used to define the formatting of fields for editing. Two mechanisms are available to control formatting: functions and templates. Functions apply to the entire field, while templates format characters position by position. FUNCTION STRING: The function string consists of the @ character, followed by one or more additional characters, each having a particular meaning. If a function string is present, the @ character must be the left-most character of the picture string, and the function string must not contain spaces. A function string may be specified alone or with a template string. If both are present, the function string must precede the template string, and the two must be separated by a single space. FUNCTION TYPE ACTION A C Allows only alphabetic characters B N Displays numbers left-justified C N Displays CR after positive numbers D D,N Displays dates in current date format E D,N Displays dates in British format K all Deletes default text if first key is not a cursor key R C Non-template characters are inserted but not saved S<n> C Allows horizontal scrolling. <n> is an integer that specifies the width of the region X N Displays DB after negative numbers Z N Displays zero as blanks ( N Displays negative numbers in parentheses with leading spaces ) N Displays negative numbers in parentheses without leading spaces ! C Converts alphabetic characters to upper case TEMPLATE STRING: The template string specifies formatting or validation rules on a character by character basis. Each position in the template string corresponds to a position in the displayed field. Characters which do not have assigned meanings are copied verbatim into the displayed field. If the @R function is used, these characters are inserted into the display, but are not saved when editing is complete. MyBASE Pg. 19 TEMPLATE ACTION A Allows only alphabetic characters N Allows only alphabetic and numeric characters X Allows any character 9 Allows digits for any data type, including sign for numerics # Allows digits, signs, and spaces for any data type L Allows only T,F,Y, or N Y Allows only Y or N ! Converts an alphabetic character to upper case $ Displays a dollar sign in place of a leading space in a numeric * Displays an asterisk in place of a leading space in a numeric . Displays a decimal point , Displays a comma Example: @KS10 !XXXXXXXXX PRE-EDIT VALIDATION ~~~~~~~~~~~~~~~~~~~ Pre-edit validation specifies a condition which must be satisfied before the user will be allowed to edit the current field. The condition may be specified either as a simple function or as a more complicated code block which returns a logical value. The field's current value will be passed to a code block as a parameter. If the value returned by the function or code block is true, the user will be allowed to enter edit mode, example: AMT_OWING > 0 .AND. DATE()-INV_DATE > 90 This example will only allow edit to the current field if the AMT_OWING is greater than zero and the INV_DATE is more than 90 days old. Please consult the appendix at the end of this manual for a listing of available functions and a description of code blocks. POST-EDIT VALIDATION ~~~~~~~~~~~~~~~~~~~~ Post-edit validation specifies a condition which must be satisfied before the user will be allowed to exit field edit. The condition may be specified either as a simple function or as a more complicated code block which returns a logical value. The field's current value will be passed to a code block as a parameter. If the value returned by the function or code block is true, the user will be allowed to leave edit mode, example: {|x| field->FOLLOW_UP := x+28, .T.} MyBASE Pg. 20 Assuming we are editing a date field, say the date last called, this example will add 28 days to the date which was entered and store the value in the FOLLOW_UP field. The user will then be allowed to exit edit mode since the last value returned by the code block is a logical true (.T.). Please consult the appendix at the end of this manual for a listing of available functions and a description of code blocks. DEFAULT VALUE ~~~~~~~~~~~~~ If a default value is specified, this value will be assigned to the field whenever a new record is appended to the database or when the user pushes ENTER on a blank field. If the field is not blank, the user may assign it the default value by pushing CTRL+ENTER prior to entering edit mode. For character fields (type: C), you may specify an array of character items which will cause a popup selection box to be displayed whenever the user edits this field. For example, in a COUNTRY field you may have: {"Canada", "U.S.A.", "U.K.", "France", "Germany", "Italy"} This example will display a popup selection box, allowing the user to select one item. Please consult the appendix at the end of this manual for a listing of available functions and a description of code blocks and arrays. EXECUTE/RUN FUNCTION ~~~~~~~~~~~~~~~~~~~~ Create a function or code block which will be executed when the ALT+E or ALT+R keys are pushed. Examples may include calling external programs such as DOS functions, file viewers, word processors, spreadsheets, graphics viewers, FAX software, and so on. The field's current value will be passed to a code block as a parameter, example: {|x| if(empty(x), NIL, run('q '+x, 96)) } When this function is executed, it will first check if the field (x) where the cursor is currently positioned contains any information, if it does, then it will try to make available 96K of memory and execute the editor (q) which will open file (x). Once you exit the editor, you will be returned back to MyBASE. Please consult the appendix at the end of this manual for a listing of available functions and a description of code blocks. MyBASE Pg. 21 COPYING STRUCTURE FROM EXTERNAL FILE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ A database structure may be copied from an existing database structure file (extension .DBS) or an existing database file (extension .DBF). To copy the database structure, push F2-CopyFrom. NOTE! When a database structure is copied from an external file, all data currently displayed will be lost! MyBASE Pg. 22 7.0 SETUP AND UTILITIES ~~~~~~~~~~~~~~~~~~~~~~~~ 7.1 VIDEO DISPLAY SETUP ~~~~~~~~~~~~~~~~~~~~~~~~ This utility will allow you to customize the video screen size and colors. To make changes, use the up/down cursor keys to move the pointer to the color which you want to change. To change the foreground (text) color press the (+) key, to change the background color press the (-) key. To toggle the foreground color intensity press the (*) key, to toggle the background color intensity press the (/) key. Typical screen sizes are 25x80 (CGA), 43x80 (EGA), 50x80 (VGA). Your monitor may also support other screen sizes, please check with your hardware documentation. If you select a screen size which is not supported by your hardware, the screen will remain in the current mode. When finished, push ESC, ALT+X or F10. At this point, you may choose to save or discard any changes which have been made. 7.2 SET DATE FORMAT ~~~~~~~~~~~~~~~~~~~~ Select the date format that you wish to display on screen and in printed reports. A number of different data formats are available. 7.3 TELEPHONE DIALING ~~~~~~~~~~~~~~~~~~~~~~ If your computer and telephone are connected to a modem, you may use the telephone dialer to automatically dial a telephone number which is displayed on screen. To use this function, position the cursor on or near the desired phone number, push ALT+D, and pickup the telephone receiver. The setup screen will allow you to customize the telephone dialer. Modem commands specified below will work with most Hays (tm) compatible modems. Your particular modem may be different, so consult your modem's user manual for a complete list of commands. MODEM START DIAL STRING ~~~~~~~~~~~~~~~~~~~~~~~ This is the character string which will be sent to the modem before dialing the actual telephone number. The default is: +++ATDTW This instructs the modem to switch to command mode (+++), and get ready to dial (ATD) a number in tone mode (T) after hearing a dial tone (W). MyBASE Pg. 23 MODEM END DIAL STRING ~~~~~~~~~~~~~~~~~~~~~ This character string will be sent to the modem at the end of the telephone number. The default is: ;H S0=0 This instructs the modem to return to command state (;), hang up (H) and turn off auto-answer (S0=0). VALID TELEPHONE NUMBER CHARACTERS ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ When you push ALT+D, MyBASE will scan the current line where the cursor is positioned, looking for a valid telephone number. If more than one valid telephone number is found, the one closest to the cursor will be selected and dialed. You may specify what characters will be accepted as being part of the telephone number. The default characters are: 0123456789#*ABCD,TPW@!;( )- |--------------||-----||--| | | | | | +- character separators, ignored by modem | +------- dial modifiers, see below +------------------ digits/characters for dialing The following are some of the most common dial modifiers used by modems: T - switch to tone dialing. P - switch to pulse dialing. , - pause for 2 seconds before proceeding. W - wait for dial tone before proceeding. @ - wait for 5 seconds of silence before proceeding. ! - issue hookflash signal (hangup for 0.5 seconds then reconnect) ; - return to command state after dialing. The following example illustrates use of several modifiers: ATDT 9,765 4321!,#0 1234;H This command line instructs the modem to use tone dialing to access a number outside a PBX, pause before dialing, dial the number 765 4321, enter a hookflash, pause, and issue the PBX transfer code #0 before dialing the extension number 1234, then return to command state and hang up. If the telephone is off hook, the call will now be switched to voice. USE SERIAL PORT ~~~~~~~~~~~~~~~ Select the serial port that your modem is connected to. You may use either COM1 or COM2. Position the cursor on the desired serial port, and push ENTER to select. MyBASE Pg. 24 7.4 SOUND (ON/OFF) ~~~~~~~~~~~~~~~~~~~ Push ENTER to toggle use of sound ON or OFF. 7.5 DELETED RECORDS (SHOW/HIDE) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Push ENTER to toggle display of deleted records ON or OFF. If deleted records are displayed, then they will be flagged with a 'φ' character in the first column. 7.6 STARTUP VIEW MODE (TABLE/RECORD) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Push ENTER to toggle the default view mode when a database is loaded. The view mode may also be changed by pushing F2 or TAB. 7.7 COLUMN SPACING (NORMAL/TIGHT) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Push ENTER to toggle the default column spacing. Using NORMAL spacing, columns are separated by a thin line and one blank space. Using TIGHT spacing, columns are separated by a single thick line, leaving more space for data. 7.8 NETWORK MODE (SINGLE/MULTI-USER) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Push ENTER to toggle the mode used to open databases. Either shared for multi-user use or non-shared for single user use. Use of this utility is restricted to users with access level "ALL". NOTE: This option is only available on multi-user versions of MyBASE. 7.9 DATABASE SCREEN HEADING ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Enter a descriptive title for the current database. This title will be displayed on top of the screen whenever this database is loaded in the future. 7.10 DATABASE DIRECTORY SETUP ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Enter the DOS paths of the database and temporary files. If a RAM disk is available, then for improved performance, you may set the temporary file path to the RAM disk. Each database maintains it's own independent DOS file paths, so making changes here will not affect other databases. In many cases in fact, it may be more practical to store a database in it's own directory. MyBASE Pg. 25 NOTE: For a DOS path to be accepted it must; (a) already exist and, (b) end with a backslash (\), for example; C:\MYBASE\ Temporary files created by MyBASE are normally deleted when you exit MyBASE. However, if you reset your system while in MyBASE or if MyBASE terminates abnormally, these temporary files will not be deleted. In this case you may erase any files of the following format: '~*.TMP' once you return to DOS. 7.11 PASSWORD ACCESS ~~~~~~~~~~~~~~~~~~~~~ Edit the passwords for the current database and turn password access ON or OFF. Use of this utility is restricted to users with access level 'ALL'. Access to databases may be restricted to only users who have a valid password. Each database has it's own independent password access system, so making changes here will not affect other databases. Three password access levels are available: READ, READ/WRITE, and ALL. READ: Will allow users to browse the database, but will not allow any changes to be made to either the database or any MyBASE configuration functions. READ/WRITE: Will allow users to browse and edit the database and make changes to all MyBASE configuration functions, except for the password system. ALL: This is the highest access level. Users with this password access are not restricted from performing any function whatsoever in MyBASE. This access level is required to make changes to the password system! DATABASE PASSWORD ACCESS ON/OFF: Password access to this database may be turned ON or OFF. If it is turned ON, users will be required to enter a password each time they access the database. If it is OFF, a password will not be required to access the database and the user will automatically be given access level "ALL". 7.12 PACK DATABASE ~~~~~~~~~~~~~~~~~~~ This function will permanently remove all records in the current database which have been marked for deletion! Records which have been marked for deletion, are flagged in the first column of the database browse table with a 'φ' character. This function will also compress memo files in order to reclaim the old space in a memo (*.DBT) file. MyBASE Pg. 26 7.13 ZAP DATABASE ~~~~~~~~~~~~~~~~~~ This function will permanently delete all records in the current database! Use of this utility is restricted to users with access level "ALL". 7.14 MyBASE ORDER FORM ~~~~~~~~~~~~~~~~~~~~~~~ Place an order for the latest version of MyBASE (see Appendix "E"). 7.15 USER NOTES ~~~~~~~~~~~~~~~~ Here's a place to store your own notes... 7.16 SHELL TO DOS ~~~~~~~~~~~~~~~~~~ Swap MyBASE to either EMS, XMS or disk and shell to DOS. To return to MyBASE, type EXIT. APPENDIX A MyBASE Pg. 27 APPENDIX A: MERGE PRINTING ~~~~~~~~~~~~~~~~~~~~~~~~~~ Merge printing involves merging text from an external merge file with data from a database. In order to accomplish this, the merge file must contain commands or functions which reference information in the database. All such commands and functions must be enclosed in angled brackets. For example, the following function will print the system date: < DATE() > Data from the database may be merged with text in the merge file by simply enclosing a database field name in the angled brackets; example: < NAME > You may also perform calculations; example: < AMT_BILLED - AMT_PAID > or conditions; example: < IF(AMT_OWING == 0, "Thank-you.", "Pay now, or else!") > In addition, commands may be embedded in merge files to control how records and data are processed, where the output is sent to, and what external procedures to call (ex. DOS functions, word processors, FAX software, label printers, picture file viewers, and so on). A sample merge file is included on the proceeding page. It shows how you may merge and fax personalized documents to multiple destinations. This merge file first creates the document and then calls an external program (BITFAX (tm) for DOS) to fax the document via a fax/modem. Although in this example BITFAX is used for transmitting, other fax software may work equally as well. There are additional sample merge files (to create letters, envelopes and reports) included with MyBASE. All of these merge files have a file name extension ".MRG". NOTE: ~~~~~ (a) If you need to use an angled bracket literally, precede it with a backslash character (\), as in: < LOCATE( "FOLLOW_UP \>= DATE()" ) > (b) The maximum length of a merge file is 65,519 bytes. APPENDIX A MyBASE Pg. 28 SAMPLE MERGE FILE: MERGE AND FAX ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 01: <# _Date := CMONTH(DATE()) +" "+ ALLTRIM(STR(DAY(DATE()))) 02: +","+ STR(YEAR(DATE())) > 03: <# _To := "" > 04: <# _DoNothing := {|| NIL} > 05: <# _SkipThis := {|| .not. FAX .or. EMPTY( FAX_NO )} > 06: < DBEVAL (_DoNothing,, _SkipThis,, .T.) > 07: 08: John Smith 09: 101 Street Avenue 10: Anywhere, Anystate 11: 12345 12: Tel. (999) 555-1212 13: 14: < _Date > 15: 16: < TRIMLINES ( 17: TRIM (TRIM (SAL) +" "+ FIRST_NAME) +" "+ LAST_NAME + _LF + 18: TITLE + _LF + 19: DEPARTMENT+ _LF + 20: COMPANY + _LF + 21: ADDRESS_1 + _LF + 22: ADDRESS_2 + _LF + 23: TRIM (CITY)+ ", " + STATE + _LF + 24: ZIP_CODE + _LF ) 25: > 26: 27: Dear < _To := IF( EMPTY(LAST_NAME), "Sir/Madam", 28: TRIM (TRIM (SAL)+" "+LAST_NAME)) >, 29: 30: ******************* 31: 32: TEXT 33: 34: ******************* 35: 36: Yours very truly, 37: ##include=C:\BITFAX\SEND\SIGNATUR.PCX 38: John Smith, PhD. 39: < 40: WRITE ("C:\BF\FAX.TXT"), 41: RUN ("C:\BF\BITFAX -FC:\BF\FAX.TXT -P" + STRTRAN(FAX_NO," "), 384), 42: 43: TXLOG := TRIM (STUFF (RIGHT (MEMOREAD( 44: "C:\BF\BITFAXTX.LOG"), 90), 40, 14, "")), 45: 46: PUT ("NOTES", NOTES + "* " + DTOC( DATE() ) + " FAX to: " + _To 47: + ", brochure rev 1.21"+_LF+" "+TXLOG+_LF), 48: 49: PUT ("STATUS", SUBSTR(TXLOG, 55)), 50: IF (SUBSTR( TXLOG, 55, 2 ) == "OK", PUT ("LAST_FAX", DATE()), NIL) 51: > APPENDIX A MyBASE Pg. 29 The following is a description of commands which are embedded in the preceding sample merge file: Line 01: Convert the system date to the following format: 'July 7, 1993', and save the result in the memory variable "_Date". Line 03: Define a memory variable "_To" for later use. Line 04: Define a NUL code block (one which does nothing). Line 05: Define a code block which will return the faxability status of the current record. When evaluated, this code block will return TRUE if the current record does not have a fax number, or if the FAX flag has been set to FALSE. Line 06: Skip all records for which the code block "_SkipThis" returns TRUE (ie. all records which have no fax number or where the FAX flag has been set to false). Line 14: Print the contents of memory variable "_Date" (ie. the system date). Line 16-25: Print the client's name and address. The function TRIMLINES(), causes empty lines to be deleted. Line 27: Print greeting as follows: If the LAST_NAME field is empty, then print: "Dear Sir/Madam,". If the LAST_NAME field is not empty, then print the greeting in the following format: "Dear Mr. Jones,". The greeting is also stored in the predefined memory variable "_To" for later use. Line 37: This is a BITFAX specific command which is used to tell BITFAX to include an external file in the fax document. In this case, the graphics file SIGNATUR.PCX (the author's signature) will be inserted at this location. Line 40: Write merged text and data to a disk file, FAX.TXT. APPENDIX A MyBASE Pg. 30 Line 41: Shell to DOS, making at least 384K of RAM available, and run BITFAX with instructions to fax the file FAX.TXT to the fax number FAX_NO. BITFAX will attempt to fax the document, saving all results in a transmit log file called BITFAXTX.LOG. Line 43: Read the last line in the log file BITFAXTX.LOG and store the result in a memory variable, "TXLOG". Line 46: Save the transmit log result in the database memo field, NOTES. Line 49: Save the transmit log result in the database field, STATUS. Line 50: If the fax has been successfully transmitted, update the LAST_FAX field to the current date. APPENDIX A MyBASE Pg. 31 SPECIAL FUNCTIONS FOR MERGE PRINTING ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ The following is a listing of functions which may ONLY be used in merge printing. Please consult appendix "D" for a listing of additional functions which may be used in a merge file. ------------------------ < CONTINUE() > or < LOCATE() > Returns: NIL Skip to the next record which satisfies the last specified LOCATE condition. ------------------------ < LOCATE( cCondition ) > Returns: NIL Select and process only those records from the database which satisfy the logical condition (cCondition). cCondition must be specified as a character string delimited on both ends with a pair of double quotes ("), single quotes ('), or square brackets ([ ]). The expression must evaluate to a logical value, example: < LOCATE( "UPPER(TRIM( CITY )) == 'DALLAS'" ) > If the ( cCondition ) is not specified, the statement is equivalent to a CONTINUE(), see below. ------------------------ < RET() > Return. Stops merge program for current record but continues from the top of the merge program with the next record. Example: < IF( UPPER(TRIM( CITY )) == "DALLAS", RET(), NIL) > If place at the top of the merge file, this example will skip all the records where the CITY is "DALLAS". ------------------------ APPENDIX A MyBASE Pg. 32 ------------------------ < STOP( lSet ) > Returns: lStatus If specified, lSet must be a logical value (either .T. or .F.). If lSet is specified as .T., the merge operation will terminate. Specifying lSet as .F. will reset the current STOP() status. If lSet is not specified, as in < STOP() >, then the current merge print status will be returned a a logical value. If the end of file is reached or if an error is encountered, then STOP() will return .T. ------------------------ < WRITE( cWriteTo ) > Returns: lSuccess Write merged text to the device or file specified in cWriteTo. cWriteTo must be specified as a character string delimited on both ends with a pair of double quotes ("), single quotes ('), or square brackets ([]). cWriteTo may be either a physical device such as PRN, LPT1, LPT2, LPT3, COM1 or COM2 or a disk file. If the operation is successful WRITE() returns .T., example: < WRITE( "C:OUTPUT.TXT" ) > --> writes to a disk file < WRITE( "LPT1" ) > writes to parallel port 1 ------------------------ PREDEFINED MEMORY VARIABLES ~~~~~~~~~~~~~~~~~~~~~~~~~~~ The following memory variables are predefined and may be referenced but not reassigned in a merge file: _LF : Defined as CR + LF (ASCII characters 13 + 10) _cOutText : Contains the current merged text. The following memory variables are reserved, and should not be referenced or reassigned in a merge file: _LUDFLOOK, _LFIRSTREC, _CPRESET APPENDIX A MyBASE Pg. 33 COMMENT STATEMENTS ~~~~~~~~~~~~~~~~~~ Text which begins with an asterisk (*) and is enclosed in the angled brack- ets will be ignored. For example: <* This is a comment... > PRE-PROCESSED STATEMENTS ~~~~~~~~~~~~~~~~~~~~~~~~ Functions or statements which begin with a hash mark (#) are processed only once. As the statements are evaluated, their results may be assigned to a memory variable for later use. For example: <# _DueDate := DATE() + 28 > Even if thousands of records are processed, this function will only be evaluated once! However since the result has been assigned to a memory variable, it may be accessed at any time later, example: ...please pay the enclosed invoice by <_DueDate >. As you may well imagine, pre-processing functions will greatly increase the speed of a merge program. However not all functions may be pre-processed. If the result of a function depends on variable data, then the function will need to be re-evaluated each time. For example: ...your account is < DATE() - DUE_DATE > days overdue. In this example, the result of the required function is not constant and will need to be evaluated for each record. ** NOTE ** Code blocks must always be pre-processed before they can be used in functions, example: <# _DoNothing := {|| NIL} > <# _SkipThis := {|| ! FAX .or. EMPTY( FAX_NO )} > < DBEVAL (_DoNothing,, _SkipThis,, .T.) > In this example the code blocks are pre-processed and assigned to memory variables. The function DBEVAL() later uses these code blocks to skip invalid records. APPENDIX A MyBASE Pg. 34 GROUPING FUNCTIONS ~~~~~~~~~~~~~~~~~~ Functions or statements which follow one after the other, and which are not pre-processed (ie. ones which do not begin with a hash mark "#"), may be grouped into one macro, separated by a comma (,). Grouping functions has several advantages, namely: (a) They will be processed faster, and (b) Temporary memory variables created within the group will remain visible until all functions within that group have been processed. Once the entire group is processed, the temporary memory variables will be discarded. Example: < _Name := Trim(FIRST_NAME) + " " + LAST_NAME, _Title := TITLE , _Company := COMPANY , _Address := ADDRESS_1 , _City := CITY , _State := STATE , _ZipCode := ZIP_CODE , _Country := COUNTRY , _PhoneNo := PHONE_NO , _dbArea := SELECT(), dbUseArea (.T., "DBFNTX", "dbf_2",, .F.), dbAppend(), Put ("name" , _Name ), Put ("title" , _Title ), Put ("company" , _Company ), Put ("address" , _Address ), Put ("city" , _City ), Put ("state" , _State ), Put ("zip_code" , _ZipCode ), Put ("country" , _Country ), Put ("phone" , _PhoneNo ), Put ("status" , "* NEW *" ), dbCloseArea(), dbSelectArea (_dbArea) > This example first assigns data from the primary database to temporary memory variables. It then opens a secondary database (DBF_2), appends a blank record to it, and stores the data from the temporary memory variables into this database. Once all the data has been saved, the secondary database is closed, and the primary database is reselected. APPENDIX B MyBASE Pg. 35 APPENDIX B: OPERATORS ~~~~~~~~~~~~~~~~~~~~~ STRING OPERATORS ~~~~~~~~~~~~~~~~ The following operators may be used with character and/or memo type varia- bles: Symbol | Operation --------|------------------------------------------- + | Concatenate - | Concatenate without intervening spaces Example: "ABCD " + "XYZ" ---> "ABCD XYZ" "ABCD " - "XYZ" "ABCDXYZ " DATE OPERATORS ~~~~~~~~~~~~~~ Symbol | Operation --------|------------------------------------------- + | Add number of days to first date - | Subtract number of days from first date - | Find number of days between two dates Example: 1995.01.01 + 14 ---> 1995.01.15 1993.12.31 - 14 1993.12.17 1993.12.31 - 1992.12.31 365 MATHEMATICAL OPERATORS ~~~~~~~~~~~~~~~~~~~~~~ Mathematical operators require numeric type operands and return a numeric value. Symbol | Operation --------|------------------------------------------- ^ | Exponentiation * | Multiplication / | Division % | Modulus (remainder of a division) + | Add - | Subtract APPENDIX B MyBASE Pg. 36 RELATIONAL OPERATORS ~~~~~~~~~~~~~~~~~~~~ Relational operators require two operands of the same data type or at least one NIL operand. The result of a relational operator is a logical value (True/False) Symbol | Operation --------|------------------------------------------- < | Less than <= | Less than or equal > | Greater than >= | Greater than or equal =,== | Equal <>,#,!= | Not equal $ | Is contained in the set or is a subset of LOGICAL OPERATORS ~~~~~~~~~~~~~~~~~ Logical operators require logical operands, and except for negate, they require a pair of operands. The result of a logical operation is always a logical value. Symbol | Operation --------|-------------------------------------------------- .AND. | Return TRUE when both operands are TRUE .OR. | Return TRUE if either operand is TRUE !,.NOT. | Negate, return TRUE if preceding operand is FALSE ASSIGNMENT OPERATORS ~~~~~~~~~~~~~~~~~~~~ Assignment operators assign values to variables. In order to assign values to database fields the FIELD-> statement must precede the field name, otherwise a memory variable is assumed. ( Example: FIELD->AMT_PAID ) Symbol | Operation | Valid data type --------|----------------------------------------------|---------------- := | In-line assign | all += | In-line add (or concatenate) and assign | C,D,M,N -= | In-line subtract (or concatenate) and assign | C,D,M,N *= | In-line multiply and assign | N /= | In-line divide and assign | N ^= | In-line exponentiate and assign | N %= | In-line modulus and assign | N Example: (a) FIELD->OrderQty := 12 (b) AmtOwing -= AmtPaid Example (b) uses a compound assignment (-=) and is equivalent to: AmtOwing := AmtOwing - AmtPaid APPENDIX C MyBASE Pg. 37 APPENDIX C: CODE BLOCKS AND ARRAYS ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Curly braces ({}) are used to create arrays. The array elements must be within the braces and separated by commas. Curly braces are also used to create code blocks. The code block parameters (variables) are further delimited within the curly braces with vertical bars (||), and the expres- sions defining the code block are separated by commas. ARRAYS ~~~~~~ Arrays are simply memory data structures which may contain a series of data values called array elements. Arrays may be assigned to variables with the assign statement (:=), such as: x := {10, 4, 33}. Once an array is assigned to a variable, array elements may later be retrieved or reassigned by specifying the variable name followed by the element number enclosed in square brackets, such as x[2]. Multi-dimensional arrays may also be created by assigning an array to an array element. Examples: (a) Creating an array: Array := { "Ottawa", "Los Angeles", "Rome", "London", "Paris" } ------ ----------- ---- ------ ----- <---------------- array elements ----------------> (b) Storing an array element to a database field: field->CITY := Array[3] (c) Reassigning an array element: Array[3] := field->CITY (d) Creating a multi-dimensional array: Array := { {"MyBASE","DME","AHP"}, {199,99,99}, 1.2, 3.3 } (e) Accessing an element from a multi-dimensional array: Array[1] --> { "MyBASE", "DME", "AHP" } Array[1,3] "AHP" Array[2,1] 199 Array[3] 1.2 APPENDIX C MyBASE Pg. 38 (f) Traversing an array one element at a time using AEVAL() function: nTotal := 0 AEVAL( Array, {|element| nTotal += element} ) CODE BLOCKS ~~~~~~~~~~~ Code blocks are a special data structure which may contain macros and functions to perform a series of calculations, database operations, and so on. Code blocks may be assigned to variables and later evaluated by specifying the code block variable as a parameter in one of the following functions: EVAL(), DBEVAL(), and AEVAL(). Please consult Appendix "D" for a description of these functions and a listing of additional functions which may be used in the expression list of a code block. Examples: (a) Creating a code block: xBlock := { |a, b, c, d| d := MAX(a,b), c := c+d, ROUND(c, 2) } ----+----- ------------- -------- -----+----- | <---------- expressions ------|----> | | parameters (variables) | | last expression = value returned by code block --+ (b) Evaluating the code block: EVAL ( xBlock, 10, nVar1, nVar2, nVar3 ) APPENDIX D MyBASE Pg. 39 APPENDIX D: FUNCTION REFERENCE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ This section is available only with the registered version of MyBASE. APPENDIX E MyBASE Pg. 40 APPENDIX E: REGISTERING MyBASE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ When you register, you will receive the following: - The latest commercial version of MyBASE. - Complete function reference and user's guide. - A shareware copy of the Analytic Hierarchy Process (AHP) software, see Appendix "F" for more information on this package. - Free technical support. - Notice of future upgrades and new products. - Eligibility for low cost updates. To place an order for the latest version of MyBASE, push F9 while in the database browse table and select "MyBASE Order Form". You will then be prompted to enter your name and address and any comments or suggestions you may have concerning this product. To print the name, address and comments form, push F8 and select the appropriate print driver. To display the actual order form, push F9. Alternatively, you may push ESC, ALT+X, or F10 to exit from the name and address screen and go on to the order form screen. Please note; each single user copy of MyBASE is licensed for use on a single machine, by one user at any one time. Each multi-user LAN version of MyBASE, is licensed for use on a single network server and may be used by up to five (5) concurrent users. You may increase the number of licensed concurrent network users by purchasing multiple copies of MyBASE. CURRENCY (U.S./CDN): MyBASE must be paid for in either U.S. or Canadian funds. To change currency simply push F2, all costs will be automatically recalculated. ORDER QUANTITY AND VOLUME DISCOUNTS: A volume discount is automatically calculated for order quantities of 2 or more. Depending upon the order quantity, the volume discount may be as high as 50.0%. Documentation is ordinarily provided on disk, however, printed documentation may be ordered at the cost of $25.00 US. APPLICABLE TAXES: Please enter the % applicable taxes. In Canada this includes GST and PST. PRE-PAYMENT DISCOUNT You are entitled to a $15.00 discount if payment is included with the order. PRINT When you are finished entering all the required data, push F8 to print the order form. Attach this form to the NAME/ADDRESS/COMMENTS form and send to Armada Systems. PAYMENT (CHEQUE, MONEY ORDER, OR PURCHASE ORDER): With your order forms, be sure to include a cheque or money order payable to "B. BORZIC", for the amount indicated in the TOTAL column. Purchase orders may also be submitted by North American customers. APPENDIX E MyBASE Pg. 41 The following is a copy of the name, address and comments form which will be displayed on screen when you access the MyBASE Order Form function: NAME: TITLE: DEPARTMENT: COMPANY: ADDRESS: CITY: STATE/PROV.: ZIP/P.C.: COUNTRY: TELEPHONE: FAX: DISK FORMAT: [ ] 5.25' or [ ] 3.5' (select one) =========================================================================== HOW DID YOU LEARN ABOUT MyBASE? =========================================================================== COMMENTS: APPENDIX F MyBASE Pg. 42 APPENDIX F: OTHER SOFTWARE FROM ARMADA SYSTEMS ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ABOUT ARMADA SYSTEMS ~~~~~~~~~~~~~~~~~~~~ Armada Systems was established in 1986 with the purpose of developing unique but useful microcomputer software. Since that time, Armada Systems has expanded it's operations, and now specializes in the following key areas: * Custom PC software development. * Decision making software, seminars and consulting services. * CA-Clipper training. * Research and development of new software applications. In addition to MyBASE, Armada Systems publishes the Decision Matrix Expert (DME) and Analytic Hierarchy Process (AHP) software packages. The next several pages are devoted to providing you with a better understanding of what these software packages do, and how they can help you to become a more effective decision maker. APPENDIX F MyBASE Pg. 43 DECISION MATRIX EXPERT (DME) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ The Decision Matrix Expert (DME), is an innovative, yet remarkably easy to use software package for decision analysis. It represents a scientific approach to replace intuition and speculation, while preserving such qualitative factors as experience and judgment. The DME is not a 'black box' program, it relies upon the use of popular, well established Multiple Criteria Decision Making algorithms. Numerical results are provided for each stage in the analysis, so that the user can see what is happening and have confidence in the results. The use of popular, well established algorithms, with intermediate numerical results, is especially important to such users as educational institutions, government agencies and consultants. Consultants, who for example, are taxed to recommend the location for a new garbage dump, need a tool which will evaluate possible alternatives with as little bias as possible. Their recommendations will need to stand up to public scrutiny, and the public hearing process which usually takes place before a site is actually selected. This is where the use of well established decision analysis algorithms is useful. They can be explained and defended because quite a bit of research has gone into them. In the DME, decisions are portrayed in a matrix which contains all of the information required to arrive at a final decision. The columns of this matrix represent the criteria which are important to the decision, while the rows represent the various alternatives being considered. In the analysis, alternatives are scanned for dominance and to ensure that they meet the minimum cutoff constraints specified by the user. Final ranking of alternatives is performed using the Linear Assignment Method, Normalized Additive Weighting, ELECTRE, TOPSIS, and an aggregation and synthesis phase. Numerical results from each of these algorithm phases are available to the user for analysis. Applications Location planning, cost/benefit analysis, strategic planning, recruiting, employee evaluation, resource allocation, taste testing, new product evaluations, problem analysis, market research, and many more. System requirements The Decision Matrix Expert will work on any MS DOS compatible computer with at least 384K RAM. A printer is recommended but not required. APPENDIX F MyBASE Pg. 44 ANALYTIC HIERARCHY PROCESS (AHP) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ The Analytic Hierarchy Process (AHP), is an innovative, yet remarkably easy to use software package for decision analysis. It represents a scientific approach to replace intuition and speculation, while preserving such qualitative factors as experience and judgment. Employing pairwise comparisons and a hierarchical problem structure, the AHP allows the use of intangible factors in the decision analysis. The AHP is most beneficial when you wish to model complex problems, and the only data available is the subjective judgments of yourself, or those of a group. The AHP is not only useful in decision making problems, but also in any other area where you find it necessary to quantify subjective or intangible criteria. The AHP uses a well proven scientific method which requires that a problem be decomposed into a hierarchical model. Elements in this hierarchy are grouped in such a way, that those of a lower level directly influence the elements in the immediately higher level. The objective is to derive a set of quantitative weights for elements in the lowest level which reflect as best as possible their relative impact on the overall goal of the hierarchy. The advantage of setting up your problem in a hierarchical structure is that it will help you to focus your attention on each part of the problem separately. Elements in each level are compared in pairs, with respect to those elements in the immediately higher level. Based on your pairwise comparisons, the program will calculate subjective weights for each element. It will also report your judgment consistency, and indicate specifically which judgments are inconsistent. Applications Location planning, cost/benefit analysis, strategic planning, recruiting, employee evaluation, resource allocation, sales forecasting, taste testing, new product evaluations, problem analysis, market research, and many more. System requirements The Analytic Hierarchy Process will work on any MS DOS compatible computer with at least 384K RAM. A printer is recommended but not required. APPENDIX F MyBASE Pg. 45 ORDERING DME/AHP SOFTWARE ~~~~~~~~~~~~~~~~~~~~~~~~~ When you purchase any software from Armada Systems, your satisfaction is 100% guaranteed. If for any reason you are not completely satisfied with the product you may return it within 30 days for a refund. In addition to this guarantee, you will receive the following: (1) The latest version of software. (2) Complete reference and user's guide. (3) Free technical support. (4) Notice of future upgrades and new products. (5) Eligibility for low cost updates. (6) Free shareware software, as follows: ┌────────────────────────────┬─────────────────────────────────┐ │ PROGRAM ORDERED │ FREE SHAREWARE YOU WILL RECEIVE │ ├────────────────────────────┼─────────────────────────────────┤ │ Decision Matrix Expert │ MyBASE │ │ Analytic Hierarchy Process │ MyBASE │ │ MyBASE │ Analytic Hierarchy Process │ └────────────────────────────┴─────────────────────────────────┘ To place your order, fill out the order form on the following page and mail it to Armada Systems, along with a company purchase order, cheque or money order payment, made out to "B. BORZIC". Payment must be in the quoted U.S. or Canadian funds. Site licensing and volume discounts (QTY. >= 7) are available, please write for details. ARMADA SYSTEMS SOFTWARE REGISTRATION AND ORDER FORM ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ To order software, please fill out this order form and mail it to the address given below, along with a company purchase order, cheque or money order payment, made out to "B. BORZIC". Payment must be in the quoted U.S. or Canadian funds. Site licensing and volume discounts (QTY. >= 7) are available, please write for details. When you purchase software from Armada Systems, your satisfaction is 100% guaranteed. If for any reason you are not completely satisfied with the product you may return it within 30 days for a refund. Boris Borzic Armada Systems P.O. Box 637, Station A Downsview, Ontario M3M 3A9 CANADA Tel. (416) 889-2617 or (905) 889-2617 after October 4, 1993 NAME ____________________________ TITLE __________________________________ COMPANY _________________________ DEPARTMENT _____________________________ ADDRESS ___________________________________________________________________ CITY ____________________________ STATE/PROVINCE _________________________ ZIP/POSTAL CODE _________________ COUNTRY ________________________________ PHONE ___________________________ FAX ____________________________________ Would you like the program supplied on 5.25" or 3.5" disks? _______________ Where did you obtain the MyBASE software? _________________________________ MyBASE 2.03 - 93124A0 +-------------------------------------------------------------------------+ | DESCRIPTION | U.S. $ | CDN $ | QTY | TOTAL $ | |-------------------------------------|--------|--------|-----|-----------| | Decision Matrix Expert (DME) | 99.00 | 119.00 | | | |-------------------------------------|--------|--------|-----|-----------| | Analytic Hierarchy Process (AHP) | 99.00 | 119.00 | | | |-------------------------------------|--------|--------|-----|-----------| | AHP + DME ordered together | 149.00 | 179.00 | | | +-------------------------------------------------------------|-----------| Purchase order processing charge | 15.00 | (cross out if payment is enclosed) | | |-----------| Shipping & handling | 8.00 | |-----------| Applicable taxes | | |-----------| TOTAL | | +-----------+ Signature ______________________________ Date ____________________________ Use the back of this sheet to add any comments or suggestions you may have. NOTES