Upgrading from SuperOffice 4.0.0.25 SQL Anywhere to SuperOffice 4.02 SQL Anywhere.

This is a two-step operation. The first operation is to install the new SuperOffice 4.0.2 programfiles, and the second is to run a SQL-script on your 4.0.0.25 database to correct a database problem.

Install the new SuperOffice 4.0.2 programfiles.
Insert the SuperOffice CD or disk 1 and run setup.exe from the root directory. Select your installation language and click "Continue". Select Multi-User, Update (Program Files Only). Find SUPEROF4.EXE on your network (P:\superoff\superof4.exe in this example). Click Install to complete the installation and follow the instructions on screen.

The update is complete.

Running the SQL script.

THIS IS VERY IMORTANT:

  • Make a backup of your SuperOffice 4.0 database (superof4.db) before you run this script.
  • Do not run this script if the database has been upgraded once before. This will corrupt all documents in your database.

Connect to the SUPEROF4 database using Interactive SQL (C:\SQLANY50\WIN\ISQLW.EXE).

Press the F7 key, select so.appointment and click "Columns..":

              1. If the last line in the so.appointment windows is document_id,
              then               DO NOT run the SQL script. Skip this part and continue to
              upgrade the SuperOffice 4.02 programfiles.

If the last line in the so.appointment window is userdef_id, run the script called UPGR402. Select "Open" from the File-menu in Interactive SQL and select the file \SUPEROFF\INIT\UPGR402.SQL. In this example this will be P:\SUPEROFF\INIT\UPGR402.SQL.

The Command-window will now be filled with command lines. Click Execute to run the script. The script is fully executed when the Execute button is active again, and you can exit Interactive SQL.

The database upgrade is complete.