SQR Runner 4 Pro - Version History

The SQR Runner development and support teams are working hard to offer you the best product for your SQR development. Providing fast and accurate customer support is the foundation for customer satisfaction, which our existing customers have been able to rely on before and after purchase of our product.

Your feedback is important to us and highly appreciated!

Please make us aware of any problem we may have overseen and please provide the following information:

Is the error reproducable and - if applicable - by what means?
Were any error message shown (either as dialog or in the Debugger Windows)?
Which version of the SQR Runner do you use?
Which operating system is being used?

Please find below a list of recent changes and development issues, that have been identified so far since the latest published customer build.

SQR Runner 4 Pro » Build 4.3.86 » Version History

06-JUN-2010:
* Installer allows for Vista, Windows 7, Windows 2008 (x86/x64)
* FTP client (tab "Remote Files"): deleting a remote file caused
  the directory listing to be processed twice
* Debugger fixes:
  * parser errored on empty SELECT lines
  * connection to MS SQL Server 2005/2008 now works correctly
    if in "Login" the "OLEDB" option is activated, too
    (connection worked in SQL console already)
  * fixed error with LET statement and DateAdd function
    with date variables
  * improved support for stored procedures to return values
  * improved processing of date variables
  * improved parsing of nested CASE statements in SQL
* Updated internal SQL library; better support for new
  column types of SQL Server 2008
* Fixed some memory leaks upon close of application.

02-JUN-2009:
* Menu Debug|Debug Options: added new option for "Command Timeout"
* Fixed interim issue with "Procs" -> Right-Click -> Load SQL commands...
* Internal libraries and FTP client library updated

19-JAN-2009:
* New sub-menu Edit|Code Repository to collect procedures across all
  found SQC (include) files per Login.
* New editor feature: keeping CTRL pressed and moving the mouse over
  a procedure name, it will underline it IF it was found in the local
  file or in the Code Repository.
  Clicking then the name will jump to the declaration of the procedure.
* Editor: pressing "F2" with cursor on a procedure name also jumps to
  the file/line of the procedure declaration if found.
* Editor popup menu (right-click): added "Find Declaration" if cursor
  is on a procedure name (after "do" command).

09-JAN-2009:
* Debugger: bugfixes to ALTER-LOCALE implementation to e.g. correctly
  switch numeric separators
* Navigation Pane: the "Includes" page did not always list all files
* Updates to internal libraries

21-DEC-2008:
* Debugger: minor enhancements to match numeric variable output
  to original SQR engine output
* Debugger: PRINT statement now allows (0,xx) position (+0 worked before)
* Updates to internal libraries

13-OCT-2008:
* Debugger: removed check for declare-layout which errored

26-AUG-2008
* Debugger: support for CLOB fields in Oracle
* Allow database name start with numerics in "Login"

24-JUL-2008:
* Debugger fix for "MOVE" command failure
* Updates to internal libraries

17-NOV-2007:
+ Debugger: "Evaluate Expression" and "Watches" now support evaluation
  of SQR array variables by just entering either the array name or
  a specific array index, e.g. "months" or "months(1)"
* Debugger "Watches":
  * watches list has been enhanced to support display of array's
    multi-line values; also allows selection/copy of array values
    to the clipboard
  * watches' "Enabled" status is now remembered between sessions
  * now stores up to 50 watches (previously 30) between sessions
* "Split View" (menu "View"): "Update" button was positioned incorrectly
+ "Repository Support": added "Repository Fields" dialog to "Tools"
  sub-menu for browsing PeopleSoft "DBFIELDS" and "RECFIELDS" tables
* "Repository Support": record info loading now happens when switching
  from/to the "Repository View" and not with the "Dataview" anymore
* "SQL Results": improved "Best fit" column sizing to use the first 20
  row's columns to calculate widths
* visual enhancements to better support switching layout to Office style

27-OCT-2007:
* Fixed: "Find" dialog: "Uncomment" action did not work
* "Format|Uncomment" improved (keeping leading spaces in front of comment)
* Debugger: added preliminary support for PL/SQL commands in BEGIN-SELECT
* SQL error messages are displayed with line feeds if present
* updates to internal SQL libraries

13-SEP-2007:
* Fixed: application no longer stays in foreground when switching
  to other applications; also the "Help" window is accessible again
* Debugger:
  * fixed to accept FOREGROUND and BACKGROUND parameters
    for PRINT command
  * CREATE-ARRAY command now accepts "extent" parameter
  * array operations now allow signed values/variables (plus/minus)
* Several other bugfixes and library updates

17-MAR-2006:
* Debugger: fixed an introduced problem with SELECT's field list
  where multiple fields were comma-separated on a single line
  ("Index out of bounds" error message).
+ "Save As" dialog: confirmation prompt now shows the existing files'
  filesize, timestamp and attributes.
* "Login" dialog: defaults again to show "Novice Tab".
* Hints were not displayed correctly (globally).

12-MAR-2006:
+ Extensive enhancements to SQL editor: multiple result sets,
  editable result sets, cancellable queries and much more!
+ Debugger fixes.
+ Application enhancements.
+ Updated help files and manual.
The full changelog, which is quite long, can be found in the
extra file "news4.3.80.txt" in the installation directory.

19-FEB-2006 - 4.3.79:
+ Debugger: extensive revision of number formatting with masks to
  much closer resemble core SQR engine output.
+ Debugger windows:
  + "Debugger Messages" window now also copies selected line to the
    clipboard (hotkey CTRL+C) if it is not an error message.
  + "Display Messages" window now supports regular "Copy to Clipboard"
    hotkey CTRL+C.
+ Editor with "Block Selection" mode active: selecting a 0-width column
  and typing will insert the pressed keys in all rows at the same column.
+ "SQL Output": if "Fetch ALL rows" is active, the selected rowcount
  is being displayed above the result grid, which was already displayed
  in the SQL "Log" tab.
* Fixed: in file read-only mode some keys still allowed to change
  editor contents.
* Fixed: restored the default icon for the "Save As" toolbar button
  as it was changed incorrectly in a previous release.
+ "Create .BAT" (main tab "SQR Logins & Params") now prompts to open
  the generated file in the editor (if it exists).
* Command line generation to "Execute" a SQR or "Create .BAT" file no
  longer tries to automatically include a -ZIF parameter from the
  PeopleSoft registry configuration if no "SQR initialization file" was
  specified in the Login settings.
  However, it does use an existing "sqr.ini" file from either the
  WINDOWS or the SQR-engine directory, since this is the SQR standard
  behavior. That is: SQR engine automatically searches for a "sqr.ini"
  file in above mentioned directories if none was explicitely specified
  on the command line.