Short: Powerful programmable relational database with GUI Author: Steffen Gutmann Uploader: Steffen Gutmann Type: biz/dbase Kurz: Mächtige programmierbare relationale Datenbank mit GUI Requires: MUI 3.8 Date: 01-Oct-2001 Replaces: MUIbase-1.5.lha Homepage: http://www.muibase.de MUIbase V1.6 ------------ MUIbase is a relational programmable database that uses MUI as user interface. MUIbase is not public domain or free software. If you use MUIbase then you have to register your copy after a short while. You are allowed to install and run MUIbase without registration for a period of 4 weeks. After that time you have to register your copy of MUIbase or delete it from your system. Reinstalling MUIbase does not extend the license. After registration you receive your personal MUIbase key-file which enables all crippled features of MUIbase. For more information about registering MUIbase, see the documentation in the Docs directory. The documentation is available in three formats: AmigaGuide, dvi, and html. Features ======== MUIbase is a fast and very flexible database for the Amiga. It is for users who want to manage data in a comfortable and easy way. MUIbase is able to manage any kind of data, e.g. addresses, CD series, movies, or your income and expense. The power of MUIbase lies in its clear and powerful graphical user interface and its programming capabilities. The latter makes it possible to automatically calculate and maintain nearly everything, starting from automatically summing up values, e.g. for calculating the total amount of income or the total amount of recorded time of a CD, up to automatically creating and printing letters for any purpose. MUIbase is the successor of AmigaBase, a hierarchical programmable database which is still available but considered obsolete with the appearance of MUIbase. All registered users of AmigaBase can get a free upgrade to MUIbase by sending their AmigaBase registration number and return address to me (Email preferred). MUIbase offers the following features: * Handling of multiple projects at the same time. * Attributes can be of type string, memo (multi line text), integer, real, date, time, bool, choice (one item out of many items), reference (easy way to reference a record of another table), button (for starting MUIbase programs), and virtual (compute value on the fly). * The string type can also manage lists of strings, files, and fonts. An OS 3.x datatype gadget allows displaying external images. * Unlimited number of records. * Dynamic loading of records. Records which are not needed may be flushed from memory (e.g. when memory is low). * Programmability. With the easy and powerful MUIbase programming language complex tasks can be implemented. The language also includes a SELECT-FROM-WHERE query for easy and fast data retrieval. * Ordering of records by any combinations of attributes. * Flexible and powerful search and filter facility. * Query editor which allows entering and managing of SELECT-FROM-WHERE queries. The queries can be saved and the results can be printed. * Import and export facility. * Powerful ARexx interface for accessing MUIbase from other programs. The ARexx interface offers a transaction mechanism similar to other relational databases. * Uses MUI as user interface. The interface is highly customizable. External images can be included in the user interface. * Full documentation including user and programming manual in AmigaGuide, HTML, DVI and Postscript. * Portability. MUIbase development has been done under the idea of easy portability. The system/gui part has been separated from the ANSI/C part such that porting MUIbase will result in only porting the system/gui part. The author is currently investigating a Java or Fltk implementation of the user gui. This would make the database available for nearly all computer systems, including Linux, Windows, and MacOS. The unregistered version of MUIbase is crippled in several ways. See the MUIbase documentation for a list of limitations in the unregistered version. New since V1.5 -------------- o ARexx port. The port name is 'MUIbase.n' where n is a number starting from 1 for the first invocation of MUIbase. Besides the usual MUI ARexx commands, the following commands are implemented: - connect - loads project and returns unique handle for future reference. - disconnect - closes project and releases handle. - connections - returns the list of current connections. - eval - Evaluates which can be any MUIbase lisp command and returns result as a string. - transaction - starts a transaction. - commit - saves project to disk. - rollback - reloads project from last saved copy. Each command sets the variable rc and if successful, that is rc = 0, also sets the variable result. E.g. connect sets rc to 0 and result to the connection handle, if successful. You can use the following code fragment to display the result of a MUIbase ARexx command. if (rc == 0) then say result else if (rc <= -10) then say lasterror else if (rc == -1) then say "Implementation error" else if (rc == -2) then say "Out of memory" else if (rc == -3) then say "Unknown command" else if (rc == -4) then say "Command syntax error" else say "Error: " rc The usual way to use the MUIbase ARexx port is 1) check if MUIbase.1 exists. If not, start MUIbase with the -n option to avoid opening the empty window display. 2) Do and store result in a variable called handle. 3) If you just want to do a simple query, call where cmd is any lisp expression which is interpreted and executed by MUIbase. Use single quotes around cmd. This way you can still use double quotes if you need to use strings inside cmd. The result of the cmd expression will be returned as a string, where integers, real numbers, date numbers and time numbers are represented in the usual format, strings and memos are surrounded by double quotes and lists are represented by a starting and closing parenthesis with spaces and newlines around list elements. If your query did changes to the database, these are automatically saved after eval returns (auto commit). 4) If you need a transaction of more than one eval cmd, use to start one, then one or more and finally a to save or to undo the changes in the transaction. 5) Last but no least, do to free the project. If you were in a transaction do not forget a or first, otherwise the disconnect call will come back with an error and you stay connected. o Auto show feature to automatically display referenced records whenever the user switches to another record in a table containing a reference attribute. o Small enhancement for printing queries by offering specification of a custom delimiter string. o Installing a new MUIbase version allows for another 4 weeks of testing for unregistered users. o Improved html documentation thanks to texi2html 1.64. o Some bug fixes. ============================= Archive contents ============================= Original Packed Ratio Date Time Name -------- ------- ----- --------- -------- ------------- 913 484 46.9% 23-Sep-01 02:31:36 MUIbase.info 32772 19299 41.1% 07-Jan-01 13:50:26 +ABConvert 39228 14383 63.3% 24-Sep-01 12:21:30 +MUIbase.catalog 516 210 59.3% 24-Apr-00 09:31:12 +Demos.info 1870 1307 30.1% 24-Apr-00 09:31:12 +Accounts.mb.info 27 27 0.0% 04-Nov-97 17:43:12 +.lock 135 62 54.0% 22-Jun-99 21:35:26 +Accounts 14 14 0.0% 04-Nov-97 17:43:12 +Control 2585 950 63.2% 11-Jul-99 21:43:16 +Structure.mb 1870 1303 30.3% 24-Apr-00 09:31:12 +Albums.mb.info 27 27 0.0% 04-Nov-97 17:44:06 +.lock 134 80 40.2% 12-Apr-99 14:29:28 +AlbumDb 1267 504 60.2% 13-Apr-99 09:32:10 +SongDb 2224 979 55.9% 13-Apr-99 09:31:44 +Structure.mb 1870 1306 30.1% 24-Apr-00 09:31:12 +AskDemo.mb.info 27 27 0.0% 04-Nov-97 18:28:28 +.lock 4 4 0.0% 04-Nov-97 18:28:28 +Control 6616 1790 72.9% 13-Apr-99 09:56:20 +Structure.mb 1870 1304 30.2% 24-Apr-00 09:31:12 +FamilyTree.mb.info 27 27 0.0% 04-Nov-97 18:29:32 +.lock 181 88 51.3% 04-Nov-97 18:29:32 +Controltable 316 121 61.7% 04-Nov-97 18:29:34 +Persontable 4495 1464 67.4% 28-Feb-98 08:21:32 +Structure.mb 1870 1302 30.3% 24-Apr-00 09:31:12 +FillMemo.mb.info 27 27 0.0% 04-Nov-97 18:30:20 +.lock 180 127 29.4% 04-Nov-97 18:30:20 +Example 598 281 53.0% 13-Aug-98 12:27:32 +Structure.mb 512 317 38.0% 11-Apr-99 02:04:30 +ImportFile 1870 1305 30.2% 24-Apr-00 09:31:12 +ImportSample.mb.info 27 27 0.0% 04-Nov-97 18:31:16 +.lock 0 0 0.0% 04-Nov-97 18:31:16 +Person 1082 459 57.5% 11-Apr-99 01:58:26 +Structure.mb 4422 1670 62.2% 12-Jun-00 06:15:24 +Movie.mb.info 27 27 0.0% 12-Jun-00 06:15:24 +.lock 352 193 45.1% 12-Jun-00 06:15:24 +Actors 4312 2292 46.8% 12-Jun-00 06:15:24 +Movies 336 63 81.2% 12-Jun-00 06:15:24 +Relationships 3739 1309 64.9% 12-Jun-00 06:15:24 +Structure.mb 1866 1298 30.4% 24-Apr-00 09:45:44 +Order.mb.info 27 27 0.0% 24-Apr-00 09:45:42 +.lock 88 55 37.5% 24-Apr-00 09:45:44 +Persons 1825 849 53.4% 24-Apr-00 09:45:44 +Structure.mb 190 105 44.7% 24-Apr-00 09:45:44 +Toys 1870 1303 30.3% 24-Apr-00 09:31:12 +Pictures.mb.info 27 27 0.0% 04-Nov-97 18:33:16 +.lock 101 61 39.6% 04-Nov-97 18:33:16 +Picture 371 205 44.7% 28-Feb-98 08:21:58 +Structure.mb 1870 1302 30.3% 24-Apr-00 09:31:12 +Popups.mb.info 27 27 0.0% 04-Nov-97 18:34:20 +.lock 104 69 33.6% 10-May-98 10:11:14 +Popups 1076 462 57.0% 10-May-98 10:11:12 +Structure.mb 1870 1304 30.2% 24-Apr-00 09:56:40 +Sort.mb.info 27 27 0.0% 24-Apr-00 09:56:40 +.lock 56 38 32.1% 24-Apr-00 09:56:40 +Control 2373 871 63.2% 24-Apr-00 09:56:40 +Structure.mb 1866 1299 30.3% 24-Apr-00 09:31:12 +Trigger.mb.info 27 27 0.0% 26-Dec-97 09:50:04 +.lock 116 57 50.8% 26-Dec-97 10:54:18 +Control 838 366 56.3% 28-Feb-98 08:21:18 +Structure.mb 561 267 52.4% 22-Mar-00 10:57:44 +Docs.info 561 260 53.6% 22-Sep-01 16:47:58 +Deutsch.info 765056 212613 72.2% 22-Sep-01 17:23:02 +MUIbase.dvi 895 435 51.3% 22-Sep-01 16:47:58 +MUIbase.dvi.info 494258 139523 71.7% 22-Sep-01 17:22:48 +MUIbase.guide 911 474 47.9% 22-Sep-01 16:47:58 +MUIbase.guide.info 5861 1654 71.7% 22-Sep-01 17:23:22 +MUIbase.html 892 420 52.9% 22-Sep-01 16:47:58 +MUIbase.html.info 600808 501729 16.4% 22-Sep-01 17:23:10 +MUIbase.pdf 895 429 52.0% 22-Sep-01 16:47:58 +MUIbase.pdf.info 366944 366944 0.0% 22-Sep-01 17:23:12 +MUIbase.ps.gz 895 432 51.7% 22-Sep-01 16:47:58 +MUIbase.ps.gz.info 14936 5997 59.8% 22-Sep-01 17:23:22 +MUIbase_1.html 12115 4202 65.3% 22-Sep-01 17:23:22 +MUIbase_10.html 7471 2480 66.8% 22-Sep-01 17:23:22 +MUIbase_11.html 10530 3515 66.6% 22-Sep-01 17:23:22 +MUIbase_12.html 18549 5952 67.9% 22-Sep-01 17:23:22 +MUIbase_13.html 53536 14216 73.4% 22-Sep-01 17:23:22 +MUIbase_14.html 286617 61685 78.4% 22-Sep-01 17:23:24 +MUIbase_15.html 24597 7069 71.2% 22-Sep-01 17:23:24 +MUIbase_16.html 4668 1711 63.3% 22-Sep-01 17:23:24 +MUIbase_17.html 13984 2576 81.5% 22-Sep-01 17:23:24 +MUIbase_18.html 4401 1673 61.9% 22-Sep-01 17:23:24 +MUIbase_19.html 6374 2520 60.4% 22-Sep-01 17:23:22 +MUIbase_2.html 3519 1216 65.4% 22-Sep-01 17:23:24 +MUIbase_20.html 26040 3554 86.3% 22-Sep-01 17:23:24 +MUIbase_21.html 25525 4329 83.0% 22-Sep-01 17:23:24 +MUIbase_22.html 26032 3638 86.0% 22-Sep-01 17:23:24 +MUIbase_23.html 25215 4292 82.9% 22-Sep-01 17:23:24 +MUIbase_24.html 10692 2012 81.1% 22-Sep-01 17:23:24 +MUIbase_25.html 7839 2899 63.0% 22-Sep-01 17:23:22 +MUIbase_3.html 32180 10532 67.2% 22-Sep-01 17:23:22 +MUIbase_4.html 40987 12222 70.1% 22-Sep-01 17:23:22 +MUIbase_5.html 17532 5869 66.5% 22-Sep-01 17:23:22 +MUIbase_6.html 22946 6972 69.6% 22-Sep-01 17:23:22 +MUIbase_7.html 15638 5251 66.4% 22-Sep-01 17:23:22 +MUIbase_8.html 10687 3713 65.2% 22-Sep-01 17:23:22 +MUIbase_9.html 2535 979 61.3% 22-Sep-01 17:23:24 +MUIbase_abt.html 18277 6619 63.7% 22-Sep-01 17:23:24 +MUIbase_fot.html 3182 1211 61.9% 22-Sep-01 17:23:24 +MUIbase_ovr.html 32840 6957 78.8% 22-Sep-01 17:23:24 +MUIbase_toc.html 561 261 53.4% 22-Sep-01 16:48:32 +English.info 655796 165887 74.7% 21-Sep-01 16:55:26 +MUIbase.dvi 895 432 51.7% 22-Sep-01 16:48:32 +MUIbase.dvi.info 433153 116187 73.1% 21-Sep-01 16:55:22 +MUIbase.guide 911 474 47.9% 22-Sep-01 16:48:32 +MUIbase.guide.info 5749 1591 72.3% 21-Sep-01 16:55:42 +MUIbase.html 892 422 52.6% 22-Sep-01 16:48:32 +MUIbase.html.info 851747 501959 41.0% 21-Sep-01 16:55:34 +MUIbase.pdf 895 431 51.8% 22-Sep-01 16:48:32 +MUIbase.pdf.info 312945 312945 0.0% 21-Sep-01 16:55:34 +MUIbase.ps.gz 895 432 51.7% 22-Sep-01 16:48:32 +MUIbase.ps.gz.info 13045 4980 61.8% 21-Sep-01 16:55:42 +MUIbase_1.html 10991 3658 66.7% 21-Sep-01 16:55:42 +MUIbase_10.html 7196 2282 68.2% 21-Sep-01 16:55:42 +MUIbase_11.html 9612 3105 67.6% 21-Sep-01 16:55:42 +MUIbase_12.html 17239 5331 69.0% 21-Sep-01 16:55:42 +MUIbase_13.html 50260 12391 75.3% 21-Sep-01 16:55:42 +MUIbase_14.html 268456 54639 79.6% 21-Sep-01 16:55:44 +MUIbase_15.html 22712 6135 72.9% 21-Sep-01 16:55:44 +MUIbase_16.html 4447 1536 65.4% 21-Sep-01 16:55:42 +MUIbase_17.html 13190 2361 82.1% 21-Sep-01 16:55:42 +MUIbase_18.html 4297 1568 63.5% 21-Sep-01 16:55:42 +MUIbase_19.html 5927 2269 61.7% 21-Sep-01 16:55:42 +MUIbase_2.html 3155 1061 66.3% 21-Sep-01 16:55:42 +MUIbase_20.html 26015 3530 86.4% 21-Sep-01 16:55:42 +MUIbase_21.html 26292 4324 83.5% 21-Sep-01 16:55:42 +MUIbase_22.html 25961 3577 86.2% 21-Sep-01 16:55:42 +MUIbase_23.html 24760 4225 82.9% 21-Sep-01 16:55:42 +MUIbase_24.html 7859 1361 82.6% 21-Sep-01 16:55:42 +MUIbase_25.html 7032 2525 64.0% 21-Sep-01 16:55:42 +MUIbase_3.html 29091 9039 68.9% 21-Sep-01 16:55:42 +MUIbase_4.html 37660 10882 71.1% 21-Sep-01 16:55:42 +MUIbase_5.html 16007 5268 67.0% 21-Sep-01 16:55:42 +MUIbase_6.html 20893 6186 70.3% 21-Sep-01 16:55:42 +MUIbase_7.html 14214 4611 67.5% 21-Sep-01 16:55:42 +MUIbase_8.html 9754 3172 67.4% 21-Sep-01 16:55:42 +MUIbase_9.html 2509 963 61.6% 21-Sep-01 16:55:42 +MUIbase_abt.html 3151 1187 62.3% 21-Sep-01 16:55:42 +MUIbase_ovr.html 32436 6717 79.2% 21-Sep-01 16:55:42 +MUIbase_toc.html 6210 2195 64.6% 16-May-98 11:03:52 +FAQ 929 484 47.9% 22-Mar-00 10:57:44 +FAQ.info 516 213 58.7% 22-Mar-00 10:57:44 +Images.info 3694 1739 52.9% 23-Feb-97 01:37:10 +EmptyWindow.iff 929 567 38.9% 26-Jun-98 09:55:50 +EmptyWindow.iff.info 12630 6833 45.8% 25-Feb-97 09:06:02 +EmptyWindow2.iff 929 572 38.4% 26-Jun-98 09:55:50 +EmptyWindow2.iff.info 3810 2771 27.2% 24-Nov-96 05:19:24 +Filmtape.iff 929 569 38.7% 26-Jun-98 09:55:50 +Filmtape.iff.info 182 159 12.6% 26-Jun-97 12:02:34 +LightOff.iff 182 161 11.5% 26-Jun-97 12:02:24 +LightOn.iff 568 412 27.4% 01-Feb-97 09:48:04 +MUIbase.brush 929 565 39.1% 26-Jun-98 09:55:50 +MUIbase.brush.info 23445 23445 0.0% 16-Feb-97 23:22:04 +sg_pic.gif 928 561 39.5% 26-Jun-98 09:55:50 +sg_pic.gif.info 16808 4690 72.0% 23-Jun-01 23:57:46 +Install-MUIbase 1916 1047 45.3% 23-Jun-01 23:53:18 +Install-MUIbase.info 21068 10565 49.8% 14-Jan-01 05:10:22 +BetterString.mcc 6972 3442 50.6% 14-Jan-01 05:10:22 +BetterString.mcp 3516 2130 39.4% 28-Feb-99 04:09:40 +HotkeyString.mcc 4584 2313 49.5% 30-Nov-98 11:45:04 +NFloattext.mcc 137292 69198 49.5% 30-Nov-98 11:45:04 +NList.mcc 7488 3520 52.9% 30-Nov-98 11:45:06 +NListview.mcc 32220 11957 62.8% 30-Nov-98 11:45:06 +NListviews.mcp 73524 35383 51.8% 14-Jan-01 05:10:46 +TextEditor.mcc 32584 14054 56.8% 14-Sep-98 13:12:58 +TextEditor.mcp 480156 227597 52.5% 24-Sep-01 20:57:08 +MUIbase 52640 13968 73.4% 23-Sep-01 13:40:56 +MUIbase.cd 3826 2172 43.2% 22-Mar-00 10:57:44 +MUIbase.info 11742 3175 72.9% 25-May-97 11:25:28 +PortingABPrograms 929 483 48.0% 22-Mar-00 10:57:44 +PortingABPrograms.info 7252 3017 58.3% 23-Jun-01 23:45:18 +ReadMe 929 481 48.2% 22-Mar-00 10:57:44 +ReadMe.info 1085 533 50.8% 23-Jun-01 23:45:36 +ReadMe.mui 561 264 52.9% 22-Mar-00 10:58:14 +Register.info 1350 561 58.4% 23-Sep-01 13:55:16 +RegForm_Ascii 554 202 63.5% 22-Mar-00 10:58:14 +RegForm_Ascii.info 1058 537 49.2% 22-Mar-00 10:58:14 +Register.info 6667 1788 73.1% 24-Jun-01 00:11:42 +Register.rexx 319 183 42.6% 18-Mar-01 08:40:32 +address.rx 373 180 51.7% 18-Mar-01 13:31:46 +connections.rx 679 328 51.6% 18-Mar-01 13:47:50 +movies.rx 455 220 51.6% 18-Mar-01 13:54:56 +shell.rx 7128 3072 56.9% 23-Jun-01 23:39:50 +TODO 929 479 48.4% 22-Mar-00 10:57:44 +TODO.info -------- ------- ----- --------- -------- 7104952 3214668 54.7% 02-Oct-101 19:53:20 184 files