Visual Expert Update List

Visual Expert 2018 R2

Coming soon:

  • Treeview: Identify DB code with slow performances (Queries, stored procedures, functions, etc).
  • Code Review: new template grouping code review features in a dedicated documentation (only available in the treeview within previous versions).
  • Editing DB code: a new feature will allow to open a procedure or function from the VE UI, edit it in a separate view and save back it in the database.

Visual Expert 2018 R1

Support for Team Foundation Server (TFS)

Visual Expert for SQL Server (GA)

Visual Expert 2017 introduced a beta version of our SQL Server Code analyzers (see this post). The official version (GA) is now available with Visual Expert 2018.

Other features

  • Treeview: Compare references to an object, between 2 versions of your code

From the lab...

We are currently working on a .NET code analyzer. It will reverse engineer and analyze .NET assemblies, and provide .NET developers with similar features than for other languages.

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...

CRUD Matrix

Shows which program is accessing which data, and how (Create/Read/update/delete)
This feature scans all your Datawindows, PowerScript, Stored Procedures, views, etc.
Read more

New Code Analyzer for SQL Server (BETA VERSION)

Other features

 

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

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