Under construction

Adding tables and fields

   if adding a table, then create the necessary enum values

        only the table needs the Ivo version property applied

        add default data records if necessary

    if just adding a field to an existing table, then make sure the Ivo version property is set

    once added in the cDatabaseDef classes, nothing more is needed

Update version in project properties

    when you do this is dependent on what you need to test.  If testing the addition of new tables and/or fields, then you would need to change this setting in order to test.

    the data file records the version in tblDatabaseInfo.  When the software runs it checks this value.  If the software version is less that the data file version, then the software shows a message and won't run.  This would generally only happen if something prevented the software from upgrading before connecting to the data file.

If the software version is greater than the data file version then it runs the update code

    when you run the software in the IDE, it starts with the "Choose Database - Dev" form (frmChooseDatabaseDev).  This form has options to create backups of data files you are working with, and easily delete a file and re-copy from its backup.  Eg. if you are testing whether your upgrade procedure is working the 

If you need to delete a table 

    there are two options -

    occasionally we need to replace a lookup table, so what we do is delete it here -

   then just update the Ivo version value in the table's definition procedure and it will be automatically re-created

    sometimes we just need to get rid of a table.  It could be added to the above location, or explicitly deleted in the upgrade procedure (if one is required)

If changes are required as part of the update,

    if, for example, you need to run queries to set default values for new fields, or to otherwise modify data based on changes

    Update What's new settings?