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, Code Exploration