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

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.

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: DataViewer

Visual Guide to oneSql: Part 2

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

Results Tab Selected

dataviewerwindowexplained1

Database Objects Tab Selected

dataviewerwindowexplained2

Statement History Tab Selected

dataviewerwindowexplained3

 

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

oneSql Database Tool 1.0: Press Release

[prMac.com] Ripley, Derbyshire. United Kingdom – chol.technology are pleased to announce Version 1 of a brand new MySQL, PostgreSQL, MariaDB and SQLite SQL Query and Data Import / Export program for Mac OSX, Windows and Linux. Three Operating Systems, Four Databases and Five Languages Supported including in addition to English; French, Spanish, Italian and German. Clear and unrestrictive Software Licensing, putting customers needs first.

oneSql is a stand alone, lightweight, no install neededSQL Database Tool for OSX, Windows and Linux.

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

These users may currently have a favourite tool for each operating system platform they use. I’d like to supplement or even 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 competing products.

We have also introduced new functionality that will likely interest those same individuals who can now 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 and extremely useful.

With the unique ‘User Prompt Fields’ functionality, use within an organisation can extend far beyond the Technical User and to the desktop of the End User. Scripts written by the Technical User can be run as Reports by the End User without modification as each variable, for example Data Start and Date Finish, is prompted for appropriately. The End User needs to know nothing about SQL or the script.

Benefits Include:

  • One SQL Tool for Mac, Windows and Linux
  • One SQL Tool for SQLite, PostgreSQL, MariaDB and MySQL
  • Unlimited Time Limit for the Trial Edition
  • Unrestricted Features for the Trial Edition
  • Small and Lightweight, Approx 20Mb for all Versions
  • Speed with Reliability
  • Scripts Library to Store Your Scripts for Future Use
  • Easy and Simple to Use
  • No Installation Required
  • Save Time with Data Import Templates
  • Saved Connections Stored Safely using Encryption
  • Get Started Quickly with the Examples Database
  • Productivity with User Prompt Fields
  • Increased Database Security
  • Full Manual Included as a PDF
  • Written and Supported in the United Kingdom
  • Simple, Fair and Inexpensive Licensing
  • Zero Effort Corporate Licensing
  • Corporate Licensing Available
  • 50% Discount for Education Establishments and Students
  • 50% Discount for Charities and Non Profits

Features Include:

  • SQLite, MariaDB, PostgreSQL or MySQL
  • Objects Tab – Tables, Views and Columns
  • Fully Customiseable Results Grid
  • Auto Highlighting of SQL Keywords
  • User Editable SQL Keywords List
  • Built in Script Library
  • Example Database Supplied
  • Export Data in Tab Delimited Format
  • Export Data in CSV (Comma) Format
  • Export Data in CSV (Semicolon) Format
  • Export Data in JSON Format
  • Save and Load SQL External Scripts
  • One Click for Record Count, any Table
  • Quick Query One Click to Fetch 20 Records
  • One Click to Fetch All Records
  • Insert a SQL Template
  • SQL History List – Double Click to Recall
  • Window Sizes and Positions Saved on Exit
  • List View Configurations Saved on Exit
  • Option to prefix Columns with Table Name
  • Option to append a Comma to the Columns
  • User Input Prompts
  • Enhanced Connection Encryption Options
  • Parsing of Multiple Statements
  • Sequential Statement Execution
  • Highlighted Statement Execution

Taking Security Seriously:

There are two choices for how encryption is used to secure your database connection information. The first choice encrypts the connection password in such a way that it is then specific to your computer. If you copy oneSql and the settings files onto another computer then the stored credentials will not work. This choice is ideal for use in a more secure environment, where for example access to databases is only permitted from select computers and / or locations.

The second choice encrypts the connection password in such a way that you can copy the oneSql folder from your computer, put it onto your laptop, or another computer, and your stored credentials will work fine.

This also means that you can copy oneSql onto a USB Drive, run it from that USB Drive on any Mac, Windows or Linux machine you plug it into.

Licensing:

With the development of oneSql came the development of a new Software Licensing scheme, designed to put customers first and to ensure they we never punish the genuine, fee paying customer for the actions of the software pirate. Our customer friendly, super simple software license is shown below:

‘You can copy and use oneSql on your own personal computers with one instance of oneSql allowed to be in use at any one time. You can put oneSql on a USB device and plug that into anyones computer and use oneSql from the USB device for as long as you need. All Licenses are valid for all supported Operating Systems, all supported Languages and all supported Databases.’

Half price licenses are available to Educational Establishments and Students also Charities and Non Profit Organisations.

Software Referral Scheme:

Also new with oneSql is a Software Referral Scheme. Payment will be made to an existing customer thirty days after a new customer makes a purchase based on an existing customers referral, and quoting the existing customers referral ID within forty eight hours of purchase. The payment amount is ten percent of the new customers spend (before taxes) and the payment will be made via Paypal.

Pricing:

oneSql is available from $30 for the Single User Edition

Availability:

oneSql is available now.

Testimonial:

‘I believe oneSql has found its niche; simple and powerful. Unlike many other SQL Tools oneSql is slim and easy to work with’ – Dennis, Beta Tester

Something Different:

We wanted to do something different to mark the release of oneSql, so we have decided that the first 10 people to purchase any edition of oneSql, with the exception of the Single User Standard Edition, will receive a Limited Edition oneSql mug (1 of only 20 in existence) as well as a goody bag of assorted promotional items and 10% cash back after 30 days. We’ll ship these bonus items anywhere in the world.

The first 100 purchasers of oneSql Single User Standard Edition receive 10% cash back after 30 days.

oneSql is dedicated to Alison Fowler RIP. See ‘ya Ali B. We miss you.

onesqlscreenshot1

chol.technology is the trading name for Steven Cholerton. Since the late 1980’s Steven have been heavily involved in Software Development and Information Technology.

He is a Chartered Information Technology Professional, awarded by the British Computer Society, a Fellow of the Institution of Analysts and Programmers, a Certified Ethical Hacker, an Oracle Certified Professional, author of several eBooks and many Commercial Software Products, and a committed and passionate developer of Custom and Bespoke software for Mac, Windows, Linux, iOS and Android.

Steven personally designed and wrote the R10Cipher file encryption software used by Leeds Institute of Molecular Medicine, Cancer Research UK.

###

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 Latest Beta 3006c with Encryption

Updated 02/07/2014-1740: The bug in 3006b which causes an intermittent crash when attempting to logon to a Database Connection, has been fixed along with the following tweaks in Release 3006c:

  • New Preferences Option to Hide the External SQL File Load and Save Buttons
  • Adding to the Script Library no Longer Clears the Script List
  • Double Clicking the Script List now Populates the SQL Text on the Main window
  • A little bit of Refactoring

onesql3006b

This latest Beta Release of oneSql comes very close to the official Version 1.0 release, which I expect to be within the following two weeks, definitely before the end of July. I have one more language to add (Spanish) and I already have the translations so that should be relatively straightforward.

I also have a few tweaks to the software to do, the Manual to finish and some more testing and then hopefully we will be good to go with a Version 1.0 release. There are a couple of features that make this a fairly major release, so read on 🙂

I’m always keen for more Beta Testers, so if you are interested please CLICK HERE!

Release Notes:

One major change in this release is that the stored Password Credentials for the Connections are now stored in an encrypted manner. This stops someone snooping your database password by querying the connection record from the settings database.

There is more to this however. See the image below of the Preferences window from oneSql.

onesqlprefs3006b

There are two choices for the encryption. The top choice encrypts the Connection Password in such a way that it is then specific to your computer. If you copy oneSql and the Settings Files onto another computer then the Stored Credentials will not work. This choice is ideal for use in a more secure environment, where for example access to databases is only permitted from select computers and / or locations.

The second choice encrypts the Connection Password in such a way that you can copy the oneSql folder from your computer, put it onto your laptop, or another computer, and your stored credentials will work fine.

This also means that you can copy (oneSql does not need an installation, nor does it put any files on your computer outside of the oneSql folder) oneSql onto a USB Drive, run it from that USB Drive on any Mac, Windows or Linux machine you plug it into. Did I mention it will render itself in your native language as well – as long as your native language is either English, Spanish, French, German or Italian ?  🙂

Does copying oneSql to a USB Drive go against the Software License ?  No. Restricting access to a single computer either by the installation of Configuration Files or Registry Entries goes against the design remit of Utility software which in my (not so!) humble opinion is the Developers or DBA’s equivalent of a tradesmans tools.

Can you imagine a screwdriver being licensed to only be used on a given object ? What if you had to pay for another license for every object on which you used your screwdriver ? Forget the expense, it’s just not convenient. I don’t want to punish legitimate users of my software in a vain attempt to stop people stealing my software.

My software License for oneSql is simple, and is based on Concurrency. You can use oneSql on one device at once. If you install it on more than one device then you owe me a few extra $$$, which the software is obviously worth or you wouldn’t be bothering to install it multiple times. Site Licenses,  Educational Licenses etc. are all available – contact me for further details: scholerton@gmail.com

Ok, so I diversified slightly(!) in the last paragraph, (in fact, I’ll rewrite the last paragraph and make it its own blog post as I’m sure the licensing question will be asked often.) back to the 3006b release of oneSql.

Please Note that once you have chosen your preferred type of Encryption, you will need to Select Each Connection and Re-input the Password, then Save. This is a one off procedure that is absolutely necessary or else your Stored Credentials will not work.

This release also includes a new Menu – Actions. From the Actions Menu you currently have the following choices available, which are I think self explanatory:

  • Execute SQL: Ctrl / Cmd R
  • Clear SQL Script
  • Clear Results List
  • Clear History List
  • Clear All

One feature that I put in, took out and have now put back into oneSql is the ability to select a portion of the SQL text and execute just the highlighted selection. I have found this facility very advantageous in similar products and believe it is a worthy addition to the oneSql feature set.

The other fairly major addition in this release is the Script Library. The picture below has been annotated so I’m sure you can see where I’m going with this.

onesql3006scriptlibrary

The ability to store SQL Scripts within the SQL database tool, categorised by Connection (or not – if that’s what you prefer) is I believe very important.

Future versions of oneSql will allow far greater capability and flexibility in the Script Library, for now however we have the basics on which to build something extremely useful.

The Script Library window can be accessed from the Tools Menu of oneSql.

IMPORTANT: If you are NOT creating a new oneSql folder from scratch then it will be necesary to update your oneSql Settings file (oneSqlSettings.db in the SupportFiles folder) by opening it with a SQL Tool (oneSql ?!) and executing the following SQL Statement:

CREATE TABLE csh_scr_main (scr_pk INTEGER PRIMARY KEY AUTOINCREMENT, scr_name VARCHAR(50) NOT NULL, scr_script VARCHAR(9999), scr_con_pk INTEGER DEFAULT 0)

This will create the necessary table to store Scripts. This table (and all others required) is automatically created if this is the first time you have used oneSql.

The previous oneSql Beta ran out yesterday (30th June 2014). This release will work during July only, as the commercial release of Version 1.0 will be out before the end of this month.

Purchase

If you would like to purchase oneSql for the pre-release price of £15 (valid until Version 1.0 arrives) then you can do so from here. You will receive the same upgrades and support as anyone who purchases Version 1.0 later at the more expensive (and as yet undecided) standard price.

onesql

Affiliate Links

 

PostGreSQL Support Available for oneSql Beta

The Latest Beta Version of oneSql was uploaded earlier today. The main difference with this version is that PostgreSQL is now a supported database. This is in response to many requests from Beta Testers, Friends and Colleagues.

oneSql now supports MySQL, SQLite, MariaDB and PostgreSQL.

Additional changes in this version include the following:

  • Settings File Renamed
  • SQL Keywords File Renamed
  • Some Rebranding
  • Code Refactoring
  • List UI Updates, now Faster

If you are an existing Beta Tester then please Trash your existing Settings and Preferences files before using this version.

If you would like to become a Beta Tester than CLICK HERE.

Version 1.0 will be available very shortly, assuming this Beta Version doesn't suffer with too may bugs or issues 🙂  If you are a Beta Tester then let me know if you require your 30% Discount coupon and I'll get it sent over to you as soon as possible 🙂

oneSql: New Beta Release for Cross Platform Tool

oneSql Beta Edition 1606 was released earlier today.  With one thing and another this release has been a while coming. I hope it’s considered worth it !

The main changes in this release are:

  • UI / Button Behaviour on Connection Window: Revised
  • MariaDB: Implemented as a Totally Separate Database Option
  • Data Import Templates: Complete
  • New Save Icon
  • Assorted Tweaks, Refactors and Bug Fixes

I have uploaded a couple of movies to YouTube that demonstrate how the Data Import Templates work. These templates could make your life much simpler and convenient should you need to import data often. For the Version 1.0 of oneSql their functionality will remain virtually unchanged, however future releases will include Update as well as Insert functionality, Programmable Column Values, Logically Calculated Column Values, Automation and much more.

oneSql: Creating an Import Template

Using an Import Template

Here are some screenshots taken from the latest version of oneSql.

onesql_1606_4

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

blackdogCRM: New Movie

bdBanner

This new movie available to view below, or via my YouTube account, shows you just how simple it is to upgrade from a single user edition of blackdogCRM to a multi-user MySQL Server edition using our upgrade tool. A four step process that does all the heavy lifting including populating the server database with all the data from the existing single user SQLite database.

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

oneSql: Now in German

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

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

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

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