>  Inicio

 >  Promociones

 >  Boletines

 >  Soporte

 >  Productos

 >  Regístrese

 >  Noticias

 >  Empresa

 >  Foros

 >  Descargas

SQLifter for VB6

Analyze the SQL in VB6 projects

SQLifter finds the SQL in a Visual Basic 6.0 project. Understand how your VB6 system uses SQL databases. View the exact SQL used. View the SELECT, UPDATE, INSERT and DELETE locations. Determine where table X is being used in VB. Determine critical data access code, such as lines that update data.

Download Demo

Visual Basic 6.0 database cross-referencing utility

SQLifter is a specialized code analyzer for Visual Basic 6.0 database projects. It tracks database use in VB. SQLifter supports SQL databases such as Access, SQL Server or Oracle.

Click para agrandar

List all SQL statements in project, both static strings and run-time constructed SQL.

• List database tables used by the application.
• List queries executed by the application.
• List SQL statements reading a table or executing a query.
• List SQL statements updating a table. List UPDATE, INSERT and DELETE.
• Determine hotspots: VB locations that read from or write to a database.
• Find all SQL statements defined or executed in a VB module.
• For a table or a view, find all VB routines where it is being used.
• For a table or a view, find hotspots that execute SQL requiring the table/view.
• Follows the data flow, including parameter passing and variable assignments.

Tasks to accomplish. Use SQLifter in reverse engineering, maintenance and code review. SQLifter helps you with the following tasks:

• Review critical code locations, such as lines that update data.
• Understand your database application before changing it.
• Determine how your program reads and writes data.
• Find potential data related errors.
• Check to see if the SQL conforms to your corporate standards.

Technical details

The following data objects are supported: DAO, ADO, RDO. SQLifter supports most SQL databases, including Access, SQL Server and Oracle. The program works by reading Visual Basic 6.0 code. It does not require a database connection.

SQLifter supports ANSI SQL92 and also some of SQL99. It analyzes most SQL statements, including (but not limited to) SELECT, UPDATE, INSERT, DELETE, EXEC, CREATE TABLE/TRIGGER/VIEW, ALTER, GRANT, REVOKE, IF, WHILE, BEGIN-END, CHECKPOINT, SHUTDOWN, SET, REPLICATION, LOG.

Sleep tight. Know your SQL.

• Which routines update the Orders table?
• Does this application delete any records? Where?
• Does this write to the Contracts table or not?
• Which tables does Form1 update?
• Which SQL queries require the Inventory table?
• What tables does this parametrized query use?
• Does this module use the database or not?
• What queries can this function execute?

Does it work?

SQLifter uses a highly advanced analysis technology to retrieve every use of SQL in your program. It does a data flow analysis to determine how parameters are passed and variables assigned new values. SQLifter reliably detects the programmatic building of SQL statements regardless of the complexity of your system. It can resolve parametrized queries and queries built via the "&" string concatenation. This functionality is unique and suited for even the most complex database systems written in VB.

You can save the analysis results as an HTML report for your project documentation.

System requirements: Visual Basic 6.0 run-times installed on the computer.

Regístrese en Abits Chile y se mantendrá informado de nuestras noticias y promociones.