Introduction
Changing Data
Distributing Your New Front End |
Distributing your new Front End When 'SSW Data PRO!' is used to make changes in the backend database, all the changes are logged. Every time you make a structural change to the database, 'SSW Data PRO!' records this in the table 'zsDPDataChange'. Once you process the change, 'SSW Data PRO!' will then make the change to the back end. At the same time a log record is created in the backend table '_zsDataVersion' When the front end is distributed, it checks whether the backend is old and needs upgrading. If old, the front end will automatically make all the necessary changes in the back end. Note: You do not need to install 'SSW Data PRO!' on clients machine. Just include 'DataPRO97.mde' or 'DataPRO2000.mde' in the same directory as the application.
For users using 'SSW Data PRO!' reference in the front end application Remove the 'SSW Data PRO!' reference from your from end application. Delete the function 'bolSSWDataPROUpgrade()' from macro 'Autoexec'. Import the following from the 'SSW Data PRO!' version 13.4 or greater installation:
Modules
'basSSW1_OpenDialog_aGetFileName_v6' and 'basSSWDataPROUpgradeNoReference_v1'
and macro 'SSWSampleAutoExec_v1' from file 'SSWDataPROUtilities(97/2000).mdb'
Now you can simply follow the
steps described above in 'Upgrading the backend'. For users using 'SSW Data PRO!' without reference in the front end application Delete the following form your front end application basSSW1_OpenDialog_aGetFileName_v6 (Module) basSSWDataPROUpgradeNoReference_v1 (Module) SSWSampleAutoExec_v1 (Macro) Import the following from the 'SSW Data PRO!' version 13.4 or greater installation:
Modules
'basSSW1_OpenDialog_aGetFileName_v6' and 'basSSWDataPROUpgradeNoReference_v1'
and macro 'SSWSampleAutoExec_v1' from file 'SSWDataPROUtilities(97/2000).mdb' Now you can simply follow the steps described above in 'Upgrading the backend'.
Now you can issue the new front end database version that you have just completed to your clients. The above upgrading process will give you peace of mind because you know that your database will check the clients current data version (in '_zsVersion Data') and compare it with the current version required (in 'zsDPDataVersion') before performing any necessary upgrades. However, before distributing your database make certain it has been put through the First Time Use process. This is because the data.mdb you release must have the system table '_zsDataVersion' in it, as the next time you send your application (that will include 'SSW Data PRO!') it will look for this table so it can determine what version it is. Enhancement for version less then 14.9. You have to delete the old version of basSSWDataPROUpgradeNoReference_v1 in client front end application, for example in NortwindApplication and add a new version of the module basSSWDataPROUpgradeNoReference_v2 there. You copy the module basSSWDataPROUpgradeNoReference_v2 from SSWUtilities97/SSWUtilities2000.mdb. Compile and save all modules. We hope you enjoy using 'SSW Data PRO!'. The 'SSW Data PRO!' Team. |
|||