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

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

 

oneSQL Now Available

oneSQL is now available to download, free of charge.  This is a Beta Version of oneSQL which means that it is nearly ready for general release but may still have some bugs, be incomplete in some areas, have a lack of documentation or other issues.

This current version appears stable and working well – but I welcome your feedback.

In particular if you use Linux I would love your feedback as so far I have been unable to test on Linux.

I only ask for your Name and Email Address and I will send you the current version of oneSQL. Your email address will not be sold or abused in any way – so don’t feel uncomfortable giving me that information. Your email address will only be used for communication regarding oneSQL unless you agree otherwise.

Having got the above out of the way I perhaps ought to explain what oneSQL is and why you should care;

oneSQL is a Software Program that allows you to send SQL Query SELECT‘s and other SQL Commands to either a SQLite or MySQL database. oneSQL is written using the DataViewer Components for Xojo and RealStudio.

oneSql is a Stand Alone SQL Query and Data Export Tool for SQLite and MySQL on Windows, Mac OSX and Linux.

Why Use oneSQL ?

  • One SQL Query Tool for Mac OSX, Windows or Linux
  • One SQL Query Tool for both SQLite and MySQL
  • No Installation Required
  • Very Lightweight, Approx 6Mb
  • Simple, Fair and Inexpensive Licensing
  • Easy and Simple to Use
  • Written and Supported in the United Kingdom

Some More Benefits

  • Shows All Database Objects, Tables, View and Columns Etc.
  • Drag and Drop Database objects into the SQL
  • Double Click Database objects to Copy to Clipboard
  • Customised Results Grid, Font, Size, Stripe, Divider Etc.
  • Dynamic SQL Keyword Highlighting
  • User Definable Keywords List
  • Each Select Reporty the Time Taken
  • Export Results Data in Tab Delimited, CSV or JSON Formats
  • Save and Load SQL Scripts
  • One Click for Record Count, any Table
  • One Click to Fetch 20 Records for Quick Query
  • One Click to Fetch All Records
  • Insert a SQL Template
  • Reactive Results List – Auto ‘Fit to Grid’ or ‘Show Horizontal Scrollbar’
  • SQL History List – Double Click to Recall
  • Windows Sizes and Positions Saved on Exit
  • List View Configurations Saved on Exit

Q: What is the difference between oneSql and DataViewer ? A: oneSql is a stand alone application for querying, editing and manipulating SQLite and MySQL databases. DataViewer is the necessary Modules and Windows to allow you to incorporate the querying functionality into your own software, and restrict access for the end user to the database(s) you need them to access only.

oneSQL Legend oneSQLoneSQL3

blog_footer.png

Products and Affiliate Links

 

 

DataViewer [Update] 1802

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

  • The Database Objects Viewer window has been redesigned.

DV DBObjects 121

blog_footer.png

Products and Affiliate Links

Sorting and Archiving

Sell Some • Bin Some • Keep Some

In my ongoing quest to reinvent myself this year I’ve been sorting out my Software Products and archiving Source Code, Documentation, Images, Demo Movies etc. The image below is most of the software products I have written since 2009, mostly in Xojo / Realstudio, some in VB.Net, C#.Net and a couple in CoronaSDK.

I would never have guessed there would be quite so many 🙂

www.stevencholerton.com

blog_footer.png

Products and Affiliate Links

Software For Sale

I’m currently changing direction with my business and moving into some different, but clearly defined areas – all will be revealed soon – although I think some of my plans have already been ‘leaked’ due to my excitement about the future and my inability to keep quiet 🙂

In fact here I go again – these are some products and areas that I will be involved with in 2014 and beyond:

Due to this change in direction I have decided to put some of my existing products up for sale – outright purchase including full Source Code, Intellectual Property, Copyright, Domains, Support etc.

All of the software is written using Xojo / Realstudio and some of the products use plugins from Monkeybread Software.

I’ve had a lot of interest in the few times I’ve mentioned this so I am in the process of putting together a sale page, which I will document here when complete.

Software Sale

blog_footer.png

Products and Affiliate Links

Xojo Developers: Top Contributor

I was rather pleased when I saw this when logging into the Xojo Developers Group Forum recently 🙂

www.stevencholerton.com

blog_footer.png

Products
Affiliate Links

Listbox Exporting: Take 2

Following on from a previous post last week where I talked about exporting data from a Listbox in Xojo / REALStudio, I decided to build a general purpose export routine with the extra features that were commented on and also some extra features that I believe make this routine even more useful.

Note: This is not the only way of programming a generic export function and no doubt it is not the best. It does however work and work well.

This export routine is a single simple function and is accessed by sending a string of parameters and having the results of the export request returned as an Integer containing different values depending on the success or what kind of failure occurred.

The parameters that are required by the function are:

  1. Delimiter (Comma, Tab (chr(9)), Full Stop etc.)
  2. Headings (YES or NO)
  3. Name of the Source Listbox
  4. Filename Extension (Tab, Csv etc.)
  5. Default Filename (Export.txt)
  6. Surround with Quotes (YES or NO)

A call to this export routine would therefore look something like this:

www.stevencholerton.com

For ease of reading and maintainability this is better:

www.stevencholerton.com

The actual export function itself looks like this:

www.stevencholerton.com

Note: There is a small error in the picture of the export function above. This error has been fixed in the Text download. Thanks to Axel Schneider on the Xojo Forums for pointing this out. 

To download the export function as text, please click here

blog_footer.png

Products
Affiliate Links

Xojo / RS Export Listbox

I’m going to start adding some software development tips and tricks and other useful bits and bobs to this site with the hope that other people can learn and benefit from my knowledge and experience in the same way that I have learnt, and continue to learn, from others.

I’m not sure yet if there will be a particular focus or even how often I’ll post – but that will become apparent over time.

I’ll start with this; a simple method, written in Xojo / REALStudio, to take the contents of a Listbox and generate a Tab Delimited export to a text file for every row and every column in the Listbox. In this example the Listbox is named lstTemp and you will have previously populated it with your data.

  ‘Export the List as Tab Delimited
  if lstTemp.ListCount = 0 then Return
  dim f as FolderItem
  dim t as TextOutputStream
  dim intRow, intColumn as Integer = 0
  f = GetSaveFolderItem(“txt”,”Export.txt”)
  if f = Nil then Return
  t = f.CreateTextFile
  for intRow = 0 to lstTemp.ListCount-1
    for intColumn = 0 to lstTemp.ColumnCount-1
      t.Write ConvertEncoding(lstTemp.Cell(intRow,intColumn),Encodings.SystemDefault)
      t.Write chr(9)
    next
    t.Write EndOfLine
  next
  t.Close

Originally when I published this on a previous blog, I had some feedback from a friend of mine and fellow Developer, Eric Gibbon of MacTasks. This is what he had to say:

The code is quicker if you store the lstTemp.ListCount-1 and lastTemp.ColumnCount-1 in local variables, as for every loop iteration your code calls the ListBox to get its ListCount or ColumnCount value and then subtracts one. However if these values are stored in local variables this repeating does not happen. For a small list this will not matter but for larger ones there will be a performance difference. So the code would be like:

dim nRows as Integer = lstTemp.ListCount – 1
dim nCols as Integer = lstTemp.ColumnCount – 1
for intRow = 0 to nRows
  for intColumn = 0 to nCols
  next
  …
next

 

It would also be nice to add a parameter to your routine for “Include Headings” and write the ListBox headings to the file first if this parameter is True.

I hope this helps someone.

Blatant Advertising: New Xojo / REALStudio DataViewer Component

blog_footer.png

Products
Affiliate Links

DataViewer [Update] 2101

Another couple of additional features added to the DataViewer Components for Xojo and REALStudio:

  • Reactive Results – Auto ‘Fit to Grid’ or ‘Show Scrollbar’
  • Results List now inside inside a Tab Control: For Future Use

Download:

http://bit.ly/KR2ePp

DataViewer by Steven Cholerton

 

blog_footer.png

Products
Affiliate Links

DataViewer [Update] 1701

Another couple of additional features added to the DataViewer Components for Xojo and REALStudio:

An additional Menu Option which will fetch all Rows and all Columns for the currently selected Table.

An additional Menu Option which will create a SQL Statement ‘Template’ for the currently selected Table, see the example shown below:

DataViewer

The updated libraries are available for download now.

blog_footer.png

Products
Affiliate Links

jSql: Final Beta

jSql is a MySQL and SQLite Query Tool for Windows and Mac OSX.

jSql is built using REALStudio / Xojo and the DataViewer Components.

jSql is Small, Simple, Fast and Cross Platform for a seamless experience whether using Mac or Windows as your platform of choice.

Final Beta was sent out to ‘Early Adopter’ Customers today and depending on feedback from them, the final release will almost certainly be early next week.

At this moment in time I am still unsure regarding pricing. How much to charge – or should I give it away – using it as an example of what can easily be achieved using the DataViewer components. Maybe add a load more features and benefits and release a chargeable Pro version later ?

Here’s a couple of screenshots to be going on with 🙂

jSql by Steven Cholerton

jSql by Steven Cholerton

Any comments or feedback:  scholerton@gmail.com

DataViewer [Update] 1501

Thankyou to those who have so far purchased my component and also to those who have made constructive suggestions.  Two of these suggestions have been implemented in a new release earlier today:

  • One Click to Fetch 20 Records for Quick Query
  • One Click for Record Count, any Table

DataViewer

DataViewer

More to come …