Filter Calls to Tables/Columns by SQL Type

While parsing your code, Visual Expert analyzes all accesses to tables and columns and categorizes them by type.

As a result, you can isolate the components updating a specific column, deleting from a table, etc.

The example below shows an event updating the database column "counter.cpt":

As usual, selecting the event shows its source code and highlights the reference to "counter.cpt":

db column highlighted

 

With Visual Expert, the SQL statement appears in the treeview.
Selecting the SQL in the treeview shows its code, with the references to “counter.cpt”.

 

PowerBuilder, Oracle, SQL Server, Code Exploration