Identify the Most Referenced Objects

Visual Expert detects all kinds of dependencies for different objects while analyzing your code.

You can find the total number of dependencies with the macro “Most Referenced Objects”.
It is working with tables, procedures, views, user objects, and synonyms.
For PowerBuilder projects, it is also available for windows, user objects, DataWindows, and menus.

For example, you can find the most frequently referenced tables:
Visual Expert will count the references to each table, whether it’s a query embedded in the code, a view built on top of it, or a trigger. Tables will be sorted by number of dependencies, with most referenced tables coming first.

How does it work?

  • In the treeview, select the root icon for the tables. In the navigation bar, click on "Most Referenced Objects"

    find most referenced objects

  • The number of dependencies will be displayed beside each Table.

    find most referenced objects

  • You can go further and display a detailed list of all references to any table:
    Select a table from the result, and click on “Impact Analysis” in the navigation bar.

    find most referenced objects
    The above example shows that the “DEPARTMENT” table has been referenced 3 times.

  • You can limit the number of tables displayed in the list using the small wrench on the right.

    find most referenced objects
    In this example, Visual Expert will display the top 5 referenced tables.

Another example can show the most frequently PowerBuilder objects:

  • For instance, select the root of the windows and click on “Most Referenced Objects”.
    The result will display a number of dependencies for each window.

    find most referenced objects
  • Select a window and click on “Impact Analysis” to list all dependencies to this window.

    find most referenced objects
    The above example shows that there are 8 references to the window “w_resp_product”.