Advanced programming


In the previous chapters, you learned how to develop classes based on the iPlus framework, create your own assemblies and database models and design the user interface. However, these changes were only carried out on the own development database - just how are these changes rolled out to customers or made available to other developers?


Roll out and register assemblies (step 2)

In the Composition section you have learned how new classes are registered for the iPlus runtime . In your case, this means when your new or changed assembly is shipped or deployed, only the latest hard-coded functionality is available.


Update database model (step 1)

Before doing so, your database model or the iPlus database model must be brought up to date . Therefore, the SQL scripts from the DBScripts directory are executed (login with the Ctrl key) first.


Transfer database changes (step 3)

Designs , Texts, messages , Methods (scripts) , Application trees and application definitions , Configurations , Application data are stored in the database. The majority of your work is therefore in the SQL database and less hard-coded in the assemblies. Without this data, your project will not be able to run at all. The changes from your development database must therefore also be transferred to other target systems. Either made available to other developers or transported to a production system at your customer's.

Large systems such as SAP speak of a so-called "Change-Request -Management"and Transport Requests.

A similar transport mechanism offers you iplus:


The transfer of database changes can take place in two different ways :

  1. Active: Data is transferred from one database to another database by the user himself. The transfer can either take place directly via two database connections or indirectly via writing and then reading XML files (shared folder principle).
  2. Passive:  The data are exported as ZIP archives and integrated into the Visual Studio project of the corresponding assemblies. When the assemblies are rolled out on the target system, these ZIP archives are automatically extracted during the registration process and imported into the target database.

First read the following chapter on how you can actively transfer the changes and create ZIP archives for the passive variant:

 


Place ZIP archives, that you created with the export program, in the "VBControlScripts"-subfolder of your Visual Studio project. (This folder may only be named like this!):

 

  1. Add the ZIP archive in the project tree.
  2. In the properties window, set the "Copy to output directory" setting to "Copy always".

During the compilation process, the ZIP archives from all assemblies are stored (copied) together in the target directory "bin\Release\VBControlScripts". Do not forget to copy the VBControlScripts directory when you deploy it on the target system!

 

Important NOTE:

Your ZIP archives should only contain the data that fits to the corresponding assembly and the classes. Therefore, do not create archives containing, for example, designs belonging to classes from other assemblies!