Martyn Houghton Posted July 3, 2016 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
TrevorKillick Posted July 5, 2016 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
Martyn Houghton Posted July 5, 2016 Author Posted July 5, 2016 Trevor That sound great. I keep an eye out for these in the next release. Cheers Martyn
Martyn Houghton Posted July 8, 2016 Author 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
TrevorKillick Posted July 8, 2016 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
TrevorKillick Posted July 11, 2016 Posted July 11, 2016 Build 375 is available on live now which includes these changes Kind Regards Trevor Killick
Martyn Houghton Posted July 11, 2016 Author Posted July 11, 2016 Trevor Thanks, the new features are now in place. Cheers Martyn
Martyn Houghton Posted July 12, 2016 Author 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
TrevorKillick Posted July 13, 2016 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
Martyn Houghton Posted August 11, 2016 Author 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
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