While creating a personalised SQL Training course for one of my customers, I came across the new SQL Operations Studio from Microsoft. SQL Operations Studio is a cross platform SQL tool that is currently in Preview, version 0.23.6 I believe.
So far I have used it on both Windows 10 and Apple OSX Sierra and it has proven to be reasonably stable for such a young product and has great potential. I’m looking forward to seeing how it turns out when development is further along 🙂
SQL Operations Studio on Windows 10
SQL Operations Studio on Mac OSX
Looking for an App creating for your Windows or Mac Computer? What about an App for your iOS or Android Tablet or Phone, or A Web App? Bespoke, Custom, High Quality Applications.Contact Me
The following piece of code is written in the Xojo language (highly recommended by the way) and is a method that takes two Parameters, a List Object, and a Descriptive Type which is a String that can only be one of the following values:
1.0.1 was released earlier today and I'm very pleased to say that there
was not a single bug fix 🙂 Surely a testament to the guys and girls who
participated in the Beta program earlier this year. So a very big 'thanks'
to them 🙂
This update consists of a change to the way the SQL Keywords mechanism
works. Previously the file SQLKeywords.sjc
was loaded from the application folder or the SupportFiles
folder and all the SQL keywords were loaded into an array and this array
was accessed after each keystroke when typing occured in the SQL Text
Area. If a match was found then the appropriate action was taken, ie: the
word was capitalised, or coloured etc.
In version 1.0.1 the array of SQL keywords is built internally without
reference to the SQLKeywords.sjc
file. However if this file is present any words within this file are added
to the SQL keywords array. So for example any words that you wish to be
treated as keywords for your own purposes, or any keywords you find that I
have missed when building the keyword array, can be added in a file called
SQLKeywords.sjc which needs to be
located in the same folder as the oneSql application or in the SupportFiles
In addition to the changes described above there are half a dozen small
interface tweaks which just tidy things up very slightly.