oneSql 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 subfolder.

In addition to the changes described above there are half a dozen small interface tweaks which just tidy things up very slightly.