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

I do not think that Team Coding is the cause of this issue. I think this is one for Quest Support



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



Message from: ScottJM


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.

_______________________________________

Historical Messages


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?
__
_______________________________________