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.