Short: Powerful programmable database with GUI Author: gutmann@informatik.uni-ulm.de Uploader: gutmann@informatik.uni-ulm.de Type: biz/dbase AMIGABASE V 2.2 (c) 1989-1995 Steffen Gutmann ============================================= AmigaBase is a programmable hierarchical database. AmigaBase is shareware. This means that the program can be freely copied and distributed as long as no more than a nominal fee is charged to cover time and copying costs. All rights reserved. If you use the program you must register yourself. Therefore send a short letter along with the shareware fee to: Steffen Gutmann Wiesentalstr. 30 D-73312 Geislingen/Eybach. GERMANY The shareware fee is DM 70,-- or US $50. If you are a registered user of AmigaBase V1.xx then you are allowed to use the new version. If you want the new user manual you can get it for an update fee of DM 30,-- (US $20). Please specify your registration number when sending the fee. Registered users of AmigaBase V2.x will find a small documentation update in the "Updates" directory. Send money by EuroCheck (only in Deutsch Mark (DM)), postal money order or cash (take care that the money is not visible from outside!). You may also use a foreign check, but please add DM 10,- or US $5 in this case. If you live in Germany then please also read the "Liesmich" file for further ways of paying the fee. On registration you will get the latest version of AmigaBase along with the user manual. The manual is available in English or German. It has been written in Latex, contains several screendumps and is about 100 pages. I cannot guarantee that this program is bug free! You use this software at your own risk! But if you find a bug then please let me know of it. You can contact me by sending a letter to the address above, or by sending an email to gutmann@informatik.uni-ulm.de AmigaBase uses 'reqtools.library' (c) Nico François and 'gadget.library' (c) Steffen Gutmann. Files: ------ You should have the following files: AmigaBase or AmigaBase.lha - executable program, packed eventually. Install-AB/* - Installer script to install AmigaBase ReadMe - this file LiesMich - German ReadMe BUGS CONTENTS HISTORY TODO - further information Reg_Form - registration form Reg_Form.deutsch - German version Updates/* - Documentation updates (for registered users, do not read if you aren't one :-). Catalogs/*/AmigaBase.catalog - catalog files for other languages than English Data/Deutsch/* - some example projects (German versions) Data/English/* - some example projects (English versions) Data/Graphics/Mandelpic.iff - iff picture used by the project "Mandel pictures". libs13/reqtools.library - reqtools.library for Kickstart 1.2/1.3 libs20/reqtools.library - reqtools.library for Kickstart 2.0 libs13/gadget.library - gadget library for 1.2/1.3 and 2.0. MakeCat/* - information & files to translate AmigaBase into another language. ToolManager/AmigaBase.brush - image file for toolmanager. lha - unpacker for AmigaBase.lha MuchMore - text displayer Equipment: ---------- AmigaBase works on every Amiga with Kickstart 1.2/1.3 or higher. Of course if your computer runs a higher OS version, AmigaBase will make use of its improvements. You need at least 1MByte Ram to run AmigaBase. Recommend, but not needed, are more memory and a hard disk. Installation: ------------- For installation use the Installer script in the 'Install-AB' directory. Double click its icon and follow its instructions. It installs AmigaBase, the reqtools.library, the gadget.library, the locale files and the example projects. If you want to install AmigaBase by hand you have to do the following: o Reqtools.library: Corresponding to your OS version copy libs20/reqtools.library or libs13/reqtools.library into the libs: directory. o Gadget.library: Copy libs13/gadget.library into the libs: directory (even under OS2.0 or up). o Unpack the file AmigaBase.lha if necessary. Now you can start AmigaBase. o If you want AmigaBase to look in your language and you have OS 2.0 with Workbench 2.1, copy Catalogs/your_language/AmigaBase.catalog to LOCALE:Catalogs/your_language. If your language is not supported then please have a look into the MakeCat directory and read the ReadMe file there. o If you want to start AmigaBase by double clicking an AmigaBase project you need to assign AmigaBase: to the directory containing AmigaBase. What does AmigaBase offer: -------------------------- AmigaBase is not a relational database with SQL interface or something like this. AmigaBase is a hierarchical programmable database. Nevertheless, or just because, AmigaBase is ideal for managing music cassettes, videos, addresses, etc. Complex applications like a finance manager with automatic printing of transfer forms and writing client accounts is no problem for AmigaBase, too. A project consists of one or several records. A record is displayed by a rectangle with a colored border and a titlebar. The record name is displayed in the title bar. A record can be placed beside or within annother one (hierarchy). In records you can place variables which are used for data input and display. Data is organized in datasets. For each record you can allocate any number of datasets (only limited by available memory). Datasets can be ordered by several keys. A filter allows the selection of some datasets. A print menu allows printing of datasets. With a search requester it is easy to find certain datasets. AmigaBase offers two display modes: form and listing. In form display all records are displayed in several windows. In each record exactly one dataset is shown. In listing display all dataset of a specific record are displayed in a scrolling list in a window. AmigaBase has two operating modes: working mode and installing mode. In working mode you can work with your project, input data, start programs, etc. In installing mode you build your data structure. You can define new variables, change and delete them. Variables can be of the type BOOLEAN (boolean values), CHOICE (one item out of many items), INTEGER (integer values), REAL (floating point values), STRING (any text), DATE (date values), TIME (time values), or MEMO (unlimited multi line text). Additionally there is the program button type which is only used to start AmigaBase programs. Furthermore you can define, change and delete texts. Texts are only used for decoration in records. You can also define, change and delete records and windows. You must give each variable, record and window a name. This name must begin with an uppercase letter followed by up to nine letters, digits or the character '_'. There are some reserved words that cannot be used for names. A special feature of AmigaBase is the programming of it. For each variable (except MEMO variables) you can write a program which is called whenever you change the contents of this variable or press RETURN while the cursor is on the program button variable. If you want to have a view into programming AmigaBase I recommend that you have a look at the label print program of the cassette project (included in the distribution). A complete description of all functions and abilities of AmigaBase is found in the user manual of AmigaBase. This document is available by registration only. Import of datasets ------------------ For importing datasets there aren't any menu items. But with the use of an AmigaBase program you can write your own Import routine. First you have to load the import file into a MEMO variable (MEMOLOAD). Then you do a FOR loop and examine each line of the MEMO variable. Use LeftStr, MidStr, RightStr, Val, etc. to extract the data and assign it to the dataset variables. This looks awkward, but it is very flexible. The user manual contains a whole chapter about importing and exporting datasets. New features V1.31 - V2.00 -------------------------- o Full font sensitive o OS 3.0 look o Iconification of windows. o Improved memory management o Arexx port o Copy & paste o New variable type: CHOICE o MEMO variables with their own window o Improved text editor. o Enabled use of an external editor o Shortcuts for variables o Improved preferences settings (project dependent/independent) o Formats for date and floating point values. o Stack overflow handler and ctrl-c checking o Save & load of filter programs o Font attributes, background color and borders for all variable types. o New program types: PreNewDataset, PostNewDataset, PreDeleteDataset, PostDeleteDataset and Functions. o Many new functions and improvements for programming AmigaBase o Many bug fixes New features V2.00 - V2.1 ------------------------- o Danish and French catalog file. o New programming functions: Filename, Changes, ARexxPort, ChooseString, Now, StrCmp and ChoiceLabels. o Improvements for file requesters. o Many bug fixes and other improvements. Neue Features V2.1 - V2.2 -------------------------- o New program types: PostOpenProject and PreQuitProject. o New functions for programming. o New menu item to print a listing of all records and variables. o New ARexx functions. o New escape code: "\e". o Small improvement for opening requesters. o Small improvement when using the external editor for programming. o Small improvement when searching for data. o Changed menu item "Paste buffer". o Support of the Spanish and Dutch language. o Several bug fixes. Example projects: ----------------- In the directory Data/Deutsch and Data/English you will find some example projects. If you have created your own project and you think that other AmigaBase users should also benfit from it then please send it to me. We can then decide how to make it available to the public. Installer: ---------- Installer and Installer project icon (c) Copyright 1991-93 Commodore-Amiga, Inc. All Rights Reserved. Reproduced and distributed under license from Commodore. INSTALLER SOFTWARE IS PROVIDED "AS-IS" AND SUBJECT TO CHANGE; NO WARRANTIES ARE MADE. ALL USE IS AT YOUR OWN RISK. NO LIABILITY OR RESPONSIBILITY IS ASSUMED. Thanks ------ Thanks to o Mats Granstrom for many ideas and his funny jokes and comments. o Mads Lie Jensen for the Danish catalog file and other things. o Eyal Teler for many bug reports and ideas. o Falk Hildner, Wolfgang Brodowski, Dirk-Michael Brosig, Hartmut Jäger, Michael Klingbeil, Ralph Reuchlein and Waldemar Karwath for beta testing and some example projects. o Paolo Costabel and Werther Pirani for the Italian catalog file. o Fabien Larini and Tattoo Mabonzo for the French catalog file. o Peter Wastholm and Mikael Fors for the Swedish catalog file. o Ronald Sloot for the Dutch catalog file. o Jorge Acereda for the Spanish catalog file. o All other beta testers. o Jürgen Brust, Michael Janich, Nico François, Michael Greenhalg, Jan Ulbrich, Andy Buck, Ralf Biedert, Petra Mössner, René Schuster and all registered AmigaBase users. ============================= Archive contents ============================= Original Packed Ratio Date Time Name -------- ------- ----- --------- -------- ------------- 632 278 56.0% 17-Sep-95 23:26:12 AmigaBase.info 92 92 0.0% 24-Oct-95 16:48:38 +.info 632 275 56.4% 22-Jul-94 16:49:44 +AB_dir.icon 304096 159411 47.5% 16-Nov-95 20:24:40 +AmigaBase 822 379 53.8% 20-Nov-95 20:32:28 +AmigaBase.info 1178 603 48.8% 03-Mar-95 23:40:54 +insert 281 195 30.6% 03-Mar-95 23:38:36 +ReadMe 291 223 23.3% 16-Nov-94 08:59:48 +rx·Dir 2443 670 72.5% 03-Feb-95 10:57:36 +rx·DOS 3626 910 74.9% 21-Feb-95 18:40:48 +rx·DOS.info 1783 628 64.7% 03-Feb-95 10:58:26 +rx·End 1739 744 57.2% 06-Dec-94 00:34:32 +rx·End.dok 3633 917 74.7% 11-Dec-94 22:32:56 +rx·End.dok.info 3626 912 74.8% 21-Feb-95 18:40:52 +rx·End.info 4563 1386 69.6% 03-Feb-95 14:15:08 +rx·Run 1157 511 55.8% 06-Dec-94 22:19:18 +rx·Run.dok 3633 917 74.7% 11-Dec-94 22:32:54 +rx·Run.dok.info 3626 912 74.8% 21-Feb-95 18:40:52 +rx·Run.info 149 99 33.5% 07-May-94 15:28:44 +status 1152 564 51.0% 03-Oct-95 13:45:32 +BUGS 1095 337 69.2% 20-Nov-95 20:32:28 +BUGS.info 13292 5678 57.2% 16-Nov-95 20:27:22 +AmigaBase.catalog 14370 5901 58.9% 16-Nov-95 20:27:22 +AmigaBase.catalog 14354 5910 58.8% 16-Nov-95 20:27:20 +AmigaBase.catalog 14916 6139 58.8% 16-Nov-95 20:27:20 +AmigaBase.catalog 14528 5882 59.5% 16-Nov-95 20:27:18 +AmigaBase.catalog 14734 5977 59.4% 16-Nov-95 20:27:14 +AmigaBase.catalog 13614 5727 57.9% 16-Nov-95 20:27:10 +AmigaBase.catalog 628 272 56.6% 20-Nov-95 20:32:28 +Data.info 41 41 0.0% 19-May-94 22:58:14 +.info 628 274 56.3% 08-Jan-95 21:07:00 +Deutsch.info 7758 2223 71.3% 23-Jul-94 15:10:52 +Adressen 4194 2007 52.1% 23-Jul-94 15:26:22 +Adressen.guide 1228 289 76.4% 08-Jan-95 21:07:00 +Adressen.guide.info 398 156 60.8% 08-Jan-95 21:07:00 +Adressen.info 3062 972 68.2% 20-Nov-95 21:27:22 +Apfelbilder 402 167 58.4% 20-Nov-95 21:27:22 +Apfelbilder.info 755 376 50.1% 27-Mar-93 18:19:02 +Apfelbilder.LiesMich 1095 332 69.6% 08-Jan-95 21:07:00 +Apfelbilder.LiesMich.info 11904 3429 71.1% 03-Aug-94 19:06:26 +Buchhalter 398 157 60.5% 08-Jan-95 21:07:00 +Buchhalter.info 11545 4098 64.5% 26-Jan-95 21:27:50 +Buchhalter.LiesMich 1095 332 69.6% 08-Jan-95 21:07:00 +Buchhalter.LiesMich.info 7858 2410 69.3% 08-Dec-94 23:38:20 +Kassenbuch 398 156 60.8% 08-Jan-95 21:07:00 +Kassenbuch.info 6615 2965 55.1% 09-Dec-94 14:11:14 +Kassenbuch.LiesMich 1095 336 69.3% 08-Jan-95 21:07:00 +Kassenbuch.LiesMich.info 628 271 56.8% 08-Jan-95 21:07:00 +Memory.info 33902 8800 74.0% 03-Jan-95 18:20:44 +ab·Memory 5767 2314 59.8% 03-Mar-95 23:52:46 +ab·Memory.dok 3633 922 74.6% 14-Dec-94 11:58:18 +ab·Memory.dok.info 3643 921 74.7% 03-Jan-95 18:20:44 +ab·Memory.info 360 212 41.1% 03-Jan-95 18:14:02 +rx·Run_ab·Memory 3629 912 74.8% 14-Dec-94 11:58:18 +rx·Run_ab·Memory.info 14450 3683 74.5% 07-May-94 22:48:04 +MusikKassetten 398 153 61.5% 08-Jan-95 21:07:00 +MusikKassetten.info 1920 823 57.1% 23-May-93 22:12:14 +MusikKassetten.LiesMich 1095 337 69.2% 08-Jan-95 21:07:00 +MusikKassetten.LiesMich.info 2414 796 67.0% 20-Feb-94 22:04:40 +Terminkalender 402 165 58.9% 08-Jan-95 21:07:00 +Terminkalender.info 393 218 44.5% 27-Mar-93 18:01:28 +Terminkalender.LiesMich 1095 334 69.4% 08-Jan-95 21:07:00 +Terminkalender.LiesMich.info 3654 1225 66.4% 13-Jul-94 12:03:26 +Video 398 153 61.5% 08-Jan-95 21:07:00 +Video.info 696 355 48.9% 28-Mar-93 16:20:52 +Video.LiesMich 1095 332 69.6% 08-Jan-95 21:07:00 +Video.LiesMich.info 628 272 56.6% 09-Oct-94 13:09:22 +English.info 172 101 41.2% 19-May-94 22:58:14 +.info 3170 967 69.4% 08-May-94 22:34:36 +Address 398 155 61.0% 09-Oct-94 13:09:22 +Address.info 319 162 49.2% 09-Oct-94 13:53:30 +Address.ReadMe 1095 332 69.6% 09-Oct-94 13:09:22 +Address.ReadMe.info 2396 819 65.8% 08-May-94 12:02:26 +Calendar 402 158 60.6% 09-Oct-94 13:09:22 +Calendar.info 329 190 42.2% 28-Mar-93 21:06:50 +Calendar.ReadMe 1095 329 69.9% 09-Oct-94 13:09:22 +Calendar.ReadMe.info 9542 2949 69.0% 19-May-94 22:31:30 +Cassettes 402 160 60.1% 09-Oct-94 13:09:22 +Cassettes.info 631 322 48.9% 08-May-94 23:13:18 +Cassettes.ReadMe 1095 329 69.9% 09-Oct-94 13:09:22 +Cassettes.ReadMe.info 11010 3258 70.4% 08-May-94 12:04:24 +Finance 398 158 60.3% 09-Oct-94 13:09:22 +Finance.info 2477 687 72.2% 08-May-94 23:15:40 +Finance.ReadMe 1095 330 69.8% 09-Oct-94 13:09:22 +Finance.ReadMe.info 2962 920 68.9% 20-Nov-95 21:28:18 +Mandel Pictures 402 162 59.7% 20-Nov-95 21:28:18 +Mandel Pictures.info 731 341 53.3% 08-May-94 23:11:18 +Mandel Pictures.ReadMe 1095 330 69.8% 09-Oct-94 13:09:22 +Mandel Pictures.ReadMe.info 16982 5126 69.8% 09-Oct-94 00:34:02 +Scheduler 398 153 61.5% 09-Oct-94 13:09:22 +Scheduler.info 6010 2461 59.0% 09-Oct-94 12:42:22 +Scheduler.ReadMe 1095 329 69.9% 09-Oct-94 13:09:22 +Scheduler.ReadMe.info 3572 1172 67.1% 13-Jul-94 12:03:36 +Video 398 156 60.8% 09-Oct-94 13:09:22 +Video.info 641 326 49.1% 28-Mar-93 22:05:58 +Video.ReadMe 1095 329 69.9% 09-Oct-94 13:09:22 +Video.ReadMe.info 628 271 56.8% 30-Mar-93 13:32:32 +Graphics.info 35154 25545 27.3% 10-Jul-93 17:03:50 +Mandelpic.iff 468 122 73.9% 30-Mar-93 13:32:32 +Mandelpic.iff.info 38687 13030 66.3% 16-Nov-95 20:14:24 +HISTORY 1095 335 69.4% 20-Nov-95 20:32:28 +HISTORY.info 628 267 57.4% 20-Nov-95 20:32:28 +Install-AB.info 6789 2062 69.6% 07-Nov-95 00:30:24 +Deutsch 720 373 48.1% 06-Nov-95 22:38:42 +Deutsch.info 6457 1899 70.5% 07-Nov-95 00:30:32 +English 697 348 50.0% 06-Nov-95 22:38:58 +English.info 39012 20693 46.9% 16-Jul-94 16:42:42 +gadget.library 39000 25910 33.5% 08-May-94 20:02:58 +reqtools.library 42476 27838 34.4% 13-Jul-94 11:46:04 +reqtools.library 14480 5640 61.0% 20-Nov-95 20:18:56 +Liesmich 1095 331 69.7% 20-Nov-95 20:32:28 +Liesmich.info 628 272 56.6% 20-Nov-95 20:32:28 +MakeCat.info 169250 40949 75.8% 20-Nov-95 20:05:12 +AppStrings.source 467 114 75.5% 07-Apr-93 17:33:20 +AppStrings.source.info 1528 747 51.1% 16-Nov-95 20:36:56 +ReadMe 1095 334 69.4% 07-Apr-93 17:33:20 +ReadMe.info 12536 4839 61.3% 20-Nov-95 20:09:20 +ReadMe 1095 333 69.5% 20-Nov-95 20:32:28 +ReadMe.info 1524 494 67.5% 07-Nov-95 00:28:40 +Reg_Form 1693 574 66.0% 16-Nov-95 20:59:30 +Reg_Form.Deutsch 437 222 49.1% 20-Nov-95 20:32:28 +Reg_Form.Deutsch.info 437 224 48.7% 20-Nov-95 20:32:30 +Reg_Form.info 7824 2940 62.4% 20-Nov-95 20:25:12 +TODO 1095 334 69.4% 20-Nov-95 20:32:28 +TODO.info 368 222 39.6% 20-Jan-93 14:32:58 +AmigaBase.brush 628 270 57.0% 20-Nov-95 20:32:30 +Updates.info 4153 1465 64.7% 20-Nov-95 20:44:56 +Update2.00-2.1 4398 1661 62.2% 20-Nov-95 20:45:14 +Update2.00-2.1.deutsch 1095 336 69.3% 17-Sep-95 23:27:20 +Update2.00-2.1.deutsch.info 1095 334 69.4% 17-Sep-95 23:27:20 +Update2.00-2.1.info 5232 1696 67.5% 20-Nov-95 20:53:54 +Update2.1-2.2 6103 2011 67.0% 20-Nov-95 21:01:56 +Update2.1-2.2.deutsch 1095 336 69.3% 17-Sep-95 23:27:20 +Update2.1-2.2.deutsch.info 1095 333 69.5% 17-Sep-95 23:27:20 +Update2.1-2.2.info -------- ------- ----- --------- -------- 1105018 465282 57.8% 21-Nov-95 23:14:38 134 files