You will no longer receive e-mail notifications from this forum.
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'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?
I have installed Toad For MYSQL 184.108.40.2068 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
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 220.127.116.117
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?
When I click on Add File option in Import Wizard(Send to ->Import Wizard->Add Files) it simply grayed out . Nothing happened. Add file pop-up is not opening.
For example, try changing "show line numbers" in editor options and click "Apply".
I'm using v18.104.22.1687
Even though I've selected databases across different servers, I'm getting error when trying to group execute the SQL script:
"Lookup Error - MySQL Database Error: No database selected"
After that, the "Execute Scripts" button is stuck as a red stop circle, until I cancel the "Group Execute" option by clicking on its green double green arrow button.
After doing that, I'm not able to mark the "Group Execute" checkbox in the vertical "Group Execute" tab on the left side of the editor.
I'm using Toad for MySQL 22.214.171.1247.
I'm trying to open a mysql file however it keeps failing as with an out of memory exception error, how can I resolve this?
Hello, I would like to know if i could use a where clause for compare. Each time when i import new records It compares over 2 million existing records.
a new feature was added in the new release(126.96.36.1997),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?
MySQL schema compare finds different foreign keys, but displays them with missing constraint name and column lists. For example:
ALTER TABLE `x`.`y` ADD CONSTRAINT `(` FOREIGN KEY() REFERENCES ``();
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 188.8.131.522 on Windows 7 Ultimate 64-bit.
When comparing data between two different data sources using Tools > Compare > Data Compare after walking through the wizard the error appears Object reference not set to an instance of an object. Toad for MySQL Version 184.108.40.2067 Please see screenshot below.
I've seen this error occur executing other actions in verion 220.127.116.117. Haven't seen this error in previous versions. For example in this post: http://www.toadworld.com/products/toad-for-mysql/f/22/t/31319
Thanks for your consideration.Matt
I am importing excel sheets with n no of rows and n no of columns into the database table using toad import option. now i need to write a code in java to import. i.e evrything should be in front end. In JSP(front end), I need to select a file and database table's name then click upload button. dats it. toad should run its import option in the backend and update all data in database. Is it possible for an external software like eclipse to connect to toad's import option? Is import loader is stand alone?
P.S- i am using Toad for MySQL
Any other opinions to solve my issue is also welcome
If I have not used an Editor Window for a while (say > 3-5 min), when I submit a new query, the first two times it always returns "Execution Finished in..." after showing "Executing Script: Waiting for Connection" for a while - and always - only on the third time, does it execute the script. I use other interfaces, including phpMyAdmin and others that do not behave this way at all, so this seems particular to Toad MySQL, or at least the way it is setup in my case.
If you have also encountered this and/or have any ideas on what could be causing this behavior and how to fix it, I would appreciate a response.
Thanks for your help.
I have back up with *.bak extension and I want to restore it on my local machine. I haven't fount any guides how to do that in Toad and start an MySQL server, so I could easily connect to it from my local server.
Can anyone provide steps?
Thanks in advance.
In the Data Import wizard I can select a range in a xlsx format excel file but when I highlight and accept the input range, I get, "error reading from data file, check the file format and file encoding" "Unable to Loadfile".Grateful if someone would help me on working through this.I am a total newbie and have so far just created a new database with the above as first step undertaken.