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.
What is new in this release:
Version 2.1: Connection Wizard, Forms View, Edit data in a query, SQL Split Where clause, Suppression Join.
Requirements:
ASCII Database file
Limitations:
Limited to 100 records or less
Comments not found