Toad Edge Community

Toad Edge - Forum

Nate.Gaffaney
Follow / 11 May 2017 at 5:42pm / Toad Edge

Welcome! Use this forum to let us know of questions or problems you...

Expand content
We’d invite you to use this forum to let us know of any questions you have or problems you encounter with the Toad Edge product. The better a problem is described, the better the assistance tends...

We’d invite you to use this forum to let us know of any questions you have or problems you encounter with the Toad Edge product.

The better a problem is described, the better the assistance tends to be.  In order to better assist with any issues, please include the following information in your initial post:

  • Any relevant environment details (such as operating system release and release of MySQL)  
  • If possible a screenshot of the problem is useful
  • Describe the problem fully. What result was expected?
  • Can the issue be created on demand or is it intermittent?
  • If the problem can be created on demand, what are the exact steps to recreate the problem?
205 0 / Create an account to join the discussion.
Yoni Sade
Follow / 30 Jul 2017 at 3:57pm / Toad Edge
Latest post by on 3 Aug 2017 at 3:20pm

Compare sync script and character set/collation

Expand content
Currently, the compare sync script is not perfect, because it overwrites the collation of stored procedures/functions in the target DB, by not specifying it in the script. Is it possible to add the COLLATE...

Currently, the compare sync script is not perfect, because it overwrites the collation of stored procedures/functions in the target DB, by not specifying it in the script.

Is it possible to add the COLLATE syntax to the stored procedure/function parameters after the CHARACTER SET syntax?

Also, an option to disable the CHARACTER SET syntax completely would also help.

Unanswered 90 1 / Create an account to join the discussion.
Yoni Sade
Follow / 31 Jul 2017 at 3:11pm / Toad Edge
Latest post by on 3 Aug 2017 at 3:06pm

Toad removes db prefix from stored procedures code in compare sync...

Expand content
When Toad generates compare sync script, it apparently removes source db name from stored procedures code in the script. So if we originally had an sp: create or replace my_sp() begin select...

When Toad generates compare sync script, it apparently removes source db name from stored procedures code in the script.

So if we originally had an sp:

create or replace my_sp()

begin

select * from source_db.my_tables;

end;

Toad will remove the "source_db" part as such, although it's a major part of the sp logic:

create or replace my_sp()

begin

select * from my_tables;

end;

 

Also, didn't find an option to disable it that worked.

Unanswered 60 1 / Create an account to join the discussion.
Yoni Sade
Follow / 31 Jul 2017 at 3:37pm / Toad Edge
Latest post by on 3 Aug 2017 at 2:53pm

Toad changes double quotes around strings in SP dynamic sql in compare...

Expand content
When generating a Sync script Toad changes double quotes to single in SP dynamic SQL which fails the script: Original: CREATE PROCEDURE my_sp () BEGIN DECLARE i int; SET i = 1; SET @s = concat...

When generating a Sync script Toad changes double quotes to single in SP dynamic SQL which fails the script:

Original:

CREATE PROCEDURE my_sp ()
BEGIN
DECLARE i int;

SET i = 1;

SET @s = concat('select ''my sp:', i,'''');

PREPARE stmt FROM @s;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;
END;

 

Sync Script:

CREATE PROCEDURE my_sp () LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER BEGIN
DECLARE i int;

SET i = 1;

SET @s = concat('select 'my sp:', i,''');

PREPARE stmt FROM @s;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;
END;

Unanswered 81 2 / Create an account to join the discussion.
Yoni Sade
Follow / 31 Jul 2017 at 2:55pm / Toad Edge
Latest post by on 3 Aug 2017 at 7:57am

Editing current compare source/target

Expand content
Is it possible to edit the source/target databases in an existing comparison window? I didn't find this option.

Is it possible to edit the source/target databases in an existing comparison window?

I didn't find this option.

Unanswered 56 1 / Create an account to join the discussion.
baade1
Follow / 13 Jun 2017 at 2:12pm / Toad Edge
Latest post by on 25 Jul 2017 at 3:18pm

Yet to be able to fully launch the product due to "We were unable...

Expand content
I have updated the the net.properties file to set the proxy to no avail. Windows 7 Enterprise. Any ideas? Thanks!

I have updated the the net.properties file to set the proxy to no avail.

Windows 7 Enterprise.

Any ideas?

Thanks!

Unanswered 433 9 / Create an account to join the discussion.
tpaine
Follow / 16 Jun 2017 at 11:51pm / Toad Edge
Latest post by on 20 Jun 2017 at 11:37am

Multiple Queries

Expand content
When I run multiple queries in the same window like this: select * from brand b; select * from blog; I only see the results for the last query, in this case "Blog". The window at the top...

When I run multiple queries in the same window like this:

select * from brand b;

select * from blog;

I only see the results for the last query, in this case "Blog". The window at the top says "2 statements processed" but I'm not seeing two results sets.

Unanswered 263 5 / Create an account to join the discussion.
tpaine
Follow / 13 Jun 2017 at 12:19am / Toad Edge
Latest post by on 19 Jun 2017 at 6:17pm

Background Colors

Expand content
One of my favorite features from Toad for MySQL is the ability to alter the background color of the Worksheet window where I'm writing a query based on my connection. In practice this means that my...

One of my favorite features from Toad for MySQL is the ability to alter the background color of the Worksheet window where I'm writing a query based on my connection. In practice this means that my "dev" connection has a light green background (safe) and my production connection has a light red one (danger). This gives me a bold visual representation thats all but impossible to miss. I am unable to find this option in Toad Edge. The "Color" option appears to only change the little icon on the tab (and a couple other little places) and it's very easy to miss. Are there plans to bring this feature back?

Subtle:

Obvious:

Unanswered 314 5 / Create an account to join the discussion.
tpaine
Follow / 17 Jun 2017 at 12:03am / Toad Edge
Latest post by on 19 Jun 2017 at 10:28am

Complex query returns no results in Edge

Expand content
So I write a lot of complex queries in my job and often have to create temporary tables to manipulate the data a second time. I'm not sure whats going on with this query exactly but when I execute...

So I write a lot of complex queries in my job and often have to create temporary tables to manipulate the data a second time. I'm not sure whats going on with this query exactly but when I execute it in Toad for MySQL I get a nice little results set with one row showing me the count. In Toad Edge I get ... nothing. The progress window clearly shows that it's executing 5 different statements but once it's done this is all I see (even if I get rid of the "DROP TABLE" so the last statement is the SELECT).

Execution successful:

No results:

Unanswered 199 2 / Create an account to join the discussion.
chris.perman
Follow / 13 Jun 2017 at 9:45am / Toad Edge
Latest post by on 18 Jun 2017 at 5:27pm

Toad Edge and using keys in the SSH connections

Expand content
I have just downloaded toad for the mac and was very disappointed when I failed at the first hurdle of doing a connection via ssh using a key? Come on this is basic stuff and useless to me without this...

I have just downloaded toad for the mac and was very disappointed when I failed at the first hurdle of doing a connection via ssh using a key? Come on this is basic stuff and useless to me without this :|

Unanswered 208 2 / Create an account to join the discussion.
cellva
Follow / 13 Jun 2017 at 6:04am / Toad Edge
Latest post by on 15 Jun 2017 at 8:57pm

Content Assist (Auto Completion) - Not working in Mac

Expand content
Hi, when I was trying to update the content assist character in preference, I removed the default character. After that, content assist is not working in Mac version. Question: What is the character...

Hi, when I was trying to update the content assist character in preference, I removed the default character. After that, content assist is not working in Mac version. 

Question:

What is the character I need to put in back to make it work? Or how to make all settings to default? 

Can I update auto completion to Command + Space in mac version? If so, how to do it.

Answered 164 1 / Create an account to join the discussion.
Mathew Phan
Follow / 16 May 2017 at 5:34pm / Toad Edge
Latest post by on 13 Jun 2017 at 8:52am

Clicking on menu View, Start Page throws an error

Expand content
Hi, In the Toad Edge Preview, when I click on the menu View, Start Page, I get the following error. Also, "occurred" is misspelled. The application has encountered a problem Internal error...

Hi,

In the Toad Edge Preview, when I click on the menu View, Start Page, I get the following error. Also, "occurred" is misspelled.

The application has encountered a problem

Internal error has occured. It is recommended to restart the application.

Message: InjectionException

Thanks in advance,

Mat

1030 22 / Create an account to join the discussion.
tpaine
Follow / 12 Jun 2017 at 11:51pm / Toad Edge
Latest post by on 13 Jun 2017 at 8:30am

Row Count

Expand content
In "Toad for MySQL" every time a query is executed it returns a handy row count. Am I missing something or is this feature no longer available? If the latter then are you planning on re-implementing...

In "Toad for MySQL" every time a query is executed it returns a handy row count. Am I missing something or is this feature no longer available? If the latter then are you planning on re-implementing it?

Thanks,

- Thomas

Unanswered 195 2 / Create an account to join the discussion.
Deepak Vohra
Follow / 31 May 2017 at 8:49pm / Toad Edge
Latest post by on 8 Jun 2017 at 2:36am

RE: [toad-edge - Forum] Clicking on menu View, Start Page throws an...

Expand content
According to System Requirements VMs are not supported. Supported Operating System are: Windows 10 (64-bit) Windows 8.1 (64-bit) Windows 8 (64-bit) Windows 7 (64-bit) Windows Server 2012 R2...

According to System Requirements VMs are not supported.

Supported Operating System are:

Windows 10 (64-bit)

Windows 8.1 (64-bit)

Windows 8 (64-bit)

Windows 7 (64-bit)

Windows Server 2012 R2 (64-bit)

macOS 10.12 Sierra (64-bit)

OS X 10.11 El Capitan (64-bit)

OS X 10.10 Yosemite (64-bit)

community-downloads.quest.com/.../Default.htm

--------------------------------------------

On Wed, 5/31/17, Mathew Phan wrote:

Subject: RE: [toad-edge - Forum] Clicking on menu View, Start Page throws an error

To: toadedge@toadworld.com

Date: Wednesday, May 31, 2017, 10:55 AM

#yiv3654458691 blockquote.yiv3654458691quote {border:1px

dotted #CCCCCC;padding:5px;}

#yiv3654458691 blockquote div.yiv3654458691quote-user

{font-weight:bold;}

#yiv3654458691 blockquote div.yiv3654458691quote-content p

{margin:0;font-style:italic;}

RE:

Clicking on menu View, Start Page throws an error

Reply by Mathew Phan

Installing it on my laptop running Windows 10 does

not have the error.

My VM has the following resources: Intel (R) Xeon (R) CPU

X5650 @ 2.67ghz and 16.0 GB RAM.

Thanks,

Mat

Unanswered 276 4 / Create an account to join the discussion.
piet jacobs
Follow / 6 Jun 2017 at 3:35pm / Toad Edge
Latest post by on 6 Jun 2017 at 4:21pm

Toad Edge licence

Expand content
Hello, We've been using Toad for Oracle for a long time now but we are also looking for a tool to support our first Postgres databases. Toad Edge would be perfect if we could maintain both platforms...

Hello,

We've been using Toad for Oracle for a long time now but we are also looking for a tool to support our first Postgres databases.  Toad Edge would be perfect if we could maintain both platforms with Toad.

I'm interested to know the licence policy. Will this be a separate licence or will it be integrated like for instance MySQL is at the moment?

Answered 271 1 / Create an account to join the discussion.
thom_park@intuit.com
Follow / 26 May 2017 at 12:46am / Toad Edge
Latest post by on 30 May 2017 at 7:45pm

Guidance on JDBC driver compatibility?

Expand content
Is there any guidelines on what JDBC drivers are supported and unsupported with Toad Edge? I recently attempted to add the iNet merlia driver to Toad Edge and it failed with the terse "Driver was...

Is there any guidelines on what JDBC drivers are supported and unsupported with Toad Edge?

I recently attempted to add the iNet merlia driver to Toad Edge and it failed with the terse "Driver was not loaded properly!" message.

We're using this driver to talk to SQLServer successfully in other java apps, so I was curious what's so special about Toad Edge that would not be able to load a conforming driver.

Unanswered 265 3 / Create an account to join the discussion.
Julie Hyman
Follow / 18 May 2017 at 8:25pm / Toad Edge

3 new videos posted to the media gallery

Expand content
Hey everyone - we just posted 3 new videos to the media gallery. How to use snapshots, SQL recall and the JSON editor. Hope you find them helpful!

Hey everyone - we just posted 3 new videos to the media gallery.  How to use snapshots, SQL recall and the JSON editor.  Hope you find them helpful!

Unanswered 136 0 / Create an account to join the discussion.