SQL Operations Studio

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 Windows 10

SQL Operations Studio on Mac OSX

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

DataViewer Components for Xojo

Here’s a chance to get my Dataviewer Components for Xojo at a 20% Discount:

All Xojo Add-ons and Videos are 20% off through July 16th! Use coupon code SPASH and expand your toolbox now: http://bit.ly/2bAciyX #sale

Click here for more information on DataViewer

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

Xojo Generic Listbox Export: Tab, CSV and JSON

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. “,” – Comma, Standard Comma Separated CSV
  2. “;” – Semicolon, Alternative CSV
  3. chr(9) – Tab Character, Tab Delimited
  4. “JSON” – JSON Structure

Click Here to Download Code

GenericListBoxExport

The contents of your specified ListBox will the be output in your chosen format 🙂

Xojo Building Blocks from chol.technologyLooking 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 Us

A Couple of Free Books :-)

I have the following eBooks that I have written which are available for Free download.

  • Securing the Network: An eBook on Corporate Security Issues for the Non Technical (40 Pages)
  • Oracle Database 10g Exam Cram (70 Pages)

Please confirm your Name and Email Address, and select the book you would like from the dropdown menu, and your book will be with you shortly.

You can also access these books from the Free eBooks Page.

freebooks

 

Export data from your CRM with oneSql

I’ve uploaded another movie to our YouTube page today. This one shows an example of how to use oneSql to export contacts from your CRM system.

I have also been testing Mac OSX Yosemite Beta on one of my development computers. Here is a picture of oneSql running on Yosemite. Note the new native  control designs and colours. I think I like it 🙂

onesql yosemite beta sql query toolThat’s all for now 🙂

chol.technology Banner

The Best SQL Tool for Mac: Updated

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.

New CRM Software: Video Preview

A new video has just been uploaded to YouTube. This video demonstrates how simple and straightforward it is to insert and print a Sales Invoice using blackdogCRM, currently in Beta. (There is only so many hours in the day!) 🙂

chol.technology Banner