Toad World® Forums

Teamcoding and generated tables

Hi,

in my project I generate tables still from Designer and sometimes from housemade scripts. So these tables are created outside TOAD. I see why TOAD can’t add these to teamcoding. So what I’m missing is a TeamCoding option from the Tables tab in de schemabrowser, for example for packages and views there is an option, for a checkout. Is there another way to add more not known objects to TeamCoding in a easy way?

Thanks

Herald ten Dam

Which version of Toad are you running? Starting in 12.7, when you open the TC Admin window and click OK, Toad cross references the objects in the TC tables and the actual controlled schemas and if there are any additional objects found in the schema(s), they are added to TC.

From: herald.ten.dam [mailto:bounce-heraldtendam@toadworld.com]

Sent: Wednesday, March 30, 2016 10:27 AM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Teamcoding and generated tables

Teamcoding and generated tables

Thread created by herald.ten.dam

Hi,

in my project I generate tables still from Designer and sometimes from housemade scripts. So these tables are created outside TOAD. I see why TOAD can’t add these to teamcoding. So what I’m missing is a TeamCoding option from the Tables tab in de schemabrowser, for example for packages and views there is an option, for a checkout. Is there another way to add more not known objects to TeamCoding in a easy way?

Thanks

Herald ten Dam

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Disclaimer: I’m assuming you’re not controlling “all schemas” in which case this won’t happen

From: Brad Boddicker

Sent: Wednesday, March 30, 2016 10:39 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Teamcoding and generated tables

Which version of Toad are you running? Starting in 12.7, when you open the TC Admin window and click OK, Toad cross references the objects in the TC tables and the actual controlled schemas and if there are any additional objects found in the schema(s), they are added to TC.

From: herald.ten.dam [mailto:bounce-heraldtendam@toadworld.com]

Sent: Wednesday, March 30, 2016 10:27 AM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Teamcoding and generated tables

Teamcoding and generated tables

Thread created by herald.ten.dam

Hi,

in my project I generate tables still from Designer and sometimes from housemade scripts. So these tables are created outside TOAD. I see why TOAD can’t add these to teamcoding. So what I’m missing is a TeamCoding option from the Tables tab in de schemabrowser, for example for packages and views there is an option, for a checkout. Is there another way to add more not known objects to TeamCoding in a easy way?

Thanks

Herald ten Dam

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Hi Brad,

I use the latest beta, so I will try this in the morning.

Is it possible to add checkout also to the tables tab, or is there a reason not to do?

Herald

As far as the SB right click in the SB goes, if an object has not yet been added to the TC Tables, then “check out” will not be available. I don’t think there is any way around this unless we add more checks on R-click which could have an impact on performance.

From: herald.ten.dam [mailto:bounce-heraldtendam@toadworld.com]

Sent: Wednesday, March 30, 2016 12:17 PM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Teamcoding and generated tables

RE: Teamcoding and generated tables

Reply by herald.ten.dam

Hi Brad,

I use the latest beta, so I will try this in the morning.

Is it possible to add checkout also to the tables tab, or is there a reason not to do?

Herald

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

I take this back. This behavior has changed in the 12.9 beta. We now check to see if the object matches a TC team project rather than checking for its existence in the TC tables, so the R-click should show “check-out” as available for newly added objects.

Are you not seeing this?

From: Brad Boddicker

Sent: Wednesday, March 30, 2016 1:23 PM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Teamcoding and generated tables

As far as the SB right click in the SB goes, if an object has not yet been added to the TC Tables, then “check out” will not be available. I don’t think there is any way around this unless we add more checks on R-click which could have an impact on performance.

From: herald.ten.dam [mailto:bounce-heraldtendam@toadworld.com]

Sent: Wednesday, March 30, 2016 12:17 PM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Teamcoding and generated tables

RE: Teamcoding and generated tables

Reply by herald.ten.dam

Hi Brad,

I use the latest beta, so I will try this in the morning.

Is it possible to add checkout also to the tables tab, or is there a reason not to do?

Herald

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Hi Brad,

I did this test:

Table: begin execute immediate (’ create table test (name varchar2(20))’ ); end.

Table is created and I go to Schema browser to tab Tables. there is no TeamCoding option for table Test.

Procedure: begin execute immediate (’ create procedure ptest as begin null; end;’ ); end.

Procedure is created and I go to Schema browser to tab Procedures. there is a TeamCoding option for procedure Ptest.

My project consists of a schema with all objects included.

Herald

I can’t reproduce this. I created the table just like you did, using an anonymous block, went to SB > tables, R-click on the table > Team Coding > check out is available. SB status bar tells me the new table is “available” as well. Using the latest beta.

Are you using a VCS provider with Team Coding?

From: herald.ten.dam [mailto:bounce-heraldtendam@toadworld.com]

Sent: Thursday, March 31, 2016 4:18 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Teamcoding and generated tables

RE: Teamcoding and generated tables

Reply by herald.ten.dam

Hi Brad,

I did this test:

Table: begin execute immediate (’ create table test (name varchar2(20))’ ); end.

Table is created and I go to Schema browser to tab Tables. there is no TeamCoding option for table Test.

Procedure: begin execute immediate (’ create procedure ptest as begin null; end;’ ); end.

Procedure is created and I go to Schema browser to tab Procedures. there is a TeamCoding option for procedure Ptest.

My project consists of a schema with all objects included.

Herald

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

I use Git with TeamCoding.

Herald

Another note, I have teamcoding not at all for tables, so neither new ones or even the old already more times checkedin/checkedout.

Herald

Sorry, I don’t follow you. Maybe send a screenshot of your Team Project definition?

From: herald.ten.dam [mailto:bounce-heraldtendam@toadworld.com]

Sent: Thursday, March 31, 2016 10:40 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Teamcoding and generated tables

RE: Teamcoding and generated tables

Reply by herald.ten.dam

Another note, I have teamcoding not at all for tables, so neither new ones or even the old already more times checkedin/checkedout.

Herald

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Simple, no option for Teamcoding on tables.

I can’t send a screenshot, but TC is simple all objects for 1 schema.

I have Teamcoding options for views/procedures/functions, so only on tables it is missing

Herald

Better yet, please send a support bundle.

Thanks,

Brad

From: herald.ten.dam [mailto:bounce-heraldtendam@toadworld.com]

Sent: Thursday, March 31, 2016 10:40 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Teamcoding and generated tables

RE: Teamcoding and generated tables

Reply by herald.ten.dam

Another note, I have teamcoding not at all for tables, so neither new ones or even the old already more times checkedin/checkedout.

Herald

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Maybe better for you, but impossible for me )-; The internal development client is not connected and no connection to internet, seperated networks and no workaround for me to get stuff from internal to internet. Maybe my problem had to do with the start of this beta cycle in which I had problems to setup TeamCoding in combination with Git. The new team project setup messed up sometimes with every new beta. It is now stable but maybe something in between messes up now my right mouse. It is only for tables now and the next weeks I will not make new ones, so less problems for me.

Would it be an option to recreate completely TeamCoding? It will take some time with a lot of objects and my delivery scripts will mess up, but the later I can fix easily.

Herald

Herald,

I apologize if I’m misunderstanding you here, but I thought you were reporting an issue where the TC R-click in the SB to “check out” was not available for newly created tables. You are now telling me that you are not controlling tables in TC. If you’re not controlling tables in TC then you should not have a TC r-click available for tables in the SB, ever.

We don’t have many beta users for Team Coding so we definitely appreciate you sticking it out. TC has undergone a complete re-write during this beta cycle so I’m not surprised you would run into issues from beta to beta. Of course, for users upgrading from previous commercial versions of TC, they will be fine upgrading to TC when 12.9 commercial version is released. We run through a ton of upgrade scenarios for each commercial release. We just don’t do this for every beta release :).

The good news is that all of the major structural TC changes are done for this beta cycle. So if you are willing, I would suggest removing your Team Projects and setting them back up from scratch to get a fresh start ( be sure to empty out your TC tables for good measure, the last icon in the TC Config screen). Also, R-click in Toad’s main toolbar and select “restore defaults” so you get all of the updated toolbar buttons in the TC Manager. If you have a previous version of TC on your DB (12.6 or older), you could also uninstall TC completely then re-install and migrating your old TC setup (you will see the migrate option when you install TC).

Thanks and let us know how it goes.

Brad

From: herald.ten.dam [mailto:bounce-heraldtendam@toadworld.com]

Sent: Thursday, March 31, 2016 2:26 PM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Teamcoding and generated tables

RE: Teamcoding and generated tables

Reply by herald.ten.dam

Maybe better for you, but impossible for me )-; The internal development client is not connected and no connection to internet, seperated networks and no workaround for me to get stuff from internal to internet. Maybe my problem had to do with the start of this beta cycle in which I had problems to setup TeamCoding in combination with Git. The new team project setup messed up sometimes with every new beta. It is now stable but maybe something in between messes up now my right mouse. It is only for tables now and the next weeks I will not make new ones, so less problems for me.

Would it be an option to recreate completely TeamCoding? It will take some time with a lot of objects and my delivery scripts will mess up, but the later I can fix easily.

Herald

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Brad,

Another misunderstanding. I use all objects TOAD puts in teamcoding, also tables (I miss scheduled jobs and materialized views for example as objects). I have 1 teamproject with 4 schemas included and checkboxes are all on and included all on % (default :wink: ) .

I miss TeamCoding as an option on tables in SB, but have it for all the other objects, even on objects mentioned above as missing, although it only shows “LOGON to VCS”, the rest is grayed out.

I will look at removing TC completely on Monday, no time left today. Luckily for me I started fresh from 12.8, but switched shortly after release to the 12.9 beta because of the changes for naming directories and files (and that gave initial problems). So I can start again (no migration needed), because the structured is maintained also in Git for me, and I made release related stuff in other tables.

What I want to mention, I did today an " UNDO CHECKOUT" of a package. TC sees this nicely, but doesnt’t put the old code (from GIT) back in the database as I would thought. Is this intended because now database and GIT are out-of-sync without a checkout?

Thanks

Herald

As far as your last paragraph goes, TC does do any kind of database revert, or auto-compile on undo. So in your case, you check something out, alter it, then compile in DB. At this point if you “udno checkout”, Toad will only undo the checkout in VCS/TC and you will be out of sync with your DB. This is the designed behavior. We don’t want to get in the business of auto-compiling objects in the DB. We feel that this could be over-reaching and harmful.

I’m hopeful that once you set everything back up again from scratch the tables TC right-click will be restored for you.

From: herald.ten.dam [mailto:bounce-heraldtendam@toadworld.com]

Sent: Friday, April 01, 2016 8:44 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Teamcoding and generated tables

RE: Teamcoding and generated tables

Reply by herald.ten.dam

Brad,

Another misunderstanding. I use all objects TOAD puts in teamcoding, also tables (I miss scheduled jobs and materialized views for example as objects). I have 1 teamproject with 4 schemas included and checkboxes are all on and included all on % (default :wink: ) .

I miss TeamCoding as an option on tables in SB, but have it for all the other objects, even on objects mentioned above as missing, although it only shows “LOGON to VCS”, the rest is grayed out.

I will look at removing TC completely on Monday, no time left today. Luckily for me I started fresh from 12.8, but switched shortly after release to the 12.9 beta because of the changes for naming directories and files (and that gave initial problems). So I can start again (no migration needed), because the structured is maintained also in Git for me, and I made release related stuff in other tables.

What I want to mention, I did today an " UNDO CHECKOUT" of a package. TC sees this nicely, but doesnt’t put the old code (from GIT) back in the database as I would thought. Is this intended because now database and GIT are out-of-sync without a checkout?

Thanks

Herald

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Hi Brad,

so I did a complete reset of TOAD including user files. Due to company policies I got some more restrictions on some directories and 1 was the TOAD configuration I found now out, because TOAD couldn’t write a new clean set of user files. So I put all files into a new directory Always accessible to me and after the cleaning, all works now. Thanks for the advise.

2 more remark or maybe a wish:

  1. could secondary tables and indexes be excluded Always from TC, or make it an option. I have a lot of text indexes and I don’t want to see the DR$ tables and indexes.

  2. an open or send to editor option from the TCM could be handy for objects

Thanks

Herald

I’m glad you’re up and running Herald.

  1. I agree, but one thing you could do is set some filters in your Team Projects (eg. exclude Tables that start with MLOG$ and indexes that start with SYS_IL)

  2. For PL/SQL objects, double click/drag drop will open the object in the Editor. For other objects such as Tables and Views that have their own object Editors, they will be loaded in object Editors on double click (as long as you check them out). I think a “load in editor” button on the toolbar would be a good addition.

From: herald.ten.dam [mailto:bounce-heraldtendam@toadworld.com]

Sent: Monday, April 04, 2016 2:10 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Teamcoding and generated tables

RE: Teamcoding and generated tables

Reply by herald.ten.dam

Hi Brad,

so I did a complete reset of TOAD including user files. Due to company policies I got some more restrictions on some directories and 1 was the TOAD configuration I found now out, because TOAD couldn’t write a new clean set of user files. So I put all files into a new directory Always accessible to me and after the cleaning, all works now. Thanks for the advise.

2 more remark or maybe a wish:

  1. could secondary tables and indexes be excluded Always from TC, or make it an option. I have a lot of text indexes and I don’t want to see the DR$ tables and indexes.

  2. an open or send to editor option from the TCM could be handy for objects

Thanks

Herald

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

  1. I did now, only getting rid of the objects in GIT now, because TC doesn’t handle it now :wink: But no problem, I will manage

  2. A button is also nice, although I like a clean piece of software where the same handling leads to same reaction, but I understand this is Toad behaviour, I can live with it.

Thanks for now, now it works I can use TC very good and it is also a lot faster now than the initials betas of this release :wink:

Herald