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

Magic Cipher Video: Additional Features

http://www.magiccipher.com

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 Us

Magic Cipher: Usage Scenarios and Examples

Example 1: One to One Private Communications

Bill and Ted are ready to start making plans for their next Excellent Adventure. Knowing that their email discussions could be intercepted and easily read, they use the Magic Cipher Shared Secret Generator with it’s Strength Meter to create a Shared Secret they can use together.

They type their discussions into Magic Cipher and email the contents as encrypted text directly from within Magic Cipher. They are now secure in the knowledge that no­-one can obtain access to their plans and attempt to put a spanner in the works!

Example 2: One to Many Private Communications

Bill and Ted decide they want to involve the Historical Babes in some of their plans, but not all. The four of them agree a Shared Secret and now Bill and Ted can communicate between themselves using their own Shared Secret and if they wish to include the Historical Babes they use the second Shared Secret previously agreed between the four of them.

Example 3: One to Many Private Communications over a Public Medium

Frodo is setting off on his next adventure and as is the fashion nowadays he wants to update the world with his travels via an online blog. With his new Macbook Pro this will be easy enough, however there is certain information he wishes only to be read and understood by Merry and Pippin who are holding the fort for him back in Hobbiton.

Before he sets off the three of them agree on a Shared Secret and as Frodo updates the world via his blog he uses Magic Cipher to append an encrypted entry on the end of his posts, in a separate paragraph, knowing that the world can see but not read or understand his instructions, which are only for the eyes of Merry and Pippin. Frodo uses the built in Virtual Keyboard to add a little bit of extra security to his posts.

Example 4: The Benefits of Cross Platform

Unfortunately, small, slim and gorgeous though it is, the Macbook Pro is just a little bit too big ­ and let’s face it, expensive ­ to take across Middle Earth, what with the danger from the Orcs and other dark forces.

At the last minute Frodo decides to switch to a small Linux notebook which he obtained free of charge with his mobile broadband card. Luckily Magic Cipher works as well on Linux as it does on macOS or Windows, so Frodo has no need to change his plans, or his choice of encryption software.

Example 5: Magic Cipher, Not Just for Men

While Frodo is off on his travels his wife, feeling lonely, takes a lover. Knowing that the local Hobbiton ISP takes quite an interest in emails to and from the villagers, they both use Magic Cipher to arrange their rendezvous. Even hobbits need loving.

Besides it was rather selfish of Frodo to disappear like that for months at a time ­ and who knows what he got up to with Sam on that epic journey?

Example 6: A Picture is Worth a Thousand Words …

Sat on his sofa safe back at home several months after his epic journey to Mordor, Frodo dreams of his next challenge. With Sam on board, who now lives several miles away in Bree, Frodo and Sam use the Steganography features of Magic Cipher to enable them to swap ideas and plans which they have hidden in pictures which they upload to their Facebook pages.

With no evidence that their pictures are anything more than rather boring pictures of Sams garden or Frodos wine collection, nobody has any clue that there is another adventure being planned. In fact nobody has any reason to suspect Sam and Frodo are even in communication regularly. Problem Solved!

Magic Cipher: The Story [1/2]

In 2007 I’d just launched my first application for the Mac, macVCR and I was looking for inspiration for my next project. I had long recognised the need for a simple and easy to use encryption program and hadn’t been able to find one. I decided my goal should be to create one.  Not only would this ‘scratch an itch’ it would hopefully go on to become a successful product in its own right.  If I needed this then so did others.

The problem was that I used, and still do, macOS, Windows and Linux on a regular basis, and so would some of my customers. If they, for example, use Windows now – they may use macOS in the future.  For this to be a worthwhile endeavour my product would have to run on those three major operating system platforms and provide transparency and compatibility between them. This was no longer a small project.

R10Cipher: Supported Operating Systems

To make this product a reality I chose Xojo as a development platform, or REALStudio as it was then known, and set to work creating R10Cipher.

The first thing I needed was a Vision Statement, something to guide me during development and help focus my thoughts. I settled on the following:

A Simple and Easy Method to Safely Encrypt your Email Correspondence and Document Files.  It’s like your emails and documents are carried by a SWAT team rather than being written on a Postcard !  R10Cipher is for Individuals. For Businesses. For You. For Me. For Mum and Dad. For Teachers. For Professionals. For Journalists. For Executives. For Everybody.  Because our Privacy and Security have never been more important.

The next thing I needed to do was decide on what encryption technology to use. AES was relatively new at the time and was still looked at suspiciously by many Americans following the whole ‘Clipper Chip‘ incident.  In the end I settled on a UK invented encryption technology called Blowfish.  Blowfish is a keyed symmetric block cipher which was invented by ‘Security Guru’ and renowned author Bruce Schneier in 1993. It provides excellent encryption and will continue to do so for the foreseeable future. Blowfish is free of patents and back doors, and Bruce has placed Blowfish in the public domain.

Version 1 of R10Cipher was released in 2008 and sold only a few dozen copies.  Using the feedback from these early customers Version 2 was released with some significant enhancements including drag and drop batch encryption of files and documents.

When Version 2 was released, Version 1 was featured as a free edition on the DVD Cover Disks for the glossy UK editions of MacFormat and MacWorld magazines, on consecutive months.  Since then I have agreed for it to be distributed on several foreign editions of the magazines.  Hundreds of new users were gained through the distribution of the free edition, and many of those went on to pay for an upgrade to Version 2.

Macworld and MacFormat Magazines featuring R10Cipher 1 on the Cover DVD

Direct Sales of Version 2 were excellent, with good feedback and testimonials. New customers means new ideas and feature requests and so Version 3 was scheduled.

Version 3 released 2nd August 2009 was a major new version that addressed all user requests from Versions 1 and 2. The main advantages of Version 3 were an increase in encryption strength to 384 Bit, an encryption strength indicator and a full Key Management capability which creates an encrypted local database which contains the ‘Shared Secrets’ that you use to communicate with your different contacts.

Interest in Version 3 was phenomenal, it far exceeded my expectations. I had many upgrades from Version 2 to Version 3 and as I offered an upgrade policy even from the free edition, I have had a few upgrade from Version 1 to Version 3 also.

2009 also saw R10Cipher become a Finalist in the UK IT Industry Awards, Technology Excellence / Information Security Product category.  The UK IT Industry Awards are held annually by Computing Magazine and the British Computer Society.

R10Cipher: Finalist UK IT Industry Awards

In April 2010 in conjunction with MacFormat Magazine I offered a free Version 2.5 SE on the DVD Cover Disk with a discounted upgrade to Version 3. This promotion was not as successful as earlier promotions, possibly because 2.5 SE was a ‘designed to be free’ product, rather than an actual previously sold version. In addition Version 3 had at this stage been out for a while.

Version 4 of R10Cipher was released in June 2010, with Version 5 being released in July 2012.

Commercially R10Cipher has been a great success for me with several thousand users and it is a product I am very proud of. Just as importantly, my customers have had immediate and measurable benefits through the use of R10Cipher. Previously they knew they needed something to protect their communication and documents, but they could not find a product that seemed easy and simple enough for them to use.  R10Cipher filled that requirement.

IT Security and Data Protection were and are high on many peoples agendas at the moment, or at least they should be, and yet the majority of people are left exposed because until R10Cipher came along there was not a product simple and easy and complete enough for them to consider using it.

Here are some paragraphs about R10Cipher, back in the day:

R10Cipher is unique in that this is the first cross platform end to end encryption product that real people can and will use for day to day encryption purposes. R10Cipher does not attempt to encrypt a complete volume, R10Cipher does not try and involve the user with complex Public Key encryption, R10Cipher does not need a complicated install, in fact R10Cipher does not need installing at all. R10Cipher concentrates on being the easiest to use and most reliable End to End, Text and File Encryption software.

The lack of an installation makes R10Cipher unique in that you can copy the Windows (XP, Vista and 7), Mac OSX and Linux versions of R10Cipher to a USB drive or external device, along with your documents and carry your data about with you knowing that a) You can access that data on any computer and b) It is secure, so if you lose it or leave it in a taxi then the information is unreadable and no harm is done.

Because of it’s simplicity and ease of use R10Cipher pioneers new ways of working. Backup your important data to the web, iCloud, Dropbox or similar – encrypted by R10Cipher, and retrieve the information later, wherever you happen to be. Your data is secure – secured by you not by your web hosting company. If your hosting company is enforced by law to hand over your information, that information is useless to the recipient unless *you* agree to provide access.

The main innovation of R10Cipher therefore is not in the technology but the way in which the product is designed to be easy and simple to use for everybody – not just IT Professionals.

This brings us nearly up to date.  I should perhaps mention that R10Cipher took a back seat for me, as did my other commercial products, between 2012 and 2016.  This was due to personal and health problems involving, amongst other things, Motorcycles and Air Ambulance Helicopters.

R10Cipher was never forgotten and when the chance came to resurrect it through an acquisition by Area51 Limited I was extremely pleased.  Not only could the product be re-written, updated and enhanced and once again made available, but I would be backed up by others who could step into my shoes and continue development, should the worse ever happen.

2016: Magic Cipher was born.  Press Release

Magic Cipher

Part 2 of this post will detail how Magic Cipher was built, its initial goals as well as the way it will change over time and the additional functionality we will be adding in the near future.  For now, you can obtain a copy of Magic Cipher with a 20% discount using the coupon code: MCBL20 which can be entered at checkout: http://www.magiccipher.com

Contact us for further information:

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 Us

Syncing Your Email to Your CRM

A recent chat with a customer reminded me that there are still many companies out there running their own in-house CRM, or similar, and facing the very real problem that their email is received and stored separately to the rest of their customer information, which is accessible in their CRM.

A product of mine from ‘back in the day’, ContaxCRM, solved this problem with email sent and received being synced into the CRM, against the correct Customer / Supplier / Prospect – and it did this on both Windows and macOS.

In this post I am demonstrating part of this solution for macOS only, using Apple Mail.  Of course this can easily be modified and extended to work with other email packages should you wish to do so.  This post basically covers how to extract the received emails and store them in such a fashion that your CRM can read, parse and save this information to the CRM database the next time the CRM is launched.

The first thing to do is to install the Apple Script that does all of the heavy lifting.  You can see the Script below, and Download it from here.

capture1

This script needs to be stored in the appropriate location on your Mac.  You can see the location in the image below, generally ~/Library/Application Scripts/com.apple.mail/

capture2The second step is to open your Apple Mail Preferences and navigate to the Rules Tab.  From here you need to setup a new rule to execute the script whenever a new email is received.  See the image above.

That’s it !  A text file will be created (if necessary) and appended to with the full contents of every email received.  You can setup the Name and Path for the text file from within the Apple Script.

Parsing the text file, extracting the email address of the sender and saving this to your CRM is straightforward but will differ depending on your application, development software and requirements.

Hopefully this will be of use to someone out there 🙂

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 Us

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

Easy to Use SQL Tool | oneSql 101: User Prompts

Visual Guide to oneSql: Part 4, User Prompt Fields

New, Easy to Use, Fast, Cross Platform, Multi-Language SQL Query Tool: oneSqlupf5

upf2

upf3

upf5

upf

busbannerAffiliate Links

 

Easy to Use SQL Tool | oneSql 101: Preferences

Visual Guide to oneSql: Part 3

New, Easy to Use, Fast, Cross Platform, Multi-Language SQL Query Tool: oneSql

 

prefswindow1

prefswindow2

 

prefswindow3

 

busbannerAffiliate Links

 

Easy to Use SQL Tool | oneSql 101: Connections

Visual Guide to oneSql: Part 1

New, Easy to Use, Fast, Cross Platform, Multi-Language SQL Query Tool: oneSql oneSql Connection Window   busbanner Affiliate Links

Spanish Language Beta of oneSql Available

Finally !  English, French, German, Italian and now Spanish are all supported by the latest Beta of oneSql, our Cross Platform, Multi-Database SQL and Database Tool.

onesql_0907

Always interested in additional Beta Testers, if you are interested you can go to this page to register your interest.

Besides the addition of Spanish as a supported language, there are just a few more changes ‘under the hood’ so to speak.

  • New Default Logon for MariaDB: root
  • New Default Logon for PostGreSQL: postgres
  • New Windows Menu
  • Main Window Area Zoom Facility
  • Logon Window, Cleaner User Interface
  • Logon Window, Removed the Connections Log
  • Did I mention Spanish Language Support ?

Existing Beta Testers can download from the Build List in the Trello project as usual. Please let me know of any issues as the Release Version is due very soon now … 🙂 Your time and efforts are much appreciated.

busbanner

Affiliate Links

oneSql New Beta Goes Italian

onesqlitalian

If you are interested in becoming a Beta Tester for oneSql, especially if you speak Italian 🙂 , then CLICK HERE. oneSql will be gaining support for Spanish over the next few days and within a couple of weeks Version 1.0 will be available to Purchase.

Affiliate Links

oneSql PostgreSQL Support … Soon

By popular demand PostgreSQL support is being added to oneSql.  It’s not there yet but it will be available very soon.  Click here if you are interested in being a Beta Tester.

postgressoon


whatwedochooseus

  Affiliate Links

oneSql: New Beta Available

There is a new Beta Edition of oneSql available. This update to oneSql adds an Import Data option to the Tools menu. This new menu option opens the Import Data window where you can setup your import structure.

This is done in the Configure tab of the Import Data window. You can select the type of file that you will be importing (delimited by Tab, Comma or Semicolon), you then select the Database Table you wish to import into.

The next thing is to Double Click the Columns that you wish to update.  Double Clicking in the Available Columns list moves the Column to the Selected Columns list. Double Clicking in the Selected Columns list moves the Column back out to the Available Columns list.

You can reorder columns by selecting the column and dragging it within the list.

imp1

Once you have configured the import to match your import file, click the Import tab. Here you can see we have two buttons.  The first button loads your text file into the import list and the second button marked Save creates the necessary import statements behind the scenes and writes your import file to your database.

imp2

Once the import is complete the import list is cleared and you are told how many rows have been processed.

Note the Checkbox options to ignore the first line (if you are using column headings in your source file) and to remove double quotes (often seen in badly formed import files).

The third tab option, Templates, is not yet implemented. This is where you will be able to save your import configurations and give them a name so that you can retrieve them quickly and use them again at a future time. A potentially very useful facility. Let us know if you would find this feature useful.

madewithxojo

If you are interested in becoming a Beta Tester for oneSql, please click here: http://bit.ly/1lq3kk8

oneSQL Legend

 

 

Blogfooter

 Affiliate Links

DataViewer in the Xojo Store

I got notice yesterday that my DataViewer components for Xojo and REALStudio Developers are now available to purchase online from the Xojo store. Check it out 🙂

https://www.xojo.com/store/#addons

icon_dataviewer

 

Blogfooter

 Affiliate Links

 

The oneSql Story: [1] Prologue

Prologue

icon_onesql_sml

To understand oneSql it is necessary to first be introduced to DataViewer. DataViewer is a small collection of software objects available for Xojo and RealStudio Developers to purchase and use within their own programs. DataViewer is a self contained window which can connect to any MySQL or SQLite database and perform SQL Queries and execute SQL commands against that database. Lots of features are supported including Export in several formats. DataViewer works on Mac OSX, Microsoft Windows and Linux.

Initially oneSql was created as a demonstration of what could be created using the DataViewer components. This is still the case and all the main functionality from oneSql will make it into the DataViewer component, and vice versa.

In addition however I’ve decided to make oneSql a Stand Alone, LightWeight, No Install Needed – SQL Database Tool for OSX, Windows and Linux – and possibly iOS and Android.

oneSql currently supports MySQL and SQLite. I intend to add support for PostgreSQL, Oracle and ODBC in future releases.

The target audience for oneSql is initially technical people, or ‘power users’ who need a simple, efficient, cross platform SQL Tool on their portable USB Drive. DBA’s, System Admins, Developers, Accountants – all have need of a tools such as oneSql.

These users probably currently have a favourite tool for each operating system platform they use. I’d like to replace their existing tools with oneSql. I hope to do this by focusing on the features that are most important to them and eliminating those that seek to overcomplicate the typical SQL product.

I also hope to introduce new functionality that will interest those same individuals who can get additional benefits from using oneSql. For example the ability to put the Mac, Windows and Linux versions of oneSql onto a USB Drive and then connect the drive to virtually any computer and load and use oneSql, without installation, is fairly unique.

Multi Language Support – English / Spanish / French and German, will all be featured in the initial Version 1.0 release. This will be the first time I have designed and written software from scratch to incorporate multiple language support.

Some of the Key Features and Benefits of oneSql available in the initial 1.0 Release are noted below:

  • Support for English / American / French / German / Italian and Spanish Languages
  • Native Support for Windows, Mac OSX and Linux
  • Support for SQLite and MySQL Databases
  • Simple, Fair and Inexpensive Licensing
  • Corporate Site Licensing Options
  • Half Price Licensing Option for Education and Non Profits
  • Simple, Easy to Use Design
  • High Quality of Software Engineering
  • Consistent use of Fonts and Icons
  • Small Size (14Mb) with No Installation Required
  • User Configurable User Interface Elements
  • Results Grid Customisation, Font Size, Stripe, Separator
  • Maintain a Session Connection Log
  • Maintain a Session History of SQL Statements
  • Double Click to Recall from SQL History
  • Option to Maintain a Permanent SQL History Log
  • Maintain a Database of Connections with Descriptions
  • SQL Syntax Highlighting (Caps, Bold and Colour)
  • User Editable Keyword List
  • Each Statement Execution Timed in Seconds / Microseconds
  • DB Objects Window to Choose Tables, Views and Columns
  • Data Export Facility, CSV (,), CSV(;), Tab Delimited and JSON
  • Save and Load External SQL Scripts
  • One Click Record Count – Any Table
  • One Click Fetch 20 Records – Any Table
  • One Click Fetch All Records – Any Table
  • Insert a SQL Query Template
  • Option to Automatically Prefix Columns with Table Name
  • Option to Automatically Append a Comma to the Column Names
  • Window Sizes and Positions Saved on Exit
  • User Interface Customisations Saved on Exit
  • Multiple Statements Parsed and Executed Sequentially
  • Unique ‘User Prompts’ Facility
  • A Social Menu, Easily Connecting You to Me
  • One Click Email Support

Some of the Features and Benefits I envisage for future editions of oneSql are noted below:

  • Information Cleansing and Conversion Scripts
  • Command Line Scripted Access
  • Piped Output Options
  • Add Support for PostGres
  • Add Support for Oracle
  • Add Support for ODBC
  • Test Support for MariaDB
  • Option to Publish the Results as HTML, to a Web Server
  • Access Privileges and Restrictions
  • Autocomplete for SQL Keywords
  • Online Manual
  • Store Scripts in the Settings Database
  • Option to Attach a Script to a Specific Connection
  • iOS and Android Versions

Summary

At the time of writing oneSql is just a few weeks from Version 1.0 Release.  Release will be via my website initially (www.stevencholerton.com) followed by the Apple Mac Store.

It’s interesting to me that my idea to release this product was met by a lot of anger and derision by someone who helps develop a product with which oneSql potentially competes.

At the end of the day the SQL Tool market is fragmented, and without any clear market leader there are opportunities for all.  As a recently passed friend of mine was fond of saying, ‘Even a Mouse can look at the Queen !’ Live and Let Live I reckon, there are enough wars in the world without starting any more, and let’s just agree to let our products do the talking.

oneSQL Legend

 

Steven Cholerton
April 2014

Dedication: oneSql is dedicated to Alison Fowler. RIP.

 

Blogfooter

 Affiliate Links

DataViewer 1.3.0 [Update]

This latest update to the DataViewer components for Xojo and REALStudio contains the following enhancements:

  • List View Configurations Saved on Exit
  • DB Objects Now Available from the Tab Area
  • Database Objects List, Now Double Click to Insert
  • Option to prefix Columns with Table Name
  • Option to append a Comma to the Column Names
  • User Input Prompts [[T-xxxxx]]
  • DML now Supported as well as Queries
  • Parsing of Multiple Statements with Sequential Execution
  • Multiple Small Bug Fixes

DataViewer is a small collection of components that allow a Xojo or RealStudio Developer to put a full featured SQL Query and DML tool into their own applications for a one time payment. There are no restrictions on use. The images below are from the latest version.

Click here to download the Demonstration App for Mac, Windows and Linux.

www.stevencholerton.com

 

Blogfooter

 Products and Affiliate Links

oneSql: Support Window

Available from the oneSql Help menu. This window will also appear in other products as a standard feature allowing customers to email support directly from within the application. From my point of view the email will automatically contain everything I need to know about the version of the software they are running, which will help me greatly.

www.stevencholerton.com

Blogfooter

 Products and Affiliate Links

 

oneSql: User Prompt Fields

oneSql Beta Update: 0402

Unique Prompt Fields are field templates that are setup in advance and saved with a SQL Script. When the script is executed the user is prompted for the necessary values to use. The video below shows how this works: 

UPFs are especially convenient when writing a query for use by yourself or a third party, and when the query will have to be executed several times, for example as part of a weekly / monthly reporting regime. The third party would need to know nothing about SQL to be able to load and execute a query with embedded UPFs. Consistency and Accuracy are maintained using UPFs.

Here is another example showing each stage of working with the User Prompt Fields. The first image shown below shows a SQL Query that has been loaded from an external file. You can see in the image that there are three UPFs, a Number Value, a Text String and a Date.

Onesql up 1

 

An explanation of the format for a UPF is shown in the next image:

Upf

The next image shows what happens when this query is executed; The query is parsed and all UPFs are pulled into a window and presented to the user asking for the required input.  There is no practical limit to the quantity of UPF’s that you can use in any given query,

Onesql up 2

This next image is the same as the one above, but with the required information having been entered by the user.

Onesql up 3

Pressing the Continue button on the User Input window reformats / rewrites the query using the information entered by the user and then immediately executes the query and displays the results in the Results Set.  See the image below:

Onesql up 4

UPFs are available in oneSql from Beta 0403.  To request a Beta Test copy of oneSql, please contact me: beta@zombielabs.net

Blogfooter

 Products and Affiliate Links

oneSql Beta Update

The Beta Test for oneSQL has been going well and I am very grateful for the feedback received. I still want additional Beta Testers however, so if you are interested please let me have your details here.

Betatesting

Since the start of the Beta barely a fortnight ago the product has changed in many subtle (and sometimes not so subtle) ways. I have documented the highlights below:

To start with the Database Logon and Connection Setup windows were combined into one single window that works in a far more intuitive fashion. Thanks primarily to Sasha Schneppmueller for his suggestions and feedback concerning the Logon and Connection Setup windows.

A Log ‘tab’ has been added to the Logon window and this records the history of the various database actions performed during the current session.

Thanks to Trisha Duke for thoroughly testing the CSV Export routine, which unfortunately had a couple of small bugs that had gone unnoticed. These were fixed and additional CSV export added using a ; rather than a Comma, in order to satisfy the standard in various Northern European countries.

The connection detail is now shown in the Titlebar of the main window. Still not sure if I like this …

The SQL can now be executed using a Shortcut Key. Cmd+R on the Mac and Ctrl+R on Windows.

James Sweiderk can up with some comments and issues, one of which is still outstanding (already implemented – just needs uploading). I have however fixed the issue with the USE command on MySQL and the list of Database Objects is now updated accordingly.

Peter Fargo mentioned some issues with inconsistency with the User Interface and Selection. I have now removed the Drag and Drop from the Database Objects lists and implemented Double Click which works faster / better and feels ‘cleaner’.

A bug with executing more than one statement from the same block of SQL text has been fixed. Another bug concerning the SQL History has been fixed. You can now double click any item in the list and it is copied back into the SQL Text area.

The Mac OSX version is now a 100% Cocoa product so plays extra nicely with the latest Apple Operating System updates.

In the latest Beta (0203) there is also the option to automatically prefix the Column Names with the Table Name and additionally to automatically insert a Comma after the insertion of a Column Name. These improvements help with Readability and Fast Query Composition respectively.

Some Images 🙂

www.stevencholerton.com

oneSQL Legend

Products and Affiliate Links

XojoBuildingBlocks Taking Shape

I’m gradually starting to build up the XojoBuildingBlocks resources. Suggestions, links and advice all gratefully received. So far I have built the outlines, with minimal content, for the following pages;

I’ve also had some stickers and other promotional materials created which have turned out very well, and will no doubt be of use for forthcoming events I have in mind 🙂

xojobuildingblocks

blog_footer.png

Products and Affiliate Links