Martyn Houghton Posted July 3, 2016 Share Posted July 3, 2016 At the moment we have a number of saved sql queries in Database Direct which is very useful for running common queries, however one issue at the moment is that in order to view the sql you have to run it, as it runs as soon as you select it. This is fine when only doing selects, but as we have a number of SQL update queries we run in relation to imported data, it would be good to have the option to open or edit the saved SQL without having to run it. Cheers Martyn Link to comment Share on other sites More sharing options...
TrevorKillick Posted July 5, 2016 Share Posted July 5, 2016 Hi Martyn I have added this ability as well as the following: SQL Syntax Highlighting SQL Table + Column Auto Complete Execute only selected query (This allows you to save multiple queries in one and execute them only when selecting) They will be available in the next release of the Admin Tool, i will post up when that goes live. Kind Regards Trevor Killick Link to comment Share on other sites More sharing options...
Martyn Houghton Posted July 5, 2016 Author Share Posted July 5, 2016 Trevor That sound great. I keep an eye out for these in the next release. Cheers Martyn Link to comment Share on other sites More sharing options...
Martyn Houghton Posted July 8, 2016 Author Share Posted July 8, 2016 Trevor Do we have any idea of the timescale on the new admin tool, as I have some data corrections to do from our migration. Cheers Martyn Link to comment Share on other sites More sharing options...
TrevorKillick Posted July 8, 2016 Share Posted July 8, 2016 I will push the latest build to live on Monday morning. I will update the post when it goes out. Kind Regards Trevor Killick Link to comment Share on other sites More sharing options...
TrevorKillick Posted July 11, 2016 Share Posted July 11, 2016 Build 375 is available on live now which includes these changes Kind Regards Trevor Killick Link to comment Share on other sites More sharing options...
Martyn Houghton Posted July 11, 2016 Author Share Posted July 11, 2016 Trevor Thanks, the new features are now in place. Cheers Martyn Link to comment Share on other sites More sharing options...
Martyn Houghton Posted July 12, 2016 Author Share Posted July 12, 2016 Trevor I am attempting to run a number of lines of SQL in one operation, they are update sql commands, which work if I select each one individually but if I select more than one, it fails advising a syntax error. I have tried inserting a semicolon at the end of each statement but to no avail. Does the new function support another deliminter to allow you to run multiple sql commands in the selection? Cheers Martyn Link to comment Share on other sites More sharing options...
TrevorKillick Posted July 13, 2016 Share Posted July 13, 2016 Hi Martyn The underlying API only supports single SQL Statements so selecting multiple lines will not work in the same way trying to execute a saved query with multiple statements will throw a syntax Error. The feature was designed only to allow you to select one statement at a time. Kind Regards Trevor Killick Link to comment Share on other sites More sharing options...
Martyn Houghton Posted August 11, 2016 Author Share Posted August 11, 2016 Trevor Just to advise and if anyone else needs to do a bulk update you can use a single UPDATE clause using the CASE WHEN syntax which you are able to run as one SQL Statement, all be it in our case one that was over 7,000 lines long. Cheers Martyn Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now