RE: Re: RE: Re: SQL Editor Issue

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.

From: [email protected] [mailto:[email protected]] On Behalf Of ScottJM
Sent: Thursday, January 05, 2012 11:58 AM
To: [email protected]
Subject: [toad] Re: RE: Re: SQL Editor Issue [1 Attachment]

[Attachment(s) from ScottJM included below]



Message from: ScottJM


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.


_______________________________________

Historical Messages


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



Attachment(s) from ScottJM

1 of 1 Photo(s)
[Image removed by sender. TC.gif]<http://groups.yahoo.com/group/toad/attachments/folder/1015704121/item/1512629848/view>
TC.gif<http://groups.yahoo.com/group/toad/attachments/folder/1015704121/item/1512629848/view>