The Location Manager is an example application that has been written in Visual Basic, that interacts with the Gnosis Evaluation database. The Location Manager manages a tree of locations starting from the fictional country "Utopia", and demonstrates the following capabilities...

• Managing the data of Business Entities
• Using the generated stored procedure interface to
  • select, insert, update & delete from tables
  • check business objects

• Managing a recursive structure
• Application communication & launch from the Gnosis Work Manager.

Database Objects used by the Location Manager

The Location Manager application updates the Location table, and reads data from the Location Type table and the Parent Location view objects.

Key Constraint business rules are defined in the database for the foreign key constraints shown in this diagram. In addition Check Contraint busainess rules are defined in the database that impose date rules to the Location Tree.

Note: One of the Key Constraint business rules determines which Location Type is allowed to be a child of another Location Type (see the Foreign Key Constraint defined for the view Parent Location to the table Location Type in Location Type which is enforced on Commit - shown as a dashed line).

The Location Manager Main Form. The Location Manager application displays data from the Location table and Parent Location view. Location Type(s) are displayed in the drop down list box.

The toolbar buttons perform the following functions, New Location, Save, Delete, Find Location, Login Defaults, Check Location Object and Exit.