New Code Comparison Options

In addition to the possibility to compare 2 versions (analyses) of the same code, VE 2018 R2 adds the possibility to compare 2 independent sets of code.

For instance:

  • 2 Forks of an application
  • 2 DB (dev and prod for example)
  • 2 Sets of PBLs
  • 2 Sets of objects
  • Etc.

Web Services Calls

Visual Expert is now analyzing the dependencies between PowerBuilder objects and web services.

Visual Expert lists the objects and methods calling web services. When selecting one of them, their code is displayed with the call to the web service.

This feature supports different strategies for calling web services: OLE objects, SOAP connections.

Code Performance Analysis [Beta]

VE 2018 brings a new set of features to identify slow pieces of DB code (Oracle or SQL Server) and improve their response times

You can:

  1. Sort functions and procedures by "Average Execution Time".
  2. Sort functions and procedures by "Total Execution Time"
  3. Analyze the performance of a chain of calls

Visual Expert Videos

Watch these short videos to catch a glimpse of Visual Expert powerful features

Visual Expert Key Features

Visual Expert is a must-have solution for the maintenance of your PB and DB code.
Using Visual Expert, developers easily discover and start working on any existing applications. Understand the code - Identify the modification - Validate the effect of the change - Generate CRUD Matrix - Documentation - and more!

Identify the Consequences of a Change

"If I change this, what is the effect?"

Estimate what you should modify to accomplish a change.
Don't break your application after a change!

  • If I change this variable, what is the effect on my code?
  • If I add a parameter to a function, what else is affected?
  • If a table or column is changed, which code should I update?

Review CRUD operations in your code
(Create, Read, Update, Delete)

Generate a CRUD matrix showing which programs access your data.

For instance, which DW or Procedures Create/Read/Update/Delete which Tables.

  • Review dependencies between database and PB applications.
  • Analyze the impact of changing your database Schema, for example changing a table definition or adding an index.
  • Estimate software complexity and development efforts.
  • Find out which table is never updated, deleted from multiple places, etc.
  • Make sure every process has at least one input (R) and one output (CUD).

Explore complex chains of calls

Display Call Trees: callers and callees for Functions and events.

Explore all possible execution paths.
Drill down in the code, click on referenced methods or variables to see their definitions.

Call trees help evaluate the effects of modifications to your code.

Document your code

Generate documentation from your code

Create reference manuals in HTML.
Update your documentation on a regular basis (scheduled job).
Document the references in your code and navigate between these using hyperlinks.
Share knowledge with teammates.

View a Sample Doc

Compare versions of your code

Compare 2 versions of your application:

  • View differences in a container hierarchy.
  • Drill down to find relevant changes.
  • Filter changes for a given object, or object type: Userobject, Table, Procedure...
  • Filter changes in a given PBL.
  • Save “snapshots” of your code on a regular basis, and compare them anytime.
  • And more...

Understand complex code

Explore the application structure. Understand its inner working.

When maintaining complex Applications, you may need to learn more about the code.
In such cases, Visual Expert is the perfect companion for PowerBuilder.

Navigate in your code via hyperlinks: each reference comes with a link to the referenced item.
Tooltips provide useful information about objects, methods and variables.
Explore inheritance dependencies between PB objects.
Lots of advanced feature will screen your code under various angles.

Review and improve your code

Cleanup the code. Streamline maintenance efforts. Avoid unexpected behavior.

  • Identify unused objects and remove some dead code.
  • Find empty methods, temporarily commented or emptied from any source code.
  • Find duplicated objects that PB will ignore.
  • Produce code metrics: How many lines of code, objects, methods, variables…
  • Find oversized scripts and PBLs.
  • Find Scripts without comments.
  • Find Controls without a proper name.
  • Find objects that do not inherit for an ancestor etc.

How does it work?

  1. Code Parsers analyze your code, and store the Analysis in a Repository.
  2. You can then query this repository to learn more about your code
  3. Standalone configurations (Professional Edition) run all components on a single PC.
    Recommended for small/medium volumes of code.
  4. In Client/Server configurations (Team System), Code Analyzers and Repository reside on a server. Developers run a VE client on their PC and access the shared Repository.
  5. Code Analysis and Documentation are automatically generated with Scheduled Jobs.

Visual Expert Professional

When analyzing small volumes of code ortrying Visual Expert, you can run it locally on a developer PC.

Visual Expert Standalone License

Standalone Configuration
The Developer run all Visual Expert components on his PC.

Visual Expert Team System

For large volumes of code, and for sharing analyses between team members, Visual Expert will run on a server.

Visual Expert Team System

Client/Server Configuration
The Server automatically analyses the code on a scheduled basis.
Developers run a Visual Expert client, query the Server and leverage up-to-date code analyses.

Feedback from our clients