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?
347 0 / Create an account to join the discussion.
StanT
Follow / 16 Oct 2017 at 12:07pm / Toad Edge
Latest post by on 17 Oct 2017 at 4:37pm

Online Authentication Failed

Expand content
Hi All, I have downloaded Toad Edge to try it out. I have not been able to get past the first screen, as the below error appears. I press Sign In, it 'verifies the connection' and comes...

Hi All,

I have downloaded Toad Edge to try it out. I have not been able to get past the first screen, as the below error appears.

I press Sign In, it 'verifies the connection' and comes back with the same box.

There is no option to enter any details or correct any wrong credentials.

How do I proceed please?

Thank you,

ST

Unanswered 61 4 / Create an account to join the discussion.
Robert Munteanu
Follow / 12 Oct 2017 at 7:29pm / Toad Edge
Latest post by on 17 Oct 2017 at 8:24am

Linux Build

Expand content
Hi, As a Toad Extension for Eclipse user I would be very interested in trying out Toad Edge. However, I only see Windows and Mac builds, and none for Linux. Is there a Linux version planned? The screenshots...

Hi,

As a Toad Extension for Eclipse user I would be very interested in trying out Toad Edge. However, I only see Windows and Mac builds, and none for Linux.

Is there a Linux version planned? The screenshots seem to indicate that the product is built on top of Eclipse, so I would hope so :-)

Thanks,

Robert

Answered 52 5 / Create an account to join the discussion.
chorbl
Follow / 16 Oct 2017 at 10:05pm / Toad Edge
Latest post by on 16 Oct 2017 at 11:39pm

Toad Edge Mac SSL settings require you to provide all 3 types of ...

Expand content
My connection only uses a CA file. But it is asking for all 3. It should allow me to just provide the CA file.

My connection only uses a CA file.  But it is asking for all 3. 

It should allow me to just provide the CA file.

Unanswered 28 3 / Create an account to join the discussion.
mesut_69430
Follow / 22 Sep 2017 at 7:22pm / Toad Edge
Latest post by on 16 Oct 2017 at 10:38pm

using worksheets

Expand content
Hi, with a connection, with multiple databases (ie root user) is it possible to set active database, when using worksheets. (instead of typing db_name.table_name for all queries)

Hi,

with a connection, with multiple databases (ie root user)

is it possible to set active database, when using worksheets. (instead of typing db_name.table_name for all queries)

Unanswered 124 3 / Create an account to join the discussion.
mesut_69430
Follow / 22 Sep 2017 at 10:11pm / Toad Edge
Latest post by on 16 Oct 2017 at 10:36pm

export script does not work

Expand content
export the structure only creates comments with table name in it.

export the structure only creates comments with table name in it.

Unanswered 135 3 / Create an account to join the discussion.
dan_golfsat
Follow / 17 Aug 2017 at 10:15pm / Toad Edge
Latest post by on 16 Oct 2017 at 10:34pm

Schema compare NullPointerException

Expand content
Every time I try to do a simple schema compare of two databases, I get an error java.lang.NullPointerException at com.quest.toad.compare.jobs.LoadJob.run(LoadJob.java:79) at org.eclipse.core.internal...

Every time I try to do a simple schema compare of two databases, I get an error

java.lang.NullPointerException
    at com.quest.toad.compare.jobs.LoadJob.run(LoadJob.java:79)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

I've tried turning off most options, I can't seem to get the Compare feature to work at all.  I currently have a 30 day demo license.  I really wanted to check out this feature before buying.  v 1.1.0.20178032024

Unanswered 322 5 / Create an account to join the discussion.
baade1
Follow / 13 Jun 2017 at 2:12pm / Toad Edge
Latest post by on 16 Oct 2017 at 10:31pm

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 825 11 / Create an account to join the discussion.
Yoni Sade
Follow / 31 Jul 2017 at 3:11pm / Toad Edge
Latest post by on 10 Oct 2017 at 6:59pm

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 186 2 / Create an account to join the discussion.
mesut_69430
Follow / 21 Sep 2017 at 8:05am / Toad Edge
Latest post by on 22 Sep 2017 at 7:19pm

Unable to download freeware version of toad edge

Expand content
It ends with error "File not found"

It ends with error "File not found"

Answered 160 5 / Create an account to join the discussion.
Zlatko.G
Follow / 9 Sep 2017 at 10:15am / Toad Edge
Latest post by on 17 Sep 2017 at 11:06pm

In Toad Edge is no visual queri builder

Expand content
My name is Zlatko Gregurek. I use Toad for mysql for keeping a list of members of the union of pensioners. I am volonter. I am not sql expert and I use Toad for MySQL because he has graphical visual...

My name is Zlatko Gregurek. I use Toad for mysql for keeping a list of members of the union of pensioners. I am volonter.

I am not sql expert and I use Toad for MySQL because he has graphical visual queri builder and that's why is easy to use for me. Before Toad for MySQL and MariaDB database I use Microsoft Access. Visual queri builder in Toad for Mysql is similar to MS Acces and so I know use Toad for Mysql.

I try Toad Edge and I noticed there is no visual queri builder. That is big problem for me. Visual queri builder is importand for me. Do you plan add visual queri builder in Toad edge? If you doo I buy Toad edge and continue using MariaDB. If you don’t plan build visual queri builder I must go again to MS Access in wich I know working. 

In compare Toad for mysql and Toad Ege, Toad Edge is step back of functionality without visual queri builder.

So my question is, do you plan add visual queri builder option in Toad edge?

Unanswered 159 1 / Create an account to join the discussion.
davidfan
Follow / 3 Sep 2017 at 11:27pm / Toad Edge
Latest post by on 11 Sep 2017 at 8:40am

Is it possible to store database content as xml rather than json when...

Expand content
Hi Guys, Is it possible to store database content as xml rather than json when synchronizing the db to disk? I like the feature of toad edge mapping DB to disk , however, you are using json format, all...

Hi Guys,

Is it possible to store database content as xml rather than json when synchronizing the db to disk? I like the feature of toad edge mapping DB to disk , however, you are using json format, all functions / store procedures in json file are unreadable, sometimes, I 'd like to use git or svn compare tool to check the difference in versions of db. it's better if you can use xml cdata to store the raw content store procedure!

Unanswered 101 1 / 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 198 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 219 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 158 1 / 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 455 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 533 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 349 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 363 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 269 1 / Create an account to join the discussion.