# While using Team Coding, if 'Execute Snippet' is used, it completely by passes Team Coding

**URL:** <https://forums.toadworld.com/t/while-using-team-coding-if-execute-snippet-is-used-it-completely-by-passes-team-coding/38774>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [December 6, 2016, 2:28pm UTC](https://forums.toadworld.com/t/while-using-team-coding-if-execute-snippet-is-used-it-completely-by-passes-team-coding/38774 "2016-12-06T14:28:24Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![cdegeest\_61243](https://avatars.discourse-cdn.com/v4/letter/c/b9bd4f/32.png) [@cdegeest\_61243](https://forums.toadworld.com/u/cdegeest_61243)\
**Post date:** [December 6, 2016, 2:28pm UTC](https://forums.toadworld.com/t/while-using-team-coding-if-execute-snippet-is-used-it-completely-by-passes-team-coding/38774/1 "2016-12-06T14:28:24Z")

</div>

Hello,

We are using Team Coding with Git. If a new object is created using the ‘Execute Snippet’ (CTRL+ENTER or SHIFT+F9) it will complete bypass Team Coding. The object does not need to be locked, no new file is created in Git and no new object is created in Team Coding. This seems like a problem to me. The only workaround I can find is to modify the ‘Execute Statement’ short cut and set it to ‘CTRL+ENTER’ or whatever the developer would normally use so that the modifications are actually stored in Git.

Is this a bug? Any other suggestions on how to avoid this problem?

I’m using Toad 12.9 and Toad 12.10 - it occurs in both.

---

<div class="post-metadata">

**Author:** ![ButtonPusher](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/buttonpusher/32/147_2.png) [@ButtonPusher](https://forums.toadworld.com/u/ButtonPusher)\
**Post date:** [December 7, 2016, 4:09am UTC](https://forums.toadworld.com/t/while-using-team-coding-if-execute-snippet-is-used-it-completely-by-passes-team-coding/38774/2 "2016-12-07T04:09:53Z")

</div>

When you’re running the script, are the objects fully qualified with the controlled schema name? Or are you logged in as the controlled schema? This may make a difference

---

<div class="post-metadata">

**Author:** ![ButtonPusher](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/buttonpusher/32/147_2.png) [@ButtonPusher](https://forums.toadworld.com/u/ButtonPusher)\
**Post date:** [December 7, 2016, 4:46am UTC](https://forums.toadworld.com/t/while-using-team-coding-if-execute-snippet-is-used-it-completely-by-passes-team-coding/38774/3 "2016-12-07T04:46:45Z")

</div>

I apologize, I read “execute snippet” as “execute script”. Yes, execute snippet, Ctrl+enter, Shift+f9 (all the same thing) bypasses team coding.

I believe this was done by design some time back, but it doesn’t seem to make much sense anymore. We will have to see what the developer has to say about this one.

---

<div class="post-metadata">

**Author:** ![cdegeest\_61243](https://avatars.discourse-cdn.com/v4/letter/c/b9bd4f/32.png) [@cdegeest\_61243](https://forums.toadworld.com/u/cdegeest_61243)\
**Post date:** [December 7, 2016, 5:34am UTC](https://forums.toadworld.com/t/while-using-team-coding-if-execute-snippet-is-used-it-completely-by-passes-team-coding/38774/4 "2016-12-07T05:34:28Z")

</div>

Thanks Brad. By the way, the “workaround” I thought I had does not work either. It seems you are unable to override the CTRL+ENTER short cut. (At least I have not found a way)

I’m attempting to transition some long time Toad users to adopt Team Coding, but for folks who use this short cut multiple times daily, it will be a tough habit to break. Asking them to change the way they work doesn’t always get a pleasant response

---

<div class="post-metadata">

**Author:** ![ButtonPusher](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/buttonpusher/32/147_2.png) [@ButtonPusher](https://forums.toadworld.com/u/ButtonPusher)\
**Post date:** [December 7, 2016, 5:44am UTC](https://forums.toadworld.com/t/while-using-team-coding-if-execute-snippet-is-used-it-completely-by-passes-team-coding/38774/5 "2016-12-07T05:44:55Z")

</div>

I can certainly understand this, but be aware, there is now an option to make F9/Execute/compile work similar to Ctrl+Enter/Shift+F9. Check out Options \> Execute/Compile \> Treat blank line as statement terminator. As far as overwriting the shortcut, R-click on the main toolbar and select “menu shortcuts”. Look in the “Editor” category and you can configure your shortcuts there. You can map Shift+F9 to “execute statement” and delete the mapping for “Execute Snipped”.

---

<div class="post-metadata">

**Author:** ![cdegeest\_61243](https://avatars.discourse-cdn.com/v4/letter/c/b9bd4f/32.png) [@cdegeest\_61243](https://forums.toadworld.com/u/cdegeest_61243)\
**Post date:** [December 7, 2016, 6:53am UTC](https://forums.toadworld.com/t/while-using-team-coding-if-execute-snippet-is-used-it-completely-by-passes-team-coding/38774/6 "2016-12-07T06:53:01Z")

</div>

Brad,

Thanks for the information. I was able to override the Shift+F9 shortcut but I can’t seem to override the Ctrl+Enter shortcut (which is the one my developer is currently using).

---

<div class="post-metadata">

**Author:** ![ButtonPusher](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/buttonpusher/32/147_2.png) [@ButtonPusher](https://forums.toadworld.com/u/ButtonPusher)\
**Post date:** [December 7, 2016, 7:59am UTC](https://forums.toadworld.com/t/while-using-team-coding-if-execute-snippet-is-used-it-completely-by-passes-team-coding/38774/7 "2016-12-07T07:59:19Z")

</div>

Unfortunately that one can not currently be overwritten. The proper fix on our side is to have Team Coding respect Shft+F9/Ctrl+Enter

---

<div class="post-metadata">

**Author:** ![jbowman](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jbowman/32/22_2.png) [@jbowman](https://forums.toadworld.com/u/jbowman)\
**Post date:** [December 7, 2016, 10:06am UTC](https://forums.toadworld.com/t/while-using-team-coding-if-execute-snippet-is-used-it-completely-by-passes-team-coding/38774/8 "2016-12-07T10:06:13Z")

</div>

Yep, this does look like a bug. This should be fixed in tomorrow’s beta.

Thanks for bringing this issue to our attention!

-John

---

<div class="post-metadata">

**Author:** ![cdegeest\_61243](https://avatars.discourse-cdn.com/v4/letter/c/b9bd4f/32.png) [@cdegeest\_61243](https://forums.toadworld.com/u/cdegeest_61243)\
**Post date:** [December 7, 2016, 10:31am UTC](https://forums.toadworld.com/t/while-using-team-coding-if-execute-snippet-is-used-it-completely-by-passes-team-coding/38774/9 "2016-12-07T10:31:39Z")

</div>

Excellent! Thanks John.
