| |
SQL Refinery is a data mining tool, automatic printed report generator, and database application programmers coding tool. Using SQL, and when possible, live result sets, data can be processed on local and remote databases.
For SQL data mining, a smart SQL Expression Editor helps build Select, Group, Insert, Update, and Delete queries. Tables and fields are point and click selected from lists. You can drag simple Select * queries from the current table list. The SQL Expression Editor places its queries in an edit box, ready for your manual fine tuning and command to execute. The online help system contains a fair number of simple SQL examples.
SQL Refinery is not a presentation quality report generation tool with all the attendant complexity. Software developers and other immediate need users will find SQL Refinerys Spartan report functionality simple but useful. Selected result set columns are automatically formatted and width sized for printed grid style reports.
Database field information can be acquired, printed or saved to a file. Field information can be formatted to show table structure or automatically converted to Delphi FieldByName statements including field type. Code for other languages is supported using a manual prefix/suffix strategy. |
|