Team Coding - Compile Doesn't

Toad for Oracle - Beta
1

I discovered this morning that if I pull a script into my Editor that has not been checked out from Team Coding, if I try to compile it I get the check-out dialog from Team Coding, which I expect. What I didn’t expect is that after the object is checked out, I have to again press F9 to compile because the compile did not actually happen. This is specifically happening on View. This does not appear to be happening with Packages because they check out when I open the files from the TC Manager. (Views don’t appear to automatically check out when I open them using the F4 - Script - Send Script to Editor option - maybe this is part of the problem/solution)

I would expect that if I ask Toad to compile, even if it has to do something else first, that the compile would happen when it can. :slight_smile:

Blessings,

Phyllis

–
Phyllis Helton

Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org

2

Hey Phyllis,

Are you sure it isn’t compiling the object? It seems to be doing that in my tests here. It’s just not sending notification to the Script Output tab to let you know it was created.

When you copied the view into the editor, did it also include the DROP statement and other ancillary statements besides the “CREATE OR REPLACE” statement? Are you removing those before pressing F9? For example, in a test view locally, Toad copied the following script to the editor when I described a view:

DROP
VIEW TKD_SCHOOL.SCHOOLVIEW;

/* Formatted on 7/19/2016 10:58:18 AM (QP5 v5.295) */

CREATE
OR
REPLACE
FORCE
VIEW TKD_SCHOOL.SCHOOLVIEW

OF
TKD_SCHOOL.SCHOOL

WITH
OBJECT
IDENTIFIER
(CITY,
MANAGER, SQUARE_FOOTAGE)

BEQUEATH

DEFINER

AS

SELECT

FROM SCHOOLS_TABLE;

COMMENT
ON
TABLE TKD_SCHOOL.SCHOOLVIEW IS
‘test’;

CREATE
OR
REPLACE
PUBLIC
SYNONYM SCHOOLVIEW FOR TKD_SCHOOL.SCHOOLVIEW;

In this case, I would need to move the cursor to within the CREATE OR REPLACE statement in order to use F9. When I do that and follow through the code, it is prompting the user to check out the object, and does appear to execute the CREATE or REPLACE statement successfully.

Can you provide an example of one that doesn’t appear to be working correctly?

-John

From: phyllis.helton_1150 [mailto:bounce-phyllishelton_1150@toadworld.com]

Sent: Tuesday, July 19, 2016 10:44 AM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Team Coding - Compile Doesn’t

Team Coding - Compile Doesn’t

Thread created by phyllis.helton_1150

I discovered this morning that if I pull a script into my Editor that has not been checked out from Team Coding, if I try to compile it I get the check-out dialog from Team Coding, which I expect. What I didn’t expect is that after the object is checked out, I have to again press F9 to compile because the compile did not actually happen. This is specifically happening on View. This does not appear to be happening with Packages because they check out when I open the files from the TC Manager. (Views don’t appear to automatically check out when I open them using the F4 - Script - Send Script to Editor option - maybe this is part of the problem/solution)

I would expect that if I ask Toad to compile, even if it has to do something else first, that the compile would happen when it can. :slight_smile:

Blessings,

Phyllis

–

Phyllis Helton

Data Magician

Digital Products & Strategies, Cru | Data Sciences & Analytics

Office :phone: 407-515-4452

phyllis.helton@cru.org

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

3

Hi John,

It didn't include the DROP statement (maybe I have an option set?), but it did include the grants. I was most certainly in the text of the view.

And the way I figured it didn't compile was that my changes didn't "take". I was removing some code from multiple views and after I was done I did an object search to find the reference to the table I had removed and found the 4 views I had just changed.

I just tried this again the way I had done it this morning. I opened the schema browser and went to the Views. Selected a view and went to the script tab. Clicked on the "Send to Editor". Changed one thing in the view (in this case, I removed AS before an alias name) and selected F9 to compile. The TC dialog came up, I clicked ok and then F4 on the view name and viewed the script. The AS is still there.

Let me know if there is anything else I can tell you about this. . .

Blessings,

Phyllis

On Tue, Jul 19, 2016 at 11:29 AM, John Bowman bounce-jbowman@toadworld.com wrote:

RE: Team Coding - Compile Doesn't

Reply by John Bowman
Hey Phyllis,

Are you sure it isn’t compiling the object? It seems to be doing that in my tests here. It’s just not sending notification to the Script Output tab to let you know it was created.

When you copied the view into the editor, did it also include the DROP statement and other ancillary statements besides the “CREATE OR REPLACE” statement? Are you removing those before pressing F9? For example, in a test view locally, Toad copied the following script to the editor when I described a view:

DROP
VIEW TKD_SCHOOL.SCHOOLVIEW;

/* Formatted on 7/19/2016 10:58:18 AM (QP5 v5.295) */

CREATE
OR
REPLACE
FORCE
VIEW TKD_SCHOOL.SCHOOLVIEW

OF
TKD_SCHOOL.SCHOOL

WITH
OBJECT
IDENTIFIER
(CITY,
MANAGER, SQUARE_FOOTAGE)

BEQUEATH

DEFINER

AS

SELECT

FROM SCHOOLS_TABLE;

COMMENT
ON
TABLE TKD_SCHOOL.SCHOOLVIEW IS
'test';

CREATE
OR
REPLACE
PUBLIC
SYNONYM SCHOOLVIEW FOR TKD_SCHOOL.SCHOOLVIEW;

In this case, I would need to move the cursor to within the CREATE OR REPLACE statement in order to use F9. When I do that and follow through the code, it is prompting the user to check out the object, and does appear to execute the CREATE or REPLACE statement successfully.

Can you provide an example of one that doesn’t appear to be working correctly?

-John

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.

--
Phyllis Helton

Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org

4

Hey Phyllis,

Ø It didn’t include the DROP statement (maybe I have an option set?), but it did include the grants. I was most certainly in the text of the view.

That’s quite possible you have specific options set… Those can be found in your “View/Edit Script Options” toolbutton (left-most button in the view’s script toolbar).

That is so weird… I just followed your exact steps in both Toad 12.9 and Toad 12.10 beta:

  1.  Connected to a TC-controlled database

  2.  Opened Schema Browser

  3.  Pressed F4 on a controlled view (in my case, the SCHOOLVIEW example).  Sent the script to the editor without the DROP statement.

  4.  In my case, simply added a comment (“/* This is a test */”) before the “FROM” keyword

  5.  Pressed F9

  6.  Team Coding prompted me to check out the object.  Pressed OK.

  7.  Object was checked out and compile was run.

  8.  Moved my cursor over the SCHOOLVIEW name in the editor.

  9.  Pressed F4 to describe the object and switched to the script tab.

  10. The new comment was there.

I repeated these steps to remove the comment as well, and it appeared to work correctly. Have you tried resetting your user files? Perhaps something in there is preventing the compilation from executing correctly?

-John

From: phyllis.helton_1150 [mailto:bounce-phyllishelton_1150@toadworld.com]

Sent: Tuesday, July 19, 2016 2:03 PM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Team Coding - Compile Doesn’t

RE: Team Coding - Compile Doesn’t

Reply by phyllis.helton_1150

Hi John,

It didn’t include the DROP statement (maybe I have an option set?), but it did include the grants. I was most certainly in the text of the view.

And the way I figured it didn’t compile was that my changes didn’t “take”. I was removing some code from multiple views and after I was done I did an object search to find the reference to the table I had removed and found the 4 views I had just changed.

I just tried this again the way I had done it this morning. I opened the schema browser and went to the Views. Selected a view and went to the script tab. Clicked on the “Send to Editor”. Changed one thing in the view (in this case, I removed AS before an alias name) and selected F9 to compile. The TC dialog came up, I clicked ok and then F4 on the view name and viewed the script. The AS is still there.

Let me know if there is anything else I can tell you about this. . .

Blessings,

Phyllis

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

5

Interesting. I was putting off getting rid of my user files because of all the templates and other useful things I have set up, but today this is working as expected after I had my computer shut down overnight.

So apparently, this is somehow related to having Toad open too long.

Thanks for your help, John!

On Tue, Jul 19, 2016 at 2:24 PM, John Bowman bounce-jbowman@toadworld.com wrote:

RE: Team Coding - Compile Doesn't

Reply by John Bowman
Hey Phyllis,

Ø It didn't include the DROP statement (maybe I have an option set?), but it did include the grants. I was most certainly in the text of the view.

That’s quite possible you have specific options set… Those can be found in your “View/Edit Script Options” toolbutton (left-most button in the view’s script toolbar).

That is so weird… I just followed your exact steps in both Toad 12.9 and Toad 12.10 beta:

  1.  Connected to a TC-controlled database

  1.  Opened Schema Browser

  1.  Pressed F4 on a controlled view (in my case, the SCHOOLVIEW example).  Sent the script to the editor without the DROP statement.

  1.  In my case, simply added a comment (“/* This is a test */”) before the “FROM” keyword

  1.  Pressed F9

  1.  Team Coding prompted me to check out the object.  Pressed OK.

  1.  Object was checked out and compile was run.

  1.  Moved my cursor over the SCHOOLVIEW name in the editor.

  1.  Pressed F4 to describe the object and switched to the script tab.
  1. The new comment was there.

I repeated these steps to remove the comment as well, and it appeared to work correctly. Have you tried resetting your user files? Perhaps something in there is preventing the compilation from executing correctly?

-John

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.

--
Phyllis Helton

Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org