Introducing ‘Cross References’ Tab in Ribbon Menu

Visual Expert 2020 introduces a new ‘Cross References’ tab on the ribbon menu.
It gives direct access to the features related to finding references and dependencies in your project.

find references and dependencies in your PowerBuilder Oracle SQL Server code

How to make use of the ‘Cross References’ tab?

The Cross References menu consists of four different sections:

  1. Find References
  2. Chains of Calls
  3. External References
  4. High-level Dependencies

Find References

Impact Analysis (Tree):

Available for all types of objects, this feature shows all the references to a given item.
Results are presented in treeview with a container hierarchy.

find references and dependencies in your PowerBuilder Oracle SQL Server code

Impact Analysis (Diagram)

The same concept, but results are now presented in the form of a diagram.

find references and dependencies in your PowerBuilder Oracle SQL Server code

Chains of Calls

Call Graph (Tree)

This macro allows you to visualize a chain of calls, and see objects referencing each other.
Results are presented in the form of a treeview.

find chains of calls in your PowerBuilder Oracle SQL Server code

Call Graph (Diagram):

The same concept, but results are now presented in the form of a diagram.

find chains of calls in your PowerBuilder Oracle SQL Server code

External References

Stored Procedures Called:

This feature is designed for PowerBuilder projects.
It finds all the stored procedures called by PowerBuilder Objects or Libraries.

Find external references in your PowerBuilder code

Web Services Called:

This feature is designed for PowerBuilder projects.
It finds all the Web Services called by PowerBuilder Objects or Libraries.

Find external Web Services references in your PowerBuilder code

By selecting a PB object in the treeview, you can see the exact reference in the PowerBuilder Code.

Display the reference to a web service in your PowerBuilder source code

DLL Functions Called:

This feature is also designed for Powerbuilder projects.
It finds all the dll functions called by PowerBuilder Objects or Libraries.

Find DLL references in the PowerBuilder code

By selecting a PB object in the treeview, you can see the exact reference in the PowerBuilder Code.

Reference to a highlighted DLL in the PowerBuilder source code

High-level Dependencies

CRUD Matrix (table usage):

This feature will document the CRUD operations performed in your code.
It shows the dependencies between code (objects, functions, procedures, etc.) and data (tables, synonyms, and views).
Anytime an object is referencing a data, it also explains the type of access (Create, Read, Update, Delete).

Generating a CRUD matrix with Visual Expert for PowerBuilder Oracle SQL Server code

Select the tables, procedures, functions, etc. for which you want to generate the CRUD matrix.
Visual Expert generates an Excel file containing the CRUD matrix showing how programs access tables for the elements selected in the treeview.

CRUD matrix generated with Visual Expert for PowerBuilder, Oracle and SQL Server code

For more details about the CRUD Matrix, you can refer to this tutorial.

Object Dependency Matrix:

This upcoming feature of Visual Expert 2020 is expected this summer.
It will help visualize the dependencies between objects in the form of a matrix.

Dependencies between PBLs:

This feature is designed for Powerbuilder projects. It shows the dependencies between 2 PBLS (i.e. when an object of PBL1 is calling an object from PBL2).  

You can customize the result by specifying the number of hierarchy levels. 
The following screenshot shows an example of a result displaying a 5-level hierarchy.

Dependencies between PBLs

For more details, you can refer to this tutorial.

 

Visual Expert 2020, PowerBuilder, Oracle, SQL Server