{"id":159,"date":"2017-05-04T08:04:44","date_gmt":"2017-05-04T08:04:44","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=159"},"modified":"2017-05-04T13:31:21","modified_gmt":"2017-05-04T13:31:21","slug":"sql-multi-select-on-ubuntu-17-04-and-wine-2-0-1","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2017\/05\/04\/sql-multi-select-on-ubuntu-17-04-and-wine-2-0-1\/","title":{"rendered":"SQL Multi Select on Ubuntu 17.04 and Wine 2.0.1"},"content":{"rendered":"<p>Well, SQL Multi Select mostly runs on Ubuntu 17.04 with Wine 2.0.1. \u00a0Instructions for installing Wine 2.0.1 on Ubuntu 17.04 can be found <a href=\"http:\/\/www.omgubuntu.co.uk\/2017\/04\/how-to-add-wine-repository-ubuntu\">here<\/a>.<\/p>\n<p>What works:<\/p>\n<ul>\n<li>running multiple statements in a script<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-163\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/05\/sms_wine_multiserver.png\" alt=\"\" width=\"703\" height=\"418\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/05\/sms_wine_multiserver.png 703w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/05\/sms_wine_multiserver-300x178.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/05\/sms_wine_multiserver-150x89.png 150w\" sizes=\"(max-width: 703px) 100vw, 703px\" \/><\/li>\n<li>using scripts located on Linux file system<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-164\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/05\/sms_wine_script.png\" alt=\"\" width=\"319\" height=\"168\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/05\/sms_wine_script.png 319w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/05\/sms_wine_script-300x158.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/05\/sms_wine_script-150x79.png 150w\" sizes=\"(max-width: 319px) 100vw, 319px\" \/><\/li>\n<li>displaying images in result set<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-162\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/05\/sms_wine_image.png\" alt=\"\" width=\"918\" height=\"618\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/05\/sms_wine_image.png 918w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/05\/sms_wine_image-300x202.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/05\/sms_wine_image-768x517.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/05\/sms_wine_image-150x101.png 150w\" sizes=\"(max-width: 918px) 100vw, 918px\" \/><\/li>\n<li>using the command line interface to run projects<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-161\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/05\/sms_wine_cmd.png\" alt=\"\" width=\"739\" height=\"359\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/05\/sms_wine_cmd.png 739w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/05\/sms_wine_cmd-300x146.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/05\/sms_wine_cmd-150x73.png 150w\" sizes=\"(max-width: 739px) 100vw, 739px\" \/><\/li>\n<li>connecting to PostgreSQL databases via SSL connections<\/li>\n<li>exporting results to text files and SQLite database<\/li>\n<\/ul>\n<p>What doesn&#8217;t work:<\/p>\n<ul>\n<li>clicking on the summary file to open it &#8211; you&#8217;ll need to manually locate and open the file<\/li>\n<li>help file won&#8217;t open because it&#8217;s in a chm format &#8211; use the online help instead (<a href=\"http:\/\/www.yohz.com\/help\/sqlmultiselect\/index.htm\">http:\/\/www.yohz.com\/help\/dbdoc\/index.html<\/a>)<\/li>\n<\/ul>\n<p>If you come across any other functionality that doesn&#8217;t work on Ubuntu, please do drop us a line at <a href=\"mailto:support@yohz.com\">support@yohz.com<\/a>.<\/p>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.yohz.com\/blogs\/2017\/05\/04\/sql-multi-select-on-ubuntu-17-04-and-wine-2-0-1\/\" action=\"like\" colorscheme=\"light\" layout=\"button\"  size=\"small\"><\/fb:like><\/div><div class=\"fb-share-button  \" data-href=\"https:\/\/www.yohz.com\/blogs\/2017\/05\/04\/sql-multi-select-on-ubuntu-17-04-and-wine-2-0-1\/\" data-type=\"button\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Well, SQL Multi Select mostly runs on Ubuntu 17.04 with Wine 2.0.1. \u00a0Instructions for installing Wine 2.0.1 on Ubuntu 17.04 can be found here. What works: running multiple statements in a script using scripts located on Linux file system displaying images in result set using the command line interface to run projects connecting to PostgreSQL [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[9],"tags":[8,10,25,26],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/159"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=159"}],"version-history":[{"count":6,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/159\/revisions"}],"predecessor-version":[{"id":169,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/159\/revisions\/169"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}