Visual Expert Update List

Introducing Code Comparison

  • Save “snapshots” of your code on a regular basis, and compare them anytime.
  • Run Comparison across both PowerBuilder and Database Code
  • Explore differences in a container hierarchy. Drill down to find relevant changes.
  • Filter changes for a given PBL, object, object type.
  • And more...

    Code Comparison

CRUD Matrix

CRUD Matrix shows which process or component is accessing your data.
This feature scans all your Datawindows, PowerScript, Stored Procedures, views, etc.

CRUD Matrix
Read more

 

New Code Analyzer for SQL Server

  • Analyze T-SQL Code and SQL Server Schema: procedures, triggers, tables, views...
  • Combine SQL Server and PB code Analysis to cover the entire application.
  • Review and maintain dependencies between Client and Server Code.
  • Navigate seamlessly between each language,
    for instance when a PB Script is referencing a SQL Server Procedure
New Parser for SQL Server

Other features

Ribbon Menu
  • Renovated Interface with Ribbon Menu and additional features
  • New version of the Oracle and PL/SQL Code Analyzer
  • New Doc Generator, supporting much larger sets of code.
  • New feature to generate partial documentation, for instance on a given PBL, or a selection of objects.
  • New Database section in the PB documentation, listing tables, columns and procedures used by the PB code,
  • New macros for improving performances. For instance for detecting missing indexes degrading response times.

 

New Features Visual Expert for Oracle

  • Treeview: SQL Performances - Columns with missing Index
  • Treeview: Code Review - Calculating the number of Lines of PL/SQL Code
  • Treeview: Code Review - Counting PL/SQL Items by type
  • Treeview: SQL Performances - Tables with missing Primary Key
  • Treeview: SQL Performances - Unused Indexes
  • Treeview: Code Review - Find Uncommented PL/SQL scripts
  • Treeview: Code Review - Large PL/SQL scripts
  • Treeview: Code Review - Find empty PL/SQL functions/procedures
  • Treeview: Code Review - Find duplicated functions/procedures

New Features Visual Expert for PowerBuilder

Improvements

  • Treeview feature/PB: Finding "Unused" items now extended to PBL Root and PB Application level
  • Treeview feature/PB: "Overrides" (methods replacing ancestor scripts) now extended to PBLs and Application level
  • Impact Analysis now indicates the type of access to tables & columns (Select/Insert/Update/Delete)
  • VE GUI: New indicator on tables & columns (red spot) when their declaration is included in the project
  • VE GUI: Selecting a table or column in the treeview now highlights their declaration in the code

Upcoming Features

  • Document Generation: New Template added - Code Review for PowerBuilder
  • Document Generation: New "Database" Section with Tables, Columns, Views and Synonyms

 

New Features

  • Treeview feature/PB: List Computed Fields of selected Datawindows
  • Treeview feature/PB: PBL level dependencies (External References / PBL dependencies)
  • Treeview feature/PB: Large PBLs (Code Review)
  • Treeview feature/PB: Find all the Dll functions declared in a PowerBuilder application
  • Source Code Documentation: Home page, objects lists, new sections and hyperlinks added
  • VE GUI: Macro parameters can be saved and applied automatically next time
  • VE Project management: Review the history of code analyses
  • VE Project management: Delete past code analyses to free up disk space
  • VE Project management: Access Control features, secure VE projects shared between teammates
  • New Macros: Empty Methods
  • New Macros: Object Metrics
  • New Macros: Functions Metrics Summary
  • New Macros: Retrieve SQL
  • New Macro - DW Exploration - Retrieve Arguments (5.7), Controls containing (5.7) Compute Fields

Improvements