Hockware VisPro Database Designer

From EDM2
Jump to: navigation, search

VisPro Database Designer was included with VisPro/REXX Gold, VisPro/C, VisPro/C++, or VisPro/Reports. This program allows you to visually create database applications for ODBC-enabled databases from scratch or reverse-engineer an existing database into a database diagram. Because it is a visual tool, you can print and view complex databases using Entity/Relationship (E/R) diagrams. This allows you to quickly pinpoint logical design problems with your database application so you can correct them easily and accurately. The Database Designer supports DB2/2, Watcom SQL, and all ODBC-enabled databases.


The SQL syntax builder (not available with VisPro/Reports) is a major feature of the Database Designer. It allows you to generate error-free SQL statements because the SQL builder enforces the proper syntax. And you don't have to be an SQL expert. If you don't already know SQL, you will once you've used the Database Designer.


The Database Designer allows you to:

  • Visually create relational database schema.
  • Export Data Definition Language (DDL) files for creation of your databases.
  • Reverse engineer your existing databases into E/R diagrams.
  • Print even the largest of diagrams to poster-sized printouts.
  • Interact with database tables the same as you would with any Workplace Shell object.
  • Modify tables and relationships with pop-up menus.
  • Direct editing allows you to easily change table names.
  • Workplace Shell drag and drop allows you to move, delete and print tables, create SQL statements that interact with tables, and program DB2/2 applications.
Database Designer

The SQL syntax generator has the following features:

  • Point and click to build SQL statements.
  • The SQL syntax builder enforces proper syntax, so you spend less time typing and correcting errors.
  • Information line displays descriptions of each SQL element.
  • SQL syntax diagram provides a visual rendering of the statement.
  • SQL preview displays the progression of the SQL statement.
  • VisPro/C and VisPro/C++ generate native embedded SQL for Sybase, Oracle, IBM DB2 and SQL Anywhere (formerly Watcom SQL).
SQL Syntax Generator

Drag and drop programming:

  • Allows you to quickly create panels to interact with DB2/2 tables.
  • Dragging a table to a VisPro Layout view generates bug-free code.
  • Optionally create fields for each column. Optionally create Add, Change, Delete and Search buttons with all the necessary SQL and code.
  • Optionally create an OS/2 container to store results searches and other user interactions.
  • VisPro/C and VisPro/C++ automatically manage all the complexities of generating embedded SQL and make files that include SQL pre-compiling and binding.


  • VisPro Database Designer 3.1 (1996-11-21)