VE 2023 Code Inspection - Improved Rules

Visual Expert 2023 comes with new and improved code insepction rules to generate a more productive code review report. The updated rules are as follows:

Oracle - Maintainability - Magic numbers should not be used

  • Ignore the numbers mentioned in create table statements.
  • Ignore the numbers mentioned in create table statements.

PowerBuilder - Vulnerability - IP addresses should not be Hard-coded

  • Excluded default IP ( :: ) while checking for Hard-coded IP addresses.
  • Consider IP addresses with valid alphanumeric characters.

PowerBuilder - Maintainability - String literals should not be duplicated

  • Exclude quoted texts containing operators like '+','-','*','/','<','>','='

SQL Server - Maintainability - Methods must not be empty

  • Exclude sequences and types from this verification

SQL Server - Maintainability - String literals should not be duplicated

  • Added a parameter to ignore datetime format string.
  • Added a parameter for max Nb of occurrences: duplicate strings exceeding this value are considered non-compliant.
  • Added a parameter to ignore certain code containers based on their name - example : if the procedure name starts with “init”, then it should be ignored during this verification.

SQL Server - Maintainability - Track lack of SQL Server session configuration

  • Ignore “SET NOCOUNT ON;” instructions
  • Added parameters to ignore certain procedures or triggers based on their names - example : if the procedure name starts with “P_Startup”, it should be ignored during this verification.
Visual Expert 2023, PowerBuilder, Oracle, SQL Server, Code Inspection Rules