Short: Very powerful programmable database with GUI Author: gutmann@informatik.uni-ulm.de (Steffen Gutmann) Uploader: gutmann@informatik.uni-ulm.de (Steffen Gutmann) Type: biz/dbase AMIGABASE V 2.1 (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 give me your registration number when sending the fee. Registered users of AmigaBase V2.00 automatically get the new version along with a short documentation update for free. If you are a registered user of AmigaBase V2.00 but didn't get the update then please contact me. 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 created by using 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 Use email if you can :-) 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 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. You need no hard disk nor a second floppy, you only need at least 1 MByte Ram. Installation: ------------- For installation use the Installer script 'Install-AB'. 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: Copy reqtools.library and gadget.library to libs:. If you work with Kickstart 1.2/1.3 you must copy libs13/reqtools.library to libs:reqtools.library. Unpack the file AmigaBase.lha if necessary. Now you can start AmigaBase. If you want AmigaBase to look in your language and you are running OS 2.0 with Workbench 2.1, copy Catalogs/your_language/AmigaBase.catalog to LOCALE:Catalogs/your_language. If your language is not supported have a look into the MakeCat directory and read the ReadMe file. 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. 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 it should be distributed with AmigaBase then send it to me! I will have a look at it and maybe include it in the next distribution. 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 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 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 and Michael Klingbeil for beta testing and some example projects. o All other beta testers. o Jürgen Brust, Michael Janich, Nico François, Michael Greenhalg, Jan Ulbrich, Andy Buck, Petra Mössner, René Schuster and all registered AmigaBase users. ============================= Archive contents ============================= Original Packed Ratio Date Time Name -------- ------- ----- --------- -------- ------------- 632 277 56.1% 29-Oct-94 21:23:30 AmigaBase.info 84 84 0.0% 09-Oct-94 14:09:08 AmigaBase/.info 632 275 56.4% 22-Jul-94 16:49:44 AmigaBase/AB_dir.icon 298096 156172 47.6% 03-Mar-95 23:09:50 AmigaBase/AmigaBase 822 377 54.1% 19-Sep-94 11:51:36 AmigaBase/AmigaBase.info 1178 603 48.8% 03-Mar-95 23:40:54 AmigaBase/ARexx/insert 281 195 30.6% 03-Mar-95 23:38:36 AmigaBase/ARexx/ReadMe 291 223 23.3% 16-Nov-94 08:59:48 AmigaBase/ARexx/rx·Dir 2443 670 72.5% 03-Feb-95 10:57:36 AmigaBase/ARexx/rx·DOS 3626 910 74.9% 21-Feb-95 18:40:48 AmigaBase/ARexx/rx·DOS.info 1783 628 64.7% 03-Feb-95 10:58:26 AmigaBase/ARexx/rx·End 1739 744 57.2% 06-Dec-94 00:34:32 AmigaBase/ARexx/rx·End.dok 3633 917 74.7% 11-Dec-94 22:32:56 AmigaBase/ARexx/rx·End.dok.info 3626 912 74.8% 21-Feb-95 18:40:52 AmigaBase/ARexx/rx·End.info 4563 1386 69.6% 03-Feb-95 14:15:08 AmigaBase/ARexx/rx·Run 1157 511 55.8% 06-Dec-94 22:19:18 AmigaBase/ARexx/rx·Run.dok 3633 917 74.7% 11-Dec-94 22:32:54 AmigaBase/ARexx/rx·Run.dok.info 3626 912 74.8% 21-Feb-95 18:40:52 AmigaBase/ARexx/rx·Run.info 149 99 33.5% 07-May-94 15:28:44 AmigaBase/ARexx/status 1152 565 50.9% 26-Jan-95 21:39:32 AmigaBase/BUGS 1095 331 69.7% 22-Jul-94 16:49:22 AmigaBase/BUGS.info 13164 5620 57.3% 03-Mar-95 23:31:24 AmigaBase/Catalogs/Dansk/AmigaBase.catalog 14254 5849 58.9% 03-Mar-95 23:31:26 AmigaBase/Catalogs/Deutsch/AmigaBase.catalog 14768 6078 58.8% 03-Mar-95 23:31:24 AmigaBase/Catalogs/Français/AmigaBase.catalog 14400 5828 59.5% 03-Mar-95 23:31:22 AmigaBase/Catalogs/Italiano/AmigaBase.catalog 13486 5676 57.9% 03-Mar-95 23:31:22 AmigaBase/Catalogs/Svenska/AmigaBase.catalog 628 271 56.8% 22-Jul-94 16:49:22 AmigaBase/Data.info 41 41 0.0% 19-May-94 22:58:14 AmigaBase/Data/.info 628 274 56.3% 08-Jan-95 21:07:00 AmigaBase/Data/Deutsch.info 7758 2223 71.3% 23-Jul-94 15:10:52 AmigaBase/Data/Deutsch/Adressen 4194 2007 52.1% 23-Jul-94 15:26:22 AmigaBase/Data/Deutsch/Adressen.guide 1228 289 76.4% 08-Jan-95 21:07:00 AmigaBase/Data/Deutsch/Adressen.guide.info 398 156 60.8% 08-Jan-95 21:07:00 AmigaBase/Data/Deutsch/Adressen.info 2802 971 65.3% 07-May-94 22:15:52 AmigaBase/Data/Deutsch/Apfelbilder 402 163 59.4% 08-Jan-95 21:07:00 AmigaBase/Data/Deutsch/Apfelbilder.info 755 376 50.1% 27-Mar-93 18:19:02 AmigaBase/Data/Deutsch/Apfelbilder.LiesMich 1095 332 69.6% 08-Jan-95 21:07:00 AmigaBase/Data/Deutsch/Apfelbilder.LiesMich.info 11904 3429 71.1% 03-Aug-94 19:06:26 AmigaBase/Data/Deutsch/Buchhalter 398 157 60.5% 08-Jan-95 21:07:00 AmigaBase/Data/Deutsch/Buchhalter.info 11545 4098 64.5% 26-Jan-95 21:27:50 AmigaBase/Data/Deutsch/Buchhalter.LiesMich 1095 332 69.6% 08-Jan-95 21:07:00 AmigaBase/Data/Deutsch/Buchhalter.LiesMich.info 7858 2410 69.3% 08-Dec-94 23:38:20 AmigaBase/Data/Deutsch/Kassenbuch 398 156 60.8% 08-Jan-95 21:07:00 AmigaBase/Data/Deutsch/Kassenbuch.info 6615 2965 55.1% 09-Dec-94 14:11:14 AmigaBase/Data/Deutsch/Kassenbuch.LiesMich 1095 336 69.3% 08-Jan-95 21:07:00 AmigaBase/Data/Deutsch/Kassenbuch.LiesMich.info 628 271 56.8% 08-Jan-95 21:07:00 AmigaBase/Data/Deutsch/Memory.info 33902 8800 74.0% 03-Jan-95 18:20:44 AmigaBase/Data/Deutsch/Memory/ab·Memory 5767 2314 59.8% 03-Mar-95 23:52:46 AmigaBase/Data/Deutsch/Memory/ab·Memory.dok 3633 922 74.6% 14-Dec-94 11:58:18 AmigaBase/Data/Deutsch/Memory/ab·Memory.dok.info 3643 921 74.7% 03-Jan-95 18:20:44 AmigaBase/Data/Deutsch/Memory/ab·Memory.info 360 212 41.1% 03-Jan-95 18:14:02 AmigaBase/Data/Deutsch/Memory/rx·Run_ab·Memory 3629 912 74.8% 14-Dec-94 11:58:18 AmigaBase/Data/Deutsch/Memory/rx·Run_ab·Memory.info 14450 3683 74.5% 07-May-94 22:48:04 AmigaBase/Data/Deutsch/MusikKassetten 398 153 61.5% 08-Jan-95 21:07:00 AmigaBase/Data/Deutsch/MusikKassetten.info 1920 823 57.1% 23-May-93 22:12:14 AmigaBase/Data/Deutsch/MusikKassetten.LiesMich 1095 337 69.2% 08-Jan-95 21:07:00 AmigaBase/Data/Deutsch/MusikKassetten.LiesMich.info 2414 796 67.0% 20-Feb-94 22:04:40 AmigaBase/Data/Deutsch/Terminkalender 402 165 58.9% 08-Jan-95 21:07:00 AmigaBase/Data/Deutsch/Terminkalender.info 393 218 44.5% 27-Mar-93 18:01:28 AmigaBase/Data/Deutsch/Terminkalender.LiesMich 1095 334 69.4% 08-Jan-95 21:07:00 AmigaBase/Data/Deutsch/Terminkalender.LiesMich.info 3654 1225 66.4% 13-Jul-94 12:03:26 AmigaBase/Data/Deutsch/Video 398 153 61.5% 08-Jan-95 21:07:00 AmigaBase/Data/Deutsch/Video.info 696 355 48.9% 28-Mar-93 16:20:52 AmigaBase/Data/Deutsch/Video.LiesMich 1095 332 69.6% 08-Jan-95 21:07:00 AmigaBase/Data/Deutsch/Video.LiesMich.info 628 272 56.6% 09-Oct-94 13:09:22 AmigaBase/Data/English.info 172 101 41.2% 19-May-94 22:58:14 AmigaBase/Data/English/.info 3170 967 69.4% 08-May-94 22:34:36 AmigaBase/Data/English/Address 398 155 61.0% 09-Oct-94 13:09:22 AmigaBase/Data/English/Address.info 319 162 49.2% 09-Oct-94 13:53:30 AmigaBase/Data/English/Address.ReadMe 1095 332 69.6% 09-Oct-94 13:09:22 AmigaBase/Data/English/Address.ReadMe.info 2396 819 65.8% 08-May-94 12:02:26 AmigaBase/Data/English/Calendar 402 158 60.6% 09-Oct-94 13:09:22 AmigaBase/Data/English/Calendar.info 329 190 42.2% 28-Mar-93 21:06:50 AmigaBase/Data/English/Calendar.ReadMe 1095 329 69.9% 09-Oct-94 13:09:22 AmigaBase/Data/English/Calendar.ReadMe.info 9542 2949 69.0% 19-May-94 22:31:30 AmigaBase/Data/English/Cassettes 402 160 60.1% 09-Oct-94 13:09:22 AmigaBase/Data/English/Cassettes.info 631 322 48.9% 08-May-94 23:13:18 AmigaBase/Data/English/Cassettes.ReadMe 1095 329 69.9% 09-Oct-94 13:09:22 AmigaBase/Data/English/Cassettes.ReadMe.info 11010 3258 70.4% 08-May-94 12:04:24 AmigaBase/Data/English/Finance 398 158 60.3% 09-Oct-94 13:09:22 AmigaBase/Data/English/Finance.info 2477 687 72.2% 08-May-94 23:15:40 AmigaBase/Data/English/Finance.ReadMe 1095 330 69.8% 09-Oct-94 13:09:22 AmigaBase/Data/English/Finance.ReadMe.info 2702 919 65.9% 08-May-94 12:09:44 AmigaBase/Data/English/Mandel Pictures 402 160 60.1% 09-Oct-94 13:09:22 AmigaBase/Data/English/Mandel Pictures.info 731 341 53.3% 08-May-94 23:11:18 AmigaBase/Data/English/Mandel Pictures.ReadMe 1095 330 69.8% 09-Oct-94 13:09:22 AmigaBase/Data/English/Mandel Pictures.ReadMe.info 16982 5126 69.8% 09-Oct-94 00:34:02 AmigaBase/Data/English/Scheduler 398 153 61.5% 09-Oct-94 13:09:22 AmigaBase/Data/English/Scheduler.info 6010 2461 59.0% 09-Oct-94 12:42:22 AmigaBase/Data/English/Scheduler.ReadMe 1095 329 69.9% 09-Oct-94 13:09:22 AmigaBase/Data/English/Scheduler.ReadMe.info 3572 1172 67.1% 13-Jul-94 12:03:36 AmigaBase/Data/English/Video 398 156 60.8% 09-Oct-94 13:09:22 AmigaBase/Data/English/Video.info 641 326 49.1% 28-Mar-93 22:05:58 AmigaBase/Data/English/Video.ReadMe 1095 329 69.9% 09-Oct-94 13:09:22 AmigaBase/Data/English/Video.ReadMe.info 628 271 56.8% 30-Mar-93 13:32:32 AmigaBase/Data/Graphics.info 35154 25545 27.3% 10-Jul-93 17:03:50 AmigaBase/Data/Graphics/Mandelpic.iff 468 122 73.9% 30-Mar-93 13:32:32 AmigaBase/Data/Graphics/Mandelpic.iff.info 35316 11969 66.1% 03-Mar-95 23:00:26 AmigaBase/HISTORY 1095 331 69.7% 22-Jul-94 16:49:22 AmigaBase/HISTORY.info 6287 1826 70.9% 04-Mar-95 20:01:30 AmigaBase/Install-AB 678 339 50.0% 22-Jul-94 16:51:40 AmigaBase/Install-AB.info 115144 60009 47.8% 12-Jan-93 15:50:22 AmigaBase/Installer 39012 20693 46.9% 16-Jul-94 16:42:42 AmigaBase/libs13/gadget.library 39000 25910 33.5% 08-May-94 20:02:58 AmigaBase/libs13/reqtools.library 42476 27838 34.4% 13-Jul-94 11:46:04 AmigaBase/libs20/reqtools.library 13170 5198 60.5% 04-Mar-95 00:02:16 AmigaBase/LiesMich 1095 330 69.8% 22-Jul-94 16:49:22 AmigaBase/Liesmich.info 628 267 57.4% 22-Jul-94 16:49:22 AmigaBase/MakeCat.info 128446 31307 75.6% 23-Feb-95 22:38:16 AmigaBase/MakeCat/AppStrings.source 467 114 75.5% 07-Apr-93 17:33:20 AmigaBase/MakeCat/AppStrings.source.info 1430 698 51.1% 23-Feb-95 22:38:44 AmigaBase/MakeCat/ReadMe 1095 334 69.4% 07-Apr-93 17:33:20 AmigaBase/MakeCat/ReadMe.info 11285 4435 60.7% 04-Mar-95 20:26:44 AmigaBase/ReadMe 1095 332 69.6% 22-Jul-94 16:49:22 AmigaBase/ReadMe.info 7360 2797 61.9% 26-Feb-95 20:07:20 AmigaBase/TODO 1095 331 69.7% 22-Jul-94 16:49:22 AmigaBase/TODO.info 368 222 39.6% 20-Jan-93 14:32:58 AmigaBase/ToolManager/AmigaBase.brush -------- ------- ----- --------- -------- 1099289 485369 55.8% 21-Mar-95 12:20:04 117 files