EULANDA® ERP System Head Start thru Technology
SQL
Registry API
All field are hyperlinks to the respective documents.
The EULANDA® SQL registry serves for storage of the system adjustments, hierarchical, adjustment information user settings and system information.
Contrary to the Windows® registry, the SQL registry will be saved central in the EULANDA® Database of the SQL server. Each workstation could evaluate the registry settings. Copying of the database and with it saving on a laptop, you only have to copy the EULANDA® database file.
The registry will be saved in the Registry table. Newer versions of EULANDA® will be use the cnRegBlob, cnRegKey, cnRegText and cnRegValue tables. You have no reading or writing access to that tables. You only have to use the SQL registry editor for registry access or the Stored-Procedures for the administration of the SQL registry with the Prefix cn_Reg.
Direct changes at the SQL registry could be endanger the system stability . For this reason you should make a data backup before changing the settings in the SQL registry. The data backup could be accomplished from export the root.
During the changing of the SQL registry the registry will be held in the cache. Changes will be write on the SQL server after leaving the EULANDA®. If you want to write back the changes into the SQL server you should use the Standalone SQL registry editor, you find the editor on the EULANDA®-CD below the file \cnsoft\eulanda. The data name is EulRegEd.exe.
The handling of the SQL registry editors is described in the chapter Systemverwaltung.
Hint:
If you change the SQL registry, you should export and save the changes.
After a program update which will write back the standard value, you only
have to read back the backup. For simplification of the export of
different files you can use the marker mode, which you could find in the
work on menu. The export refers then to the marked objects.