oneSql: Now in French

Onesqlsupportedlanguages

The latest version of oneSql Beta Edition now supports French as well as English. German, Spanish and Italian coming very soon 🙂 We are still keen for more Beta Testers, especially those who are running French Operating Systems on their PC’s or Macs.

Frenchman

A couple of images 🙂

OneSqlFRE2

OnesqlFRE1

 

Blogfooter

 Products and Affiliate Links

R10Cipher: New Release and Discount

A new version of my best selling product,  R10Cipher was released earlier today.

R10cipherfooter

This is a free of charge (for Version 5 Customers) interim release of R10Cipher which fixes some issues in Version 5, prior to the commercial release of Version 6.

On the Mac this version is now fully Cocoa which makes this version the fastest and most stable yet. The Clear Text area has also been substantially worked on and no longer feels sluggish when working with larger documents. Performance has also been increased on Windows and Linux.

There is a new Support window, accessible from the Toolbar.

The three available Views; Main, Activity and Keys can once again (as per Version 4) be accessed from the Toolbar as well as the Menus. In addition they are now ‘Toggle’ buttons.

The Encryption and Decryption engine remains unchanged from previous releases.

As an incentive anyone purchasing R10Cipher in the next week can email me and ask for a 30% discount code. They will also receive the Version 6 upgrade free of charge next month.

Here are some images of the new release:

R10cipher55

Blogfooter

Products and Affiliate Links

 

oneSql: Multi Language Support

The latest Beta version of oneSql has additional Help Tags added, some small bug fixes, and much more significantly it has the infrastructure added to allow for a Multi-Language Interface. So for example if you are running a French Operating System on your computer then oneSql will have it’s User Interface shown in French, the same for German, Spanish and also Italian.

Currently it supports English(UK) (English) and English (American) – seriously! – where the USA drops a ‘u’ from Colour or puts a ‘Z’ where an ‘S’ belongs then this version will reflect that 😉

I’ve commissioned the other translations and so far have them available in German and Italian, once I have the other translations I will import them into oneSql and release a true Multi Lingual Beta version for testing.

www.stevencholerton.com

Blogfooter

Products and Affiliate Links

Customer Feedback

All I did was send this customer a new license for R10Cipher after he lost his license during a reformat of his hard disk.  This was his reply:

Thank you, Steven. Looking forward to your next gem. – Joe

www.r10cipher.com

It means a lot to get thanked like that. Cheers Joe.

 

Blogfooter

 

Products and Affiliate Links

 

BCS Elite: Top Contributor

I was Top Contributor to the British Computer Society, BCS Elite Group recently 🙂

www.stevencholerton.com

topcon2

 Products and 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