Short: Powerful programmable relational database with GUI Author: Steffen Gutmann Uploader: Ralph Reuchlein Type: biz/dbase Kurz: Mächtige programmierbare relationale Datenbank mit GUI Requires: MUI 3.8 Date: 28-Jun-2000 Replaces: MUIbase-1.5.lha Homepage: http://www.amigaworld.com/support/muibase/ MUIbase V1.5 ------------ 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. * Uses MUI as user interface. The interface is highly customizable. External images can be included in the user interface. * 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 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.4 -------------- o Some internal changes to make MUIbase portable. We are now heading towards a Qt port of MUIbase. o Bug fixes and enhancements concerning register groups. o New menu item for deleting all records of a table. o Improved speed for filtering records. o New function (CMP expr1 expr2) that returns an integer representing the order relation of its arguments. o Comparison function for defining record order. See example "Demos/Order.mb" and the user manual. o New menu item for reordering all records of a table. o New order related functions: GETISSORTED, SETISSORTED, REORDER and REORDERALL. o New string functions: RINDEXSTR, RINDEXSTR*, RINDEXBRK, RINDEXBRK*, and COPYSTR. o new i/o functions: FEOF, FSEEK and FTELL. o Avoiding display update when deleting all records. ----- This archive is an update, because in the first release there was no german catalog. 28-Jun-00, Ralph Reuchlein ============================= Archive contents ============================= Original Packed Ratio Date Time Name -------- ------- ----- --------- -------- ------------- 0 0 0.0% 26-Jun-00 14:34:44 + 32736 19286 41.0% 08-Jun-00 19:35:36 +ABConvert 0 0 0.0% 26-Jun-00 14:31:28 + 0 0 0.0% 26-Jun-00 14:31:28 + 36380 13564 62.7% 25-May-00 20:05:48 +MUIbase.catalog 0 0 0.0% 12-Jun-00 17:15:24 + 0 0 0.0% 08-Jun-00 22:43:38 + 27 27 0.0% 05-Nov-97 03:43:12 +.lock 135 62 54.0% 23-Jun-99 08:35:26 +Accounts 14 14 0.0% 05-Nov-97 03:43:12 +Control 2585 951 63.2% 12-Jul-99 08:43:16 +Structure.mb 1870 1307 30.1% 24-Apr-00 20:31:12 +Accounts.mb.info 0 0 0.0% 08-Jun-00 22:43:38 + 27 27 0.0% 05-Nov-97 03:44:06 +.lock 134 80 40.2% 13-Apr-99 01:29:28 +AlbumDb 1267 504 60.2% 13-Apr-99 20:32:10 +SongDb 2224 979 55.9% 13-Apr-99 20:31:44 +Structure.mb 1870 1303 30.3% 24-Apr-00 20:31:12 +Albums.mb.info 0 0 0.0% 08-Jun-00 22:43:38 + 27 27 0.0% 05-Nov-97 04:28:28 +.lock 4 4 0.0% 05-Nov-97 04:28:28 +Control 6616 1791 72.9% 13-Apr-99 20:56:20 +Structure.mb 1870 1306 30.1% 24-Apr-00 20:31:12 +AskDemo.mb.info 0 0 0.0% 08-Jun-00 22:43:38 + 27 27 0.0% 05-Nov-97 04:29:32 +.lock 181 88 51.3% 05-Nov-97 04:29:32 +Controltable 316 121 61.7% 05-Nov-97 04:29:34 +Persontable 4495 1466 67.3% 28-Feb-98 18:21:32 +Structure.mb 1870 1304 30.2% 24-Apr-00 20:31:12 +FamilyTree.mb.info 0 0 0.0% 08-Jun-00 22:43:38 + 27 27 0.0% 05-Nov-97 04:30:20 +.lock 180 127 29.4% 05-Nov-97 04:30:20 +Example 598 281 53.0% 13-Aug-98 23:27:32 +Structure.mb 1870 1302 30.3% 24-Apr-00 20:31:12 +FillMemo.mb.info 512 317 38.0% 11-Apr-99 13:04:30 +ImportFile 0 0 0.0% 08-Jun-00 22:43:38 + 27 27 0.0% 05-Nov-97 04:31:16 +.lock 0 0 0.0% 05-Nov-97 04:31:16 +Person 1082 459 57.5% 11-Apr-99 12:58:26 +Structure.mb 1870 1305 30.2% 24-Apr-00 20:31:12 +ImportSample.mb.info 0 0 0.0% 12-Jun-00 17:15:24 + 27 27 0.0% 12-Jun-00 17:15:24 +.lock 352 193 45.1% 12-Jun-00 17:15:24 +Actors 4312 2293 46.8% 12-Jun-00 17:15:24 +Movies 336 63 81.2% 12-Jun-00 17:15:24 +Relationships 3739 1309 64.9% 12-Jun-00 17:15:24 +Structure.mb 4422 1670 62.2% 12-Jun-00 17:15:24 +Movie.mb.info 0 0 0.0% 08-Jun-00 22:43:38 + 27 27 0.0% 24-Apr-00 20:45:42 +.lock 88 55 37.5% 24-Apr-00 20:45:44 +Persons 1825 850 53.4% 24-Apr-00 20:45:44 +Structure.mb 190 105 44.7% 24-Apr-00 20:45:44 +Toys 1866 1298 30.4% 24-Apr-00 20:45:44 +Order.mb.info 0 0 0.0% 08-Jun-00 22:43:38 + 27 27 0.0% 05-Nov-97 04:33:16 +.lock 101 61 39.6% 05-Nov-97 04:33:16 +Picture 371 205 44.7% 28-Feb-98 18:21:58 +Structure.mb 1870 1303 30.3% 24-Apr-00 20:31:12 +Pictures.mb.info 0 0 0.0% 08-Jun-00 22:43:38 + 27 27 0.0% 05-Nov-97 04:34:20 +.lock 104 69 33.6% 10-May-98 21:11:14 +Popups 1076 463 56.9% 10-May-98 21:11:12 +Structure.mb 1870 1302 30.3% 24-Apr-00 20:31:12 +Popups.mb.info 0 0 0.0% 08-Jun-00 22:43:38 + 27 27 0.0% 24-Apr-00 20:56:40 +.lock 56 38 32.1% 24-Apr-00 20:56:40 +Control 2373 872 63.2% 24-Apr-00 20:56:40 +Structure.mb 1870 1304 30.2% 24-Apr-00 20:56:40 +Sort.mb.info 0 0 0.0% 08-Jun-00 22:43:38 + 27 27 0.0% 26-Dec-97 19:50:04 +.lock 116 56 51.7% 26-Dec-97 20:54:18 +Control 838 366 56.3% 28-Feb-98 18:21:18 +Structure.mb 1866 1299 30.3% 24-Apr-00 20:31:12 +Trigger.mb.info 516 210 59.3% 24-Apr-00 20:31:12 +Demos.info 0 0 0.0% 08-Jun-00 22:43:40 + 0 0 0.0% 08-Jun-00 22:43:40 + 767236 202738 73.5% 07-Jun-00 22:01:46 +MUIbase.dvi 895 434 51.5% 26-Jun-98 20:56:10 +MUIbase.dvi.info 474381 133456 71.8% 07-Jun-00 22:01:34 +MUIbase.guide 911 475 47.8% 26-Jun-98 20:56:10 +MUIbase.guide.info 292022 292022 0.0% 07-Jun-00 22:01:46 +MUIbase.ps.gz 12499 5298 57.6% 07-Jun-00 22:01:52 +MUIbase_1.html 8791 3264 62.8% 07-Jun-00 22:01:52 +MUIbase_10.html 4699 1749 62.7% 07-Jun-00 22:01:52 +MUIbase_11.html 7470 2609 65.0% 07-Jun-00 22:01:52 +MUIbase_12.html 14365 4951 65.5% 07-Jun-00 22:01:52 +MUIbase_13.html 45399 12485 72.4% 07-Jun-00 22:01:52 +MUIbase_14.html 215976 51267 76.2% 07-Jun-00 22:01:52 +MUIbase_15.html 2691 1184 56.0% 07-Jun-00 22:01:52 +MUIbase_16.html 2420 1145 52.6% 07-Jun-00 22:01:52 +MUIbase_17.html 1238 553 55.3% 07-Jun-00 22:01:52 +MUIbase_18.html 12721 2170 82.9% 07-Jun-00 22:01:52 +MUIbase_19.html 4018 1834 54.3% 07-Jun-00 22:01:52 +MUIbase_2.html 14638 3083 78.9% 07-Jun-00 22:01:52 +MUIbase_20.html 5634 2263 59.8% 07-Jun-00 22:01:52 +MUIbase_3.html 29696 9762 67.1% 07-Jun-00 22:01:52 +MUIbase_4.html 31006 10063 67.5% 07-Jun-00 22:01:52 +MUIbase_5.html 13772 4905 64.3% 07-Jun-00 22:01:52 +MUIbase_6.html 16594 5508 66.8% 07-Jun-00 22:01:52 +MUIbase_7.html 12494 4338 65.2% 07-Jun-00 22:01:52 +MUIbase_8.html 7447 2791 62.5% 07-Jun-00 22:01:52 +MUIbase_9.html 18170 6227 65.7% 07-Jun-00 22:01:52 +MUIbase_foot.html 27718 5324 80.7% 07-Jun-00 22:01:52 +MUIbase_toc.html 892 427 52.1% 26-Jun-98 20:56:10 +MUIbase_toc.html.info 561 253 54.9% 07-Mar-00 21:43:02 +Deutsch.info 0 0 0.0% 08-Jun-00 22:43:40 + 646428 157323 75.6% 07-Jun-00 22:06:34 +MUIbase.dvi 895 434 51.5% 26-Jun-98 20:56:10 +MUIbase.dvi.info 414892 110720 73.3% 07-Jun-00 22:06:24 +MUIbase.guide 911 475 47.8% 26-Jun-98 20:56:10 +MUIbase.guide.info 246182 246182 0.0% 07-Jun-00 22:06:36 +MUIbase.ps.gz 10487 4213 59.8% 07-Jun-00 22:06:40 +MUIbase_1.html 7730 2705 65.0% 07-Jun-00 22:06:40 +MUIbase_10.html 4446 1575 64.5% 07-Jun-00 22:06:40 +MUIbase_11.html 6601 2326 64.7% 07-Jun-00 22:06:40 +MUIbase_12.html 13131 4362 66.7% 07-Jun-00 22:06:40 +MUIbase_13.html 41855 10658 74.5% 07-Jun-00 22:06:40 +MUIbase_14.html 199268 44692 77.5% 07-Jun-00 22:06:40 +MUIbase_15.html 2475 1026 58.5% 07-Jun-00 22:06:40 +MUIbase_16.html 2358 1098 53.4% 07-Jun-00 22:06:40 +MUIbase_17.html 945 406 57.0% 07-Jun-00 22:06:40 +MUIbase_18.html 12709 2158 83.0% 07-Jun-00 22:06:40 +MUIbase_19.html 3624 1623 55.2% 07-Jun-00 22:06:40 +MUIbase_2.html 13892 2814 79.7% 07-Jun-00 22:06:40 +MUIbase_20.html 4780 1852 61.2% 07-Jun-00 22:06:40 +MUIbase_3.html 26607 8250 68.9% 07-Jun-00 22:06:40 +MUIbase_4.html 27812 8885 68.0% 07-Jun-00 22:06:40 +MUIbase_5.html 12292 4361 64.5% 07-Jun-00 22:06:40 +MUIbase_6.html 14722 4822 67.2% 07-Jun-00 22:06:40 +MUIbase_7.html 11190 3703 66.9% 07-Jun-00 22:06:40 +MUIbase_8.html 6540 2418 63.0% 07-Jun-00 22:06:40 +MUIbase_9.html 27316 5131 81.2% 07-Jun-00 22:06:40 +MUIbase_toc.html 892 427 52.1% 26-Jun-98 20:56:10 +MUIbase_toc.html.info 561 259 53.8% 07-Mar-00 21:42:54 +English.info 561 267 52.4% 22-Mar-00 20:57:44 +Docs.info 6210 2196 64.6% 16-May-98 22:03:52 +FAQ 929 484 47.9% 22-Mar-00 20:57:44 +FAQ.info 0 0 0.0% 08-Jun-00 22:43:40 + 3694 1739 52.9% 23-Feb-97 11:37:10 +EmptyWindow.iff 929 567 38.9% 26-Jun-98 20:55:50 +EmptyWindow.iff.info 12630 6835 45.8% 25-Feb-97 19:06:02 +EmptyWindow2.iff 929 572 38.4% 26-Jun-98 20:55:50 +EmptyWindow2.iff.info 3810 2771 27.2% 24-Nov-96 15:19:24 +Filmtape.iff 929 569 38.7% 26-Jun-98 20:55:50 +Filmtape.iff.info 182 159 12.6% 26-Jun-97 23:02:34 +LightOff.iff 182 161 11.5% 26-Jun-97 23:02:24 +LightOn.iff 568 412 27.4% 01-Feb-97 19:48:04 +MUIbase.brush 929 565 39.1% 26-Jun-98 20:55:50 +MUIbase.brush.info 23445 23139 1.3% 17-Feb-97 09:22:04 +sg_pic.gif 928 561 39.5% 26-Jun-98 20:55:50 +sg_pic.gif.info 516 213 58.7% 22-Mar-00 20:57:44 +Images.info 16322 4578 71.9% 08-Jun-00 19:39:26 +Install-MUIbase 1916 1045 45.4% 07-Jun-00 22:23:16 +Install-MUIbase.info 464408 220315 52.5% 08-Jun-00 21:28:48 +MUIbase 49388 13258 73.1% 24-Apr-00 14:24:50 +MUIbase.cd 3826 2172 43.2% 22-Mar-00 20:57:44 +MUIbase.info 11742 3176 72.9% 25-May-97 22:25:28 +PortingABPrograms 929 483 48.0% 22-Mar-00 20:57:44 +PortingABPrograms.info 4397 2002 54.4% 07-Jun-00 22:25:10 +ReadMe 929 481 48.2% 22-Mar-00 20:57:44 +ReadMe.info 1083 531 50.9% 01-Jul-97 22:44:12 +ReadMe.mui 0 0 0.0% 08-Jun-00 22:43:40 + 1307 548 58.0% 22-Mar-00 20:53:58 +RegForm_Ascii 554 202 63.5% 22-Mar-00 20:58:14 +RegForm_Ascii.info 30266 3448 88.6% 23-Mar-00 16:34:28 +RegForm_FinalWriter97 440 235 46.5% 22-Mar-00 20:58:14 +RegForm_FinalWriter97.info 1058 537 49.2% 22-Mar-00 20:58:14 +Register.info 6684 1802 73.0% 22-Mar-00 20:44:36 +Register.rexx 561 264 52.9% 22-Mar-00 20:58:14 +Register.info 7170 3089 56.9% 24-May-00 08:44:58 +TODO 929 479 48.4% 22-Mar-00 20:57:44 +TODO.info 0 0 0.0% 08-Jun-00 22:43:40 + 0 0 0.0% 08-Jun-00 22:43:40 + 20772 10417 49.8% 09-Feb-99 02:16:30 +BetterString.mcc 6804 3309 51.3% 28-May-99 00:24:48 +BetterString.mcp 3516 2130 39.4% 28-Feb-99 11:09:40 +HotkeyString.mcc 4584 2313 49.5% 30-Nov-98 21:45:04 +NFloattext.mcc 137292 69217 49.5% 30-Nov-98 21:45:04 +NList.mcc 7488 3521 52.9% 30-Nov-98 21:45:06 +NListview.mcc 32220 11964 62.8% 30-Nov-98 21:45:06 +NListviews.mcp 73096 34961 52.1% 08-Aug-99 01:05:32 +TextEditor.mcc 32584 14061 56.8% 14-Sep-98 21:12:58 +TextEditor.mcp 0 0 0.0% 08-Jun-00 22:43:40 + 31052 14038 54.7% 21-Sep-98 11:06:50 +abconvert 913 488 46.5% 08-Jun-00 22:10:16 MUIbase.info -------- ------- ----- --------- -------- 4950656 1937379 60.8% 30-Jun-100 19:09:04 185 files