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

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