Icon of program: McCoy_RDBMS

McCoy_RDBMS for Windows

By Brad McCoyTrial versionUser Rating

Key Details of McCoy_RDBMS

  • Perform SQL on ASCII Database Files.
  • Last updated on August 13, 2013
  • There have been 3 updates
  • Virus scan status:

    Clean (it's extremely likely that this software program is clean)


Enlarged image for McCoy_RDBMS
McCoy_RDBMS 0/1

Developer's Description

Perform SQL on ASCII Database Files.
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.


Explore More


Full Specifications

GENERAL
Release
December 21, 2012
Latest update
August 13, 2013
Version
2.1
OPERATING SYSTEMS
Platform
Windows
Operating System
Windows 7, Windows 10
Additional Requirements
ASCII Database file
POPULARITY
Total Downloads
134
Downloads Last Week
0

Related Software