-
Title
MS VSS Team Coding configuration differences in version 9.5 and the previous version. -
Description
Version 9.1 of Toad is configured for VSS Team Coding. Code Control Group is not used to export object to VSS. Objects are saved to VSS working directory and compile on the database. The Check In/Out takes place in Version Control Browser. When object is opened through Version Control Browser, it's Editor status is "Uncontrolled" and object is editable.
One user has upgraded to version 9.5. The same Check In/Out process takes place, however, opening the object, results in a "Read-Only" status in Editor and object is not editable. Under Team Coding Status, the "Apply Team Coding to all Objects" is unchecked. -
Cause
There is an existing record in TC_Group table. This row was created some time ago in previous versions by user, however, Code Control Groups were never used to export objects to VSS. In version 9.5, regardless of "Apply Team Coding to all Objects" being checked or not, as long as there is a row in this table, Toad will set a Read-Only status on all objects until they are exported through the Code Control Group. This is a change of behavior between 9.5 and version 9.1.
-
Resolution
1. Select Schema Browser | TOAD Schema | Tables.
2. Select TC_Group table and under Data tab, remove all records, by selecting the Minus "-" icon and hit Commit icon.
3. This deletion will automatically delete all associated rows in TC_Mask table, through its trigger.
4. Open a new Version Control Browser to Check Out/In and open objects.