RE: Re: RE: Re: RE: Re: RE: Re: SQL Editor Issue

Scott ,
There are several issues here.

The menu items in your menu are from 10.6 but the Toad Bundle is using the terminology from Toad 11. First confirm that you are running Toad 11 (overstating the obvious but you never know).  It is possible your tool bars did not update when you did the upgrade to Toad 11.
 Right click on your  main Toolbar click 'Restore Defaults' also make sure the 'Team Coding' toolbar is checked in this menu. This is just until we can figure out what is going on.

The utility menu should now look like this

[cid:[email protected]]



It looks like the version of Team Coding is not correct for Toad 11. You should  be able to select Configure Team Coding. This may be 'read only'  if you are not a Team Coding Administrator. You should get a message to tell you that Team Coding requires an upgrade.  A Team Coding administrator or DBA user  needs to do this.

If you want to disable Team Coding, you must be a Team Coding Administrator to disable or uninstall Team Coding, in the Configure Team Coding Menu.


Team Coding Code Collections should be enabled. You should be able to  display the collections and the File Mask values. If any line shows something like *.* this could be the issue. A Team Coding Administrator can modify this mask.

Let's see if any of this helps.

Stephen


From: [email protected] [mailto:[email protected]] On Behalf Of ScottJM
Sent: Thursday, January 05, 2012 2:51 PM
To: [email protected]
Subject: [toad] Re: RE: Re: RE: Re: RE: Re: SQL Editor Issue



Message from: ScottJM


From Support Bundle:

************************************************************************
TEAM CODING
************************************************************************
TEAM CODING STATUS FOR CONNECTION [xxxxxx]
Team Coding Version : 6.0
Enable Team Coding : True
Use Code Collections : True
Use 3rd Party Version Control : True
Mirror Schemas : True
Apply Team Coding to all Objects : False
Update Database After Check-In : False
Force Comment During Check-In : False
Script File Extensions : *.sql;
Provider Name : SVN
Provider Initialized : True
Provider Connected : False
Message log :
8:54:01 AM: Team Coding Objects found in schema TOAD
8:54:01 AM: Detected Team Coding Support version 6.0, installed by TOAD
The Team Coding Support on this database is an older version which is not compatible with this release of TOAD. To enable Team Coding, the Team Coding Support Objects must be updated using the Team Coding Configuration Installer. This task should be performed by a database administrator.

8:54:02 AM: Provider initialized:



_______________________________________

Historical Messages


Author: ScottJM
Date: Thu Jan 05 11:50:37 PST 2012

From Support Bundle:

************************************************************************
TEAM CODING
************************************************************************
TEAM CODING STATUS FOR CONNECTION [xxxxxx]
Team Coding Version : 6.0
Enable Team Coding : True
Use Code Collections : True
Use 3rd Party Version Control : True
Mirror Schemas : True
Apply Team Coding to all Objects : False
Update Database After Check-In : False
Force Comment During Check-In : False
Script File Extensions : *.sql;
Provider Name : SVN
Provider Initialized : True
Provider Connected : False
Message log :
8:54:01 AM: Team Coding Objects found in schema TOAD
8:54:01 AM: Detected Team Coding Support version 6.0, installed by TOAD
The Team Coding Support on this database is an older version which is not compatible with this release of TOAD. To enable Team Coding, the Team Coding Support Objects must be updated using the Team Coding Configuration Installer. This task should be performed by a database administrator.

8:54:02 AM: Provider initialized:


__

Author: Stephen.Beausang_734
Date: Thu Jan 05 11:14:54 PST 2012
Scott, I gave you some wrong information in an earlier reply. If you are using 10.6 or lower then the Team Coding information would be in Utilities - Team Coding - Code Control Groups. We changed the Terminology in Toad 11. Could Team Coding be enabled from a prior installation ? First, can you check your support bundle in Help-Support Bundle you can copy or email. This will give information on whether Team Coding is enabled and which version. Stephen
__

Author: Stephen.Beausang_734
Date: Thu Jan 05 09:30:48 PST 2012
I do not think that Team Coding is the cause of this issue. I think this is one for Quest Support
__

Author: Simoneau, Roger
Date: Thu Jan 05 09:30:48 PST 2012
Perhaps it's file system related. Something at the file system level is registering as having the file open (triggering the read-only). If the file is marked read only when you open it, from what I recall of the behavior of Toad, it will be greyed out. The underlying Windows system registers when something has been opened and sometimes it won't let you do anything with the file while it is opened by the other software. From what I've observed, it's certainly not consistent in its behavior. From recollection it's been quite some time since I even ran into the situation. I do recall that it wasn't Toad I ran into it with... but I can't recall any of the specific circumstances where it's occurred. Additionally, attempts to "recreate" the issue are all failing. Roger S.
__

Author: ScottJM
Date: Thu Jan 05 09:30:48 PST 2012
That's kind of the point; I'm not using team coding.  Nothing has been checked out, nothing has been checked in, and I'm not trying to check anything in.  Also, I do not see the option either of you refer too;  "Team Coding Collections".  All I have access too is what you see in the screen shot I provided.
__

Author: Stephen.Beausang_734
Date: Thu Jan 05 08:57:55 PST 2012
Scott, I agree with Brad. The fact the menu items for Check in, check out etc are all disabled suggests that the active object in the editor is not controlled by team coding. If it were locked by Team Coding the Check Out and Get Latest options would be enabled. Something else may be going on. I would also like to see the value(s) of Code Collection File Masks in Utilties-Team Coding-Team Coding code collections. Stephen
__

Author: Brad Boddicker
Date: Thu Jan 05 08:57:55 PST 2012
What if you save to a different directory on your machine? Is general source control setup? Options > Source control At this point, it could be a number of things and I highly suggest going to Quest Support with this issue. they are better equipped for these kinds of things.
__

Author: ScottJM
Date: Thu Jan 05 08:57:55 PST 2012

I run and save "select sysdate from dual" and it then becomes "Disabled" so I'm not sure which objects could be included.

Attached is what I see regarding Team Coding.

__

Author: Brad Boddicker
Date: Thu Jan 05 07:27:43 PST 2012
Maybe your SQL statement includes DDL for a controlled object? You will have to access Team Coding configuration to see which DB objects are being controlled. Go to Utilities > Team Coding > Team coding code collections to see this.
__

Author: ScottJM
Date: Thu Jan 05 07:23:42 PST 2012
Can someone explain why having Team Coding enabled in the database would prevent me from running a saved SQL statement that is saved ONLY on my machine?
__

Author: ScottJM
Date: Wed Dec 21 10:33:44 PST 2011
Well it looks like it is enabled.  But I don't see what that has to do with being able to edit a sql statement that only exists on my hard drive.  It's my statement.  I wrote it and I'm the only one who executes it.  What does team coding have to do with that?  I'm not trying to be harsh.  I've never used or even looked at team coding in Toad so I'm not really sure what it's all about.  I just don't see how, or why, these things are related.
__

Author: Brad Boddicker
Date: Wed Dec 21 08:13:33 PST 2011
Hi Scott, Is Team Coding enabled on your database? What do you see when you go to Utilities > Team Coding > Team coding status?
__

Author: ScottJM
Date: Tue Dec 20 14:40:35 PST 2011
Hi,
I'm using Toad 11.  I type a SQL statement in an editor window and run it and all is fine.  Now I want to save the statement to use later.  After I save it the editor window is now "Disabled".  I can no longer edit the statement or anything.  This seems to be happening will all statements I type.  After I save I can no longer make changes to them.  After saving the word "Disabled" appears in the status bar at the bottom of the screen.  What can I do to correct this?
__
_______________________________________