Log-In to post
Do you have a quick support question and short of time? Contact us Via Twitter @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest
I have recently discovererd toad and I am very impressed so far.I have however one problem: Toad hangs if I open a SQL file while I have an active connection. If I open the SQL file before i open the connection to the database server, it works OK.I spent some time googling about this problem, but have'nt found anything. Does anyone have any suggestions?I am using Toad 184.108.40.2062 on Windows 7 Ultimate 64-bit.
I want to create a team wide toad settings file that all team members can import and use.
Basically the import thing it needs to have is connections to all of our DB servers.
Seems like Toad makes this impossible because connections have user creds stored with them?
Can I just have a settings file will all the DB connections without user creds attached to them?
a new feature was added in the new release(220.127.116.117),that is table hint,in the release note,there is a describe of this feature:
In the Editor, you can place the cursor over a table name in a SQL statement to display the list of columns in the table.
BUT, i really do not want this feature, is there anyway to forbid this?
Is the Toad for MySQL Beta program still active?
The quick export feature was working perfectly until a week ago which happened to coincide when Visio 2013 was installed on my desktop.
Now.. I am unable to use the quick export feature for my query result sets.
Is there a quick fix for this other than uninstalling Visio ??
I'm using Toad for MySQL ver 7.5; Windows 7 OS, MS Office 2010
I have .sql dump file which is 300 MB file. I need help in restoring this .sql dump into a database.
I tried to open the .sql file from File->open, but it is throwing out of memory exception.
Appreciate if someone give detailed steps to perform this activity.
I am having a problem with setting up a script to run a Toad Data Report in that when I set it up within Toad and run it will logged into Toad it works fine, however when the automation script is scheduled and run it comes up with the following and fails:-
-- 22/12/2016 12:48:58: AdCard Transactions.log: Connection description was not found in Connection Manager-- 22/12/2016 12:48:58: AdCard Transactions.log: Connection failed
I am using version 18.104.22.1687 for MySQL on a windows server. Any help would be appreciated.
Hi,I want to set an http tunnel connection with a remote MySQL database, these kind of connections are normally established with a PHP file with the connection parameters to the database on the remote server, every MySQL client has it's own PHP file for this purpose.I'm just wondering if there is any PHP template for http tunnel connections in Toad for MySQL.
Tried formatting stored procedure code which has a query with "LIMIT v_param1,v_param2" syntax, and it breaks because of the variables.
Using Toad for MySQL 22.214.171.1247
Just installed Toad Mac Edition v2.4.2 and attempted connection to MySQL database but getting "Access denied for user 'root'@'localhost' ".
Connection string is: "jdbc:mysql://localhost:3306/test1?characterEncoding=latin1" and various other encoding attempts.
Unsure about "Encoding" field, tried a few Latin 1, UFT8, but the issue here seems to be authentication.
New to Toad but I'm able to access MySQL from the Terminal command line and using Python PyCharm.
I'm facing an issue with excessive spacing between selected columns list and its aliases when formatting the SQL.
I've already searched on every option in settings but I couldn't find a fix for that.
Below is an example of SQL:Before format:SELECT CASE WHEN t.columncase = 0 THEN 1 WHEN t.columncase = 1 THEN -1 END AS total, t.col1 AS column1, t.col2 AS column2, t.col3 AS column3, t.col4 AS column4, t.col5 AS column5, t.col6 AS column6FROM table t
How it should be:
I'm using these formatter settings:<FormatterOptions> <Version>252</Version> <LegacyOptionsGUI>5.290.0</LegacyOptionsGUI> <QP5>5.295</QP5> <RightMargin>150</RightMargin> <VarDeclAlignment>0</VarDeclAlignment> <ParamDeclAlignment>0</ParamDeclAlignment> <PassedParamAlignment>0</PassedParamAlignment> <CommaStyle>2</CommaStyle> <AndOrOperatorPos>2</AndOrOperatorPos> <ParenthesizedQueryAsBlock>1</ParenthesizedQueryAsBlock> <GroupByArrangement>W</GroupByArrangement> <OrderByArrangement>W</OrderByArrangement> <ColumnArrangement>W</ColumnArrangement> <ExprArrangeOnCol>99</ExprArrangeOnCol> <DmlKeywordsLeftAligned>1</DmlKeywordsLeftAligned></FormatterOptions>
Could someone help please?
When I click on Add File option in Import Wizard(Send to ->Import Wizard->Add Files) it simply greyed out . Nothing happened. Add file pop-up is not opening.
I'm trying to connect to a local database using settings:
But, i receive this error:
In HeidiSQL software, works...
How to resolve this error in toad?
I have installed Toad For MYSQL 126.96.36.1998 and I am experiencing a problem with SQL formatting
Toad puts all my SQL into one line.
When I open a VIEW and go to the Script tab my SQL appears as in the sample below.
CREATE VIEW `database`.`table_v` AS select `field`.`id` AS `id`,`field`.`user_id` AS `user_id`,`ua`.`display_name` AS `display_name`,`field`.`user_type_id` AS `user_type_id`,`uta`.`name` AS `user_type`,`field`.`source_id` AS `source_id`,`tst`.`name` AS `source`,`field`.`author_id` AS `author_id`,(case when (`field`.`user_type_id` = 1) then `ua`.`display_name` when (`field`.`user_type_id` = 2) then `taa`.`name` else `ua`.`display_name` end) AS 'author'
When I use Notepad or NaviCat my SQL appears as
CREATE VIEW table_v AS
field.id,field.user_id, ua.display_name,field.user_type_id, uta.name AS user_type,field.source_id, tst.name AS source,field.author_id, CASE WHEN field.user_type_id = 1 THEN ua.display_name WHEN field.user_type_id = 2 THEN taa.name ELSE ua.display_name END AS author,
Toad has managed to convert SELECT, CASE, WHEN, THEN, ELSE and END to lower case. It has also added '' around object names and added AS
I would like Toad to display the SQL as it appears in Navicat and notepad. I have altered Editor settings to no avail.
Can anybody shed any light on How to do this?
Hi,I don't know if it's a bug or if I miss something.The "Format SQL" command works fine with SELECT script (like SELECT FROM WHERE) but doesn't work with other SQL script (like CREATE/ALTER VIEW ... AS SELECT ...).It's very annoying when I have to alter a view with a huge SELECT statement.I hope that helpGuyPS: please apologize my poor English.
Hi,I wrote this sample of code in the editor :SELECT @OneVar;-- A commentCALL OneProc();then I apply the editor formatter (default) I get thisSELECT @OneVar;-- A commentCALL OneProc();It's seems there is a bug or I put a wrong option in the formatter, which one ?Best regardsGuy
Hi Can anybody please tell me where I can get step by step instrusction on how to operate Toad , learn how to use toad to build queries and save views etc. Nothing is working for me. I have learned some MySQL but nothing working for me?
For example, try changing "show line numbers" in editor options and click "Apply".
I'm using v188.8.131.527