New features

• New PL/SQL Parser architecture
  This new powerful PL/SQL Analyzer (Parser) architecture supports up to 99% of documented SQL and PL/SQL keywords and reserved words.
• New Project Contents Export
  Export and Import a project with its contents (optionally including diagrams and matrices) as a flat zipped file with an ability to send it by email for simplified sharing of multi-file projects between users.
• New Project Diagram Export
  This new utility exports single or multiple ClearSQL project flowcharts and call tree diagrams into image (GIF, PNG and JPEG), MS Visio Drawing "vdx" and HTML formats with the ability to keep the diagram tree structure in the target Windows folder.
• New Code Editor
  More powerful, faster and more feature rich with an advanced syntax highlighter that provides a wide set of editing, margin, gutter and printing options.
• New Graphic Engine
  This new and significantly improved graphical engine generates Flowchart and Call Tree diagrams and CRUD matrices faster and more accurately.
• New Code Explorer
  An embedded Code Editor feature that displays detailed information about a package's components, such as subroutines, variables and parameters, their types and structure. Code Explorer helps make your work with stored programs more efficient and error-free.
• New Code Folding
  An embedded Code Editor feature that selectively collapses (hides) and expands (shows) sections of SQL and Pl/SQL code to make it easier to navigate and read. Handle large areas of complex code within one editor, while viewing only the desired sections of code during a particular editing session.
• New Code Insight
  An embedded Code Editor feature that displays a list of matching symbols (variables, parameters, procedures, types, etc.) in the current scope when you start typing in an identifier in the Code Editor.
• New Toolbar Customizer
  Easily customize the visibility and position of toolbar buttons of any toolbar by using the Toolbar Customizer.

Other significant enhancements and improvements:

• Export PL/SQL code flowcharts and call tree diagrams into MS Visio Drawing "vdx" file format (Visio XML Drawing). Exported flowcharts and diagrams can be displayed or edited in MS Visio or displayed in MS Visio viewers supporting the "vdx" file format.
• New "Statistics" tab of the "Project Tree" shows the previous project analysis information and opens an HTML report of all analysis performed on the project.
• Generates CRUD matrices and Call Tree diagrams for anonymous blocks.
• Support for SQL*Plus substitution variables. The application scans code on code analysis and replaces substituted variables by values defined on the "Subst Variables" tab.
• New connection setting «DB type» helps users organize their DB connections in groups; e.g. DEVELOPMENT, PRODUCTION, TEST and others. Assigns background and foreground colors to easily identify them. e.g. a mission critical database.
• New setting in Preferences to select a SQL*Plus executable file with an ability to define the startup command file and its parameters.
• New options in Preferences to define fonts for diagram/matrix headers and legends.
• Code Versioning stores and displays the ClearSQL version used for analysis of a certain version of code in the Versions tab.
• Logs on to a database by using LDAP and Direct type connections.
• Ability to rename open projects.
• Added an ability to change the External browser to view diagrams and reports.
• "Run selected text as command file" feature added to the Editor
• "Emit SHOW ERRORS command" feature works directly without using the Clipboard contents.
• Attaches copies of Code Analyzer Options settings and EurekaLog (exception and memory leak report) files to an OSD (Online Support Desk) message.
• Displays the Password Change dialog on password change errors (ORA-28001, ORA-28002).
• OCI reloads only when the new session logs on to the database under a new Oracle Home.
• Added a popup menu for the Editor's gutter.
• Collapse All/Expand All features added to the Editor's popup menu.
• A number of GUI and PL/SQL Parser bug fixes.

• New Project Wizard - creates a new ClearSQL project and imports files/scripts or database objects stored in an Oracle database.
• Analyzer Progress – controls the process flow of project analysis; specifies the analysis settings and displays detailed information about script parser status such as: OK, Error, Skipped; and script attributes such as: Autofix, Code Review, CRUD1 matrix, Flowchart and Call Tree diagrams and analysis and matrix/diagram generation flow statistics.
• Project Report Assistant - generates a detailed, easy to navigate and flexible to configure HTML report for a ClearSQL project including parser status, analysis information, flowchart and call tree diagrams, CRUD1 and CRUD2 matrices.
• Import Wizard – imports files from the file system and/or Oracle database stored objects as project scripts into a ClearSQL project.
• Export Wizard – exports project scripts with a variety options into the file system as files.
• CRUD matrices - a CRUD (Create, Read, Update, Delete) matrix is the perfect aid to analyze the consistency of functional requirements and to identify performance problems. CRUD incorporates two matrix types: "Script Level" CRUD1 type matrix and "Project Level" CRUD2 type matrix to illustrate the relationships between processes and the data they use. Both CRUD matrix types are fully clickable.

  Remark: "clickable" = loads the source code and highlights the relevant line of code

• Project Tree Manager - filters and sorts the project scripts by a variety of predefined filters and sorting rules; also displays script properties and legend.
• New Parser Statuses
  • "New" status indicates that the script has not been analyzed yet, no analysis information available;
  • "Skipped" status indicates that the script contains non supported code/content and was skipped
    by the parser;
  • "Modified" status indicates that the script was modified and not re-analyzed. The previously generated analysis information is available to view but may be inconsistent.
• Autofix Manager – detects, displays and applies autofixes - best practice recommendations that can be automatically fixed to improve code readability.
• Welcome window – provides easy ways to: open a recent project or a project from file system; create a new project; and display the license owner and brief product information.
• Import/Convert Projects – converts and imports ClearSQL 4.3 and older projects to a new powerful and more rapid access ClearSQL 5.0 project format.
• Parser Status – in the Project Tree, represents a colored status, as colored circles, of the script and its attributes such as: Autofix, Code Review, CRUD1 matrix, Flowchart and Call Tree diagrams. Additionally, its tooltip window explains the script status and attributes in detail.
• Online Support Desk (=OSD) – communicates with Conquest Software Solutions Technical Support and keeps ClearSQL up-to-date with its auto-update feature.
• Database Connection window - provides easier connection to a database- displays a connection history list and connection settings.
• Close Project - closes the active project.
• Remove Project from recent - removes the active project from the recent project list.

• Dramatically improved Parser/Analyzer performance.
• New Flowchart and Call Tree diagrams creation, validation and handling.
• New fast way to filter the Project Tree by its attributes from the Code Audit, CRUD, Flowchart, and Call Tree tabs.
• New Project Tree selects the scripts in the Windows Explorer manner, saves and loads ClearSQL projects significantly more quickly.
• Improved performance of analysis information display on script selection.
• New graphical user interface and features of script versioning.
• Improved "Find in Project" feature. The project search result is shown in a new "Search" tab in the Analyzer View pane on search completion.
• The "Search/Error List" tab was renamed to "Errors" and displays the Parser errors only.
• Improved Instrumented Code graphical user interface and features. The gathered information is permanently stored in the project.
• Improved handling of pre-processed code. Added new settings for Pre-processor.
• Flowchart and Call Tree objects are displayed in a hierarchical tree. Clicking on an object in the tree highlights the corresponding script in the Project Tree.
• Improved the "Structure View" and "Code Review" trees and their handling.
• General improvements to the application graphical user interface, usability, stability and reliability.
• Invalid subprograms are displayed in red in the Flowchart/Call Tree tree.
• Invalid diagrams/matrices are displayed with a red border.
• Display’s diagram's tab captions in red if the script has at least one invalid diagram/matrix.
• Displays referenced objects of the object in the Call Tree tree.
• Displays an empty page in the CRUD/Flowchart/Call Tree window when no matrix/diagram is available.
•  "Maximize View" mode now works on the application level.
• Improved "Code Analyzer Options" graphical user interface. Added new settings for diagrams and matrices.
• Improved the Recent project drop-down graphical user interface.
• Parser/Analyzer skips scripts with status "Skipped" and "Error".
• SQL*Plus automatically connects on start up when the application is connected to a database.
• The "Environment Options" menu option was renamed to "Preferences" and "Analyzer Options" to "Code Analyzer Options".
• New graphical user interface of all application toolbars.
• The "File" main menu item was renamed to "Project".
• The vertical and horizontal Script Editor's toolbars were combined into a horizontal one.
• The "Analyze Code" and "Analyze Project" features were combined into a new more flexible and powerful "Analyze Selection" feature. Removed the odd feature "Manual Analyze".
• Removed odd features to delete diagrams.

• Multiple users can use the program on the same PC.
• Non-admin users can use their own copy of the DEMO Project.
• Synchronization of flowcharts with the Project Tree.
• New button on the toolbar to switch between the "Show Selected object's Flowcharts" and "All Flowcharts" modes.
• When a FAILED item is selected in the Project Tree all the Analyzer View tabs are disabled.
• When an error occurs in analysis cycle (FAILED item status) the Error tab is shown by default, and
  other results (OK, NO INFO) don't switch the selected tab. The same action occurs when walking the Project Tree and the "Auto show results" setting is on.
• Metrics export file saves to "...\Application Data\ClearSQL\Export".
• Export control file moved to "...\Application Data\ClearSQL".
• Support for DAY, MONTH, JAVA, BOTH, EXTRACT, "AUTHID CURRENT_USER" keywords.
• Support for CONTINUE statement (ORACLE 11g PL/SQL syntax).
• Project Analyzer performance improved.
• Project Analyzer writes detailed information to a log file.
• Project Analyzer shows the project analyzing process in the Progress dialog that displays the name of the script that is being analyzed, as well as real-time numbers of total, already finished and remaining scripts (files).
• Token comparison feature improved.
• Parser improvement: USE keyword.
• Parser improvement: Empty list of parameters is allowed in a subroutine invocation, for example aName.tostring();
• Parser improvement: HOUR, CONTINUE and COLLECT keywords.
• Parser improvement: ORDER BY in UNION ALL clause.
• Parser improvement: EXIT, REF and DATABASE keywords.
• Parser improvement: EXTRACT() function in the PL/SQL part of the grammar.
• Parser improvement: CASE in ORDER BY clause.
• General improvement: subroutines and anonymous blocks can be in one "file" (code chunk), in any order, and thus can be parsed in one pass.
• Parser improvement: DAY and MONTH keywords.
• Parser improvement: JAVA and BOTH keywords.
• Parser improvement: ROWTYPE keyword.

• Manual analysis did not store metrics in the internal db.
• Fast multiple clicks in the Project Tree might not refresh data in the Analyzer View tabs.
• When the "Make Flowcharts" option was unchecked, the "UML Activity Diagram" option was grayed out and unchecked as well.
• Parser failed on "COUNT(*)" expression in CASE statement.
• Parser failed on CASE expression in ORDER BY clause.
• Fast items selection in the Project Tree caused the CPU to slow down.
• The root check box of the Project Tree in the Bulk Export Wizard was not processed.
• GIF is set as a default option for output graphic files (flowchart diagramming).
• Flowchart diagramming encountered an internal error when there were more than 60 items in a cluster.
• Empty list of parameters was not acceptable.
• xxx.ROWTYPE was not acceptable.
• $$$newtoken error is fixed.
• Proper formatting of VARCHAR2 is restored.

• SQL*Plus built-in commands are available in code chunks.
  Some kind of stand-alone SQL statements are recognized by ClearSQL, and thus can be
  considered as a statement list. SQL*Plus built-in commands can appear BEFORE and AFTER
  this list only, not between its items (i.e. between separate SQL statements).
  The same is true for a PL/SQL code chunk.
  Please note that SET TRANSACTION statement can't be the first statement in a SQL statement
  list. In this case it will be considered as an SQL*Plus command and will produce an error while
  parsing stage.
  SQL*Plus command is available after a code chunk if and only if there is a trailing
  slash (/) after PL/SQL code.

• Setup program will install the "clearsql.ini" option file into
  "<drive>:\Documents and Settings\<OS_user_name>\Application Data\ClearSQL".
• Parser improvements: analytic functions in CASE statement.
• Parser improvements: CALL, EACH, INTERVAL, KEEP, MAP, PIPE keywords.
• Parser improvements: EXTRACT function.
• Parser improvements: support of REFERENCE keyword in full-qualified names.
• Code Editor: Line numbers added.
• On the very first start the following options are set as:
  - built-in preprocessor - OFF
  - flowchart code - SHORTENED mode
  - flowchart output - PNG
  
• "Delete selection..." menu item was added into the flowchart list's Popup menu.

• Formatting procedure puts extra commas when formatting INSERT statement
  with leading commas in lists. Fixed.
• Editor control fails while highlighting a line longer than 1024 chars. Fixed.
• Formatting error for nested collection items access, for example
  a := Collection1(idx1).item(idx2).item2(idx3).item3; Fixed.
• An error in the code review rule (Mode of parameter is not specified
  with IN parameter), when it was being invoked for PROCEDUREs. Fixed.
• Auto correction feature for the review rule (Mode of parameter is not specified with IN parameter)
  was cancelled as an error-prone procedure while comments handling.
• Access Violation on shutdown procedure. Fixed.
• Numbers in .123 format gave syntax errors. Fixed.
• Macro substitution char ( & ) inside comments are still considered by parser. Fixed.
• Single file (Manual) analysis erases the flowchart folder before its run, but it must not. Fixed.
• Main code chunk is saved succesfully but version files are not while "Save Project As..."
  command. Fixed.
• Project Tree is not invalidated after deleting the last version of the code chunk (for multi-versions
  code items only). Fixed.
• After deleting the last flowchart file from the list the built-in browser still shows its picture. Fixed.

• Bulk export any selection of scripts back to the file system;
• Bulk import multiple files into an existing project;
• Bulk import database objects (functions, procedures, packages etc.) into an existing project directly from a database;
• Multiple ORACLE_HOMEs are supported. The SQL*Plus utility can be invoked from a BIN directory of the ORACLE_HOME of your choice. Default ORACLE_HOME is also supported.

• "Auto Show Results" and "Save Results" check boxes are checked by default;

• Bulk export works for directories of the 2nd level and higher;
• Anayzer View shows errors from the previous open project - FIXED;

• Flowchart diagrams can be viewed (popup menu) in external browser (default browser).
• "Auto Show Results" option added. If it is set, stored data will be shown automatically in the Analyser View (upper window) while walking the Project tree. There is a delay which the user can set (Environment Options -> Preferences) to allow a step by step walk through the tree without being interrupted by auto update of the Analyzer View.
• "Save Results" option added. If it is set, results of the manual analysis are stored in an internal database and if "Auto Show Results" is on, the last analysis results are shown when project is opened again.
• Drop - down list of previously opened projects added.
• Error messages are stored in an internal database and can be retrieved later.
• Colored status labels keep track of Analysis results (Project tree). The status of the last analyzed items are in color, any previous ones are in grey.
• "Show Legend" option in Call Tree Diagram is enabled.
• "Strip Out Comments" option added.

• CANCEL button was added to cancel application's closing.
• GOTO BOOKMARK and CLEAR BOOKMARKS popup menu items are disabled if there are no bookmarks set.
• Error list in Analyzer View, may be shown in a dialog box (popup menu item) instead of being shown with a hint.
• New icon set through application (main form, Analyzer Option dialog).
• Status bars added to Flowchart diagrams view and Call Tree diagrams view.
• Each project has a directory (folder) set of its own.
• Extended description added to Checker dialog.
• Button shape can be flat or regular.
• "Rationale" dialog: non-standard button (on left) removed and the standard "Close" button added.
• Project analysis can be cancelled by user by pushing the ESCAPE button.
• A Project tree node always keeps its selection state.
• Build - in registration procedure via GUI (Main menu -> Help -> Register . . . ) removed from application.
• Popup menus in both browsers are the same.
• Registration key as a licence file is accepted. Place registration key (licence file) in the same directory where ClearSQL resides.
  (for example C:\Program Files\ClearSQL\bin).
• Call tree diagrams (* . html, * . gif) are stored in a separate directory.
  C:\Documents and Settings\<user_name>\Application Data\ClearSQL\<project name>\calltree.

• If large display font (120 dpi) is set (under Windows XP), exiting application caused Access Violation error.
• Syntax check: TRIM function accepts additional parameters.
• Bug in the comments joining procedure.
• Run - time error (memory leak) occurs when Manual analysis is invoked immediately after Project Analysis.
• Project Tree width problem: two columns of header are shown in full.
• Print preview dialog: Button caption is changed to "Fit to page".
• New panels and splitter added to Call Tree Tab view to adjust the width of drop - down lists.
• If ROOT node of Project Tree is selected, "Analyze Project" button is enabled (it was disabled if no code node was selected).
• Clicking on the free space of project tree unselects the previously selected (focused) tree node.
• Buttons on horizontal and vertical toolbars are enabled or disabled according to project tree node type.