Lolli’s Website

Here I will present my hobbies, occupation and family.

May 28th, 2008

Foreign keys and the visible element

english german 

Trying to get a way how to model a relation from one table to another and also providing some information, what column would be visible, if a foreign key is shown in a form is the question for this posting.

The following picture shows how it could be done:

Foreign key visible column problem

The directional associations from the Formulare class pointing to the formulare entity having the following meaning:

On the Formulare class:

name = visible field from foreign key anwendungid pointing to the anwendungen entity
beschreibung = visible field from foreign key typ pointing to the formulartypen entity

Is this an understandable notation or is the following better (autoshow_fkey, visible) ?

Zweite Variante

May 18th, 2008

Modelling with UML - current problems

english german 

Here I would like to tell someting about how could be created an application prototype with the help of UML.

In my first posting, I have written about UML, I’ve created the UML model a little bit different. It was about a small CRM. After some thinking about it and with reading some literature, I have encountered that my model should look a little bit different.

In the basic I would use a correct representation, but also it should do the same as it has done before.

In a sample should the changed representation described and also the problems be shown, that I currently have.

We would like to have a table to be displayed in a form, who has links to other entries in the same table. For sample an article table storing texts with crosslinks to other articles in the same table.

That means, one article could have nothing to many crosslinks, but this is not a must.

With this I define a primary table and a second one. The second table should have two foreign keys, because it links two articles. My problem hereby is the display in comparsion to the entered data in the dialog. In the dialog I enter for each aggregate the name in the field Name in ArtikelTexte that should be the name of the foreign key.

I do not understand the meaning of the diagram why the Name appears on the table Querverweis.

Der Prototyp:

texteprototyp.png

Das UML Diagramm:

Das UML Klassendiagramm

Die Einstellungen zu den Aggregaten:

Einstellungen zu Link1

Einstellungen zu Link2

March 29th, 2008

Turbo Vision sample created

english german 

A long time ago I would do it. Now it is time.

The idea to have database applications on a DOS window is not bad. Although it is a bit unusual nowadays :-)

Here is my first try. The application has been fully generated what is possible with XML:

A Turbo Vision based database application

October 17th, 2007

lbDMF 1.0rc2 has been released

english german 

Yesterday I have released version 1.0rc2 of my software. It is both, a bugfix release and an enhancement.
The build was broken, because of missing source code. The enhancements are as follows:

Store configuration in local files to speed up the loading of application definitions. (Caching)
No more requirement of system database when local file is available. (Moved out SQL code to visitor operations)

I do still need testers…

Enjoy.