Free visual sql designer light 3.99 software for windows

RvAlgo Light is an universal tool that is able to create corporate reports systems and data analysis systems. Light version. Full functional version. The package includes help files and Demo-examples. Use login "1000" and password "2" for initial connection.
Main features:
- Includes three visual report designers
- Includes OLAP-report designer (OLAP-Cubes)
- Supports hyperlinks in reports. It allows you to build dialogs with user during report previewing and form reports by "drilling" method (detailing)
- Visual generation of input parameters dilog boxes.
- Visual creating of the report templates for high speed dot matrix printing
- Powerful Pascal-similar script interpreter, which allows you to create dialog forms, to work with different databases. The script interpreter has a lot of built-in functions: working with files, accessing windows of Microsoft Windows system through API functions, etc.
- Modular script programming with Pascal-interpreter.
- Centralized storage of scripts and report templates in the database.
- Different users may have different access rights to view data presented in the reports.
- Database connection through dbExpress, DOA (Direct Oracle Access), ADS (Advantage Database Server and files of dbf format), ADO (OLE DB), BDE, ODBC. That allows working with the vast number of SQL databases, such as Oracle, MS SQL, Informix, DB2, InterBase,Postgress SQL,MySQL; and working with files of different formats of local databases.
- Ability of simultaneous connections to different databases through different drivers.
- The powerful collection of internal SQL-objects allows you not only selecting data from the database, but also running stored procedures and changing data.
- Running the program with parameters from command line allows calling Pascal-scripts according to the timer event.
- Usage of external dinamic link libraries of classes (in bpl format,Delphi)

A visual tool for easily generating of SQL statements. By connecting to an installed ODBC source all tables and columns in the database are displayed. After this complete queries can be generated by simple point-and-click operations, and the final query can be tested directly within the program. This way you know that the SQL code is correct prior to copying it to your source code or ASP page.