In very rare cases it may be necessary to force a version downgrade, for example installing an incompatible version of ProCal
Version checking only takes place in Version 6 of software onward.
These instructions assume that you have SQL Server Management Studio installed.
- Using SQL Server Management Studio (referred to a SSMS throughout the rest of this instructions) connect to your ProCal SQL Server Instance. Typically this will be in the format [ServerComputerName]/TRANSMILLE (assuming that the default Instance name has been used). You will need a valid username and password.
- In the navigation Pane on the left, click the small + next to databases and then click the + next to ProCal
Click + next to tables and then navigate to dbo.Software_Versions - Please note that the tables on your database will vary depending upon the version as well as any customized trigger tables
Right Click on dbo.Software_Version and select 'Edit Top 200 Rows'
Select the Software that needs downgrading, in this example we are selecting ProCal, and downgrading from 6.5.14 to 6.5.10
Edit the appropriate column, in this example we are editing the 'Minor_Revision' Column. Type the new number into the table Note that the text int he bottom of the window updates to 'Cell Is Modified' and the left most column updates to a picture of a pen
Using the arrow keys, navigate up or down (whatever is possible) to a new row. The data is now saved. Make sure that a new cell is selected otherwise the data will not be saved
Place the old ..exe files in either your local folder (for single users) or in your system updates folder and make sure that all users of the system copy the new .exe files across to their computer. If any computer with a newer version re-connects the software table will be updated again.