DataViewer Component

DataViewer
SQL Query and Data Export Tool for Xojo Developers
Windows, Mac OSX and Linux
Size12Mb (DemoApp for All Platforms)
Copyright: Steven John Cholerton
Download: DataViewer
Purchase: Purchase
YouTube: http://youtu.be/3vtkkcy-sqg
databaseimages

Summary

DataViewer is a collection of objects for REALStudio / Xojo that you can easily incorporate into your own applications to give SQL Query and DML functionality for SQLite and MySQL databases along with Data Export facilities. It is available to purchase for use ‘as is’ within your own software or alternatively with Full Source Code. Once purchased there are no restrictions on use.

The Standard Edition of DataViewer costs £50 with the Full Source Code Edition at £150.

Customers

If you are a RealStudio / Xojo Developer who has developed an application, or applications with a MySQL or SQLite database connected, then you could be our customer. Want to offer your End User access to query the database without having to write the tools yourself ? You should be our customer.

Instructions

Drag and Drop the DataViewer components into your application. You call the DataViewer and open the window by calling a method and passing several mandatory parameters.

wDataViewer.op_OpenAndSetup( _
DB_TYPE, _
SQLITE_DB_PATH, _
MYSQL_HOST, _
MYSQL_PORT, _
MYSQL_DB_NAME, _
MYSQL_USER_NAME, _
MYSQL_PASSWORD)

Dependencies

DataViewer requires a Boolean Variable with a value of False called pDemoApp. This variable should be created in the App and given Global Scope.

Features

  • Connect to any SQLite or MySQL Database
  • Very small Footprint. < 10Mb
  • Incorporate Easily into your Own Apps
  • Objects Window - Tables and Columns
  • Double Click to Copy to Clipboard
  • Results Grid can be customised for Font
  • Results Grid can be customised for Size
  • Results Grid can be customised for Stripe Colour
  • Results Grid can be customised for Line Type
  • Results Grid - ‘Fit to Grid’
  • Results Grid - ‘Show Horizontal Scrollbar’
  • Auto Highlighting of SQL Keywords - Caps
  • Auto Highlighting of SQL Keywords - Bold
  • Auto Highlighting of SQL Keywords - Coloured
  • User Editable Keywords List
  • Each SELECT reports Time Taken
  • Export Results Data in Tab Delimited Format
  • Export Results Data in CSV (Comma) Format
  • Export Results Data in CSV (Semicolon) Format
  • Export Results Data in JSON Format
  • Save and Load SQL 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
  • Windows Sizes and Positions Saved on Exit
  • List View Configurations Saved on Exit
  • Database Objects List - Double Click to Insert
  • Option to prefix Columns with Table Name
  • Option to append a Comma to the Columns
  • User Input Prompts
  • DML and Queries Supported
  • Parsing of Multiple Statements
  • Sequential Statement Execution