How to create a new database


This can be a very convenient feature. Say, for example, you wish to maintain a personal rolodex or a database of your suppliers or vendors, etc., this feature helps you to do so.


H2OS was not designed to be a general purpose database management system, but in fact it do share some attributes with such software. Once such is the ability to create additional databases and to switch between them as needed.  


Because these mechanics exist for our use, we could not resist including them in H2OS for your use, but be advised that there are some limitations.



  1. New databases are created with the same (exact) fields as your H2OS customers database. This means some fields used specifically for customer records will also appear in your new database, some of which will not be needed, so they will be 'dead weight'.

  2. Database names are limited to 7 characters at this time (however, the database name as displayed on the H2OS main screen can be changed to a longer visual name, so this is basically an internal H2OS limitation).

  3. All databases created on a given installation must be owned by a single customer named H2OS.

  4. You may add (and remove/rename) fields defined in your database. Always backup your database first before changing database fields, and then be sure to test your system carefully, restoring if any problems occur.


To create a new database, example


On the menu system, select File -> New -> Database




On the Explorer screen, in the Customer/Project panel, right click on H2OS


(note: H2OS must be the owning customer/project; a limitation, see above).



Select "Create a database for this customer"


A screen like this will appear:




For this demo, I'll create a "vendors" database:


Note that the name must be 7 characters or less, no spaces or special characters permitted (see limitations, above)




Enter a database name and description


Click Setup This Database Now, and a message like this will appear:






Click OK and a screen like this will appear:


Note: databases are organized as having one more 'lists' within them. In this case we're defining a database with a single 'list', i.e. this database will not have multiple 'lists'.



Enter a List Name and description.


Note: use the same description for the list as the database itself



Click SAVE and a message like this will appear




click NO (we want only 1 'list' in our database, but could have defined many), and the system will return to the Explorer page showing the newly created VENDORS database




Close this screen to return to the main H2OS screen.


You can now make the Vendors database the current database, and switch between it and your other H2OS databases, during subsequent sessions.