Join or Sign In

Sign in to add and modify your software

Continue with Facebook Continue with email

By joining Download.com, you agree to our Terms of Use and acknowledge the data practices in our Privacy Policy.

Developer's Description

SQL on a flat file? Yes! You can perform SQL on about any type of ASCII database file. This application lets you include your files using a connection wizard as a visual reference or you can import your data from an ODBC source. You can draw lines between the fields to aid you in writing your SQL Using a grid editor or forms type of editor you can view and edit your database information. Then you can write SQL statements to create queries which are viewed in the grid editor; and some queries can be edited too. You can perform most of the standard SQL known today. Create Tables, Rename Fields, Insert Rows, Join Tables, Sort Tables and Where Clauses... There is an intellisense popup that will also aid you in writing SQL. Plus there are additional SQL clauses that have been added to the language as well. For example a suppression join will drop the rows from the first table that match the rows in the second table. Split By {Expression} will pull out records that return a true result when the expression evaluates. The remaining records will drop down to possible other "Split By {Expression}" clauses. This gives you the ability to split a file into multiple files. As with other SQL you can make a query of a query too. When doing this I usually make the second query a child node of the first query in the tree view portion of the GUI interface. But truthfully... the SQL interpreter doesn't care if the nodes are inside each other or not. Nor does it care if the file is even declared in the GUI either. You can use relative file naming to refer to a file that resides in another workspace (folder) . After you are done working with your databases you can upload them back into an ODBC source. Or you can use them locally. This tool is nice because data does not have to be imported to work on it. The data remains in its original state. However you will notice indexing and query files being added to the same folder that the data resides in.

Full Specifications

What's new in version 2.1

Version 2.1: Connection Wizard, Forms View, Edit data in a query, SQL Split Where clause, Suppression Join.

General

Release December 21, 2012
Date Added December 21, 2012
Version 2.1

Operating Systems

Operating Systems Windows, Windows 7
Additional Requirements ASCII Database file

Popularity

Total Downloads 134
Downloads Last Week 0
Report Software

Related Software

Microsoft Office Access 2010

Free to try
Microsoft Office Access 2010

CSV Viewer

Free
CSV Viewer

FileMaker Pro

Free to try
FileMaker Pro

Excel Add-In for XML

Free to try
Excel Add-In for XML

Best VPN Services for 2021

Best for privacy

3 months free with 1-year plan

Best for customer support

$39.99 for the first 12 months

Best for zero logs

$4.87.99/months for a 1-year plan

Best money-back guarantee

$2.99/months for a 3-year plan