MUIbase
A relational programmable database
Version 1.3
18 December 1999
Steffen Gutmann
MUIbase Copying Conditions
Registration
Registration fee
Payment methods
Ordering
Method of delivery
Distribution
Disclaimer
MUI
BetterString & TextEditor
Additional custom classes
Icons
Welcome to MUIbase
Getting started
Installing MUIbase
Required hardware
Required software
Starting the installation
Key-file
Starting MUIbase
Quitting MUIbase
Tutorial
How MUIbase works
Starting with a project, the structure-editor
Adding a table
Adding an attribute
Displaying the project
Adding two reference attributes
Adding records
Filter
Queries
Adding a table with a memo and a button attribute
Programming MUIbase to do a pedigree
Programming MUIbase to list a person's children
Basic concepts
Projects
Tables
Records
Attributes
Attribute types
String attributes
Integer attributes
Real attributes
Bool attributes
Choice attributes
Date attributes
Time attributes
Memo attributes
Reference attributes
Virtual attributes
Buttons
Table of attribute types
Memory consumption
Relationships
One to one relationships
One to many relationships
Many to many relationships
User interface
Windows
Masks
Panels
Attribute objects
Text objects
Images
Space objects
Groups
Balance objects
Register groups
Managing projects
File format
Info
Clear project
Open project
Save project
Delete project
Close project
Swap records
Preferences
Record memory
Record delete requester
External editor for programming
Icon creation
Formats
Icon tool name
External editor
External viewer
Popups in cycle chain
Confirm save & reorg
Confirm quit
Program include directory
Program debug information
Program output file
Project dependent settings
MUI
Loading and Saving of preferences
Empty display image
Record-editing
Active object
Adding records
Changing records
String attributes with pop-up button
Entering bool values
Entering choice values
Entering date values
Entering time values
Memo context menu
Entering reference values
Entering NIL value
Deleting records
Browsing records
Filter
Record filter
Filter expression
Changing filters
Filter examples
Reference filter
Order
Empty order
Order by attributes
Changing orders
Search for
Search requester
Forward/backward search
Search pattern examples
Import and Export
File format
Sample import file
Importing records
Exporting records
Data retrieval
Select-from-where queries
Query editor
Printing queries
Query examples
Structure editor
Table management
Creating tables
Changing tables
Deleting tables
Sorting tables
Attribute management
Creating attributes
Type specific settings
Label editor
Changing attributes
Deleting attributes
Sorting attributes
Display management
Display field
Panel editor
Attribute object editor
Type specific settings
Text editor
Image editor
Space editor
Group editor
Register group editor
Window editor
Print structure
Programming MUIbase
Program editor
Preprocessing
#define
#undef
#include
#if
#ifdef
#ifndef
#elif
#else
#endif
Programming language
Why lisp?
Lisp syntax
Kinds of programs
Name conventions
Accessing record contents
Data types for programming
Constants
Command syntax
Defining commands
DEFUN
DEFUN*
DEFVAR
Program control functions
PROGN
PROG1
LET
SETQ
SETQ*
FUNCALL
IF
CASE
COND
DOTIMES
DOLIST
DO
FOR ALL
NEXT
EXIT
RETURN
HALT
ERROR
Type predicates
Type conversion functions
STR
MEMO
INT
REAL
DATE
TIME
Boolean functions
AND
OR
NOT
Comparison functions
Mathematical functions
Adding values
Subtracting values
1+
1-
Multiplying values
Dividing values
DIV
MOD
MAX
MIN
ABS
TRUNC
ROUND
RANDOM
String functions
LEN
LEFTSTR
RIGHTSTR
MIDSTR
SETMIDSTR
INSMIDSTR
INDEXSTR
INDEXSTR*
INDEXBRK
INDEXBRK*
REPLACESTR
REMCHARS
TRIMSTR
WORD
WORDS
CONCAT
CONCAT2
UPPER
LOWER
ASC
CHR
LIKE
SPRINTF
Memo functions
LINE
LINES
MEMOTOLIST
LISTTOMEMO
FILLMEMO
FORMATMEMO
INDENTMEMO
List functions
CONS
LIST
LENGTH
FIRST
REST
LAST
NTH
APPEND
REVERSE
MAPFIRST
SORTLIST
SORTLISTGT
Input requesting functions
ASKFILE
ASKDIR
ASKSTR
ASKINT
ASKCHOICE
ASKCHOICESTR
ASKOPTIONS
ASKBUTTON
ASKMULTI
I/O functions
FOPEN
FCLOSE
stdout
PRINT
PRINTF
FPRINTF
FERROR
FGETCHAR
FGETCHARS
FGETSTR
FGETMEMO
FPUTCHAR
FPUTSTR
FPUTMEMO
FFLUSH
Record functions
NEW
NEW*
DELETE
DELETE*
DELETEALL
GETMATCHFILTER
SETMATCHFILTER
RECNUM
COPYREC
Attribute functions
ATTRNAME
MAXLEN
GETLABELS
SETLABELS
Table functions
TABLENAME
GETORDERSTR
SETORDERSTR
GETFILTERACTIVE
SETFILTERACTIVE
GETFILTERSTR
SETFILTERSTR
RECORDS
RECORD
SELECT
Gui functions
SETCURSOR
GETDISABLED
SETDISABLED
GETWINDOWDISABLED
SETWINDOWDISABLED
GETWINDOWOPEN
SETWINDOWOPEN
Project functions
PROJECTNAME
CHANGES
System functions
EDIT
EDIT*
VIEW
VIEW*
SYSTEM
STAT
TACKON
FILENAME
DIRNAME
TODAY
NOW
MESSAGE
GC
Pre-defined variables
Pre-defined constants
Functional parameters
Type specifiers
Semantics of expressions
Function triggering
onOpen
onClose
onChange
New trigger
Delete trigger
Attribute trigger
Programming virtual attributes
ABConvert
Acknowledgments
Author
Function index
Concept index
This document was generated on 18 December 1999 using the
texi2html
translator version 1.52.