SQR Runner 4 Pro - Version History
The SQR Runner development and support team 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*
Check the SQR Runner website "http://www.sqr-runner.de" often
for new updates.
Please provide questions or feedback to "support at sqr-runner dot de"
and do not hesitate to report any problems!
The SQR Runner website also offers a "Bulletin Board" for feedback,
Tips & Tricks and information exchange.
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.
14-FEB-2006 - 4.3.78:
+ Repository support SQR "repostry.sqr" (for PeopleSoft 7.x/ADP)
enhanced to also export column "XLAT".
* "Collapse all SQLs" (menu "Edit|Collapsable Regions") wasn't hooked up.
- Removed skin support altogether due to incompatibility issues
for the time being.
12-FEB-2006 - 4.3.77:
* Note: we are starting to move GUI settings from the registry settings
into a XML-formatted file which will be stored in the "Application Data"
directory in the "My Documents" folder. This is to minimize the amount
of values in the registry and eventually make settings really "portable"
across machines.
* Debugger: arithmetic functions such as ADD, SUBTRACT, DIVIDE and MULTIPLY
now support signed and fractional values (e.g. -2 or +.33)
* Debugger: a Breakpoint's "Passcount" indicates, how many times the
breakpoint has to be passed before the debugger actually pauses on it.
Formerly this "passcount" was a one-time condition, i.e. once the
debugger interrupted on this breakpoint, the breakpoint became unused.
NOW the PassCount is reset to the specified value automatically.
Example: PassCount = 5 means, the debugger only pauses on the breakpoint
every 6th time it reaches the breakpoint during a debugging session.
NOTE: changing breakpoint conditions is not functional during
debugging as of now!
+ "Repository Support":
+ added "print" button in XLAT dialog (not available for DBFIELD listing).
+ added button for EFFDT Assistant.
+ "BEGIN-SELECT Assistant":
+ added option to automatically use the EFFDT Assistant as well.
+ added option to have subselect's SELECT/FROM parts on the same
line in generated code.
+ Repository menu (blue arrow down button): added item "Import Data
Wizard": this allows to import data of different formats (Text/CSV,
HTML, XLS, DOC, WK1, XML, MDB) into a table!
* Fix in "repfield.sqc" to finally use a schema as specified from
within the main "repstry8.sqr" etc., e.g. "sysadm.".
* "SQL Output": printing of data no longer prints a "filter" section at
bottom of last page; no longer prints filename as report title.
* "Result" tab: error file contents was not cleared if no error file
existed at all.
* "Replace" dialog updated to better work with selected text.
* "Find" dialog stays visible upon "Find next" for both "Result" and
"Editor" tab.
* "Replace" dialog: fixed issues with "Replace All" where nothing
was replaced ("Direction = Backwards" or "Case sensitive").
* "Minimize" of application should work again.
* "Skins" are no longer active as default when installed.
* Updated internal libraries as regular maintenance.
* Updated help files and manual (PDF).
* Smaller cosmetic changes.
16-JAN-2006 - 4.3.74:
* Debugger: fixed rare problem which could cause the application to become
unresponsive by using either the debugger or the Navigation Pane
* Main tab "Result":
+ Line and column numbers are now shown in statusbar
+ Ruler now horizontally scrolls in-sync with editor
* Main tab "SQR Editor":
+ Switching between files now remembers the 1st left editor column, too
(not between sessions, though)
+ Ruler now horizontally scrolls in-sync with editor
* Ruler now correctly scales upon startup and font changes
* Connection to MS Access databases with ODBC fixed
* Repository Support - tab "Repository View": click on Fieldname/# switches
sorting between name and field number
* Repository Support - tab "Dataview": sorting/filtering/grouping
enabled for "Fetch ALL rows..." option
* Repository Support - tab "Schema Browser":
+ Popup menu enabled (right-click on colum header)
+ Hints added for operations
* "SQL Output":
+ "Footer" item added: available for active option "Fetch ALL rows..."
to activate aggregate functions on columns (such as sum, count,
min, max, avg; availability depends on column type)
+ Log now also shows version of DB client software (if applicable)
+ Customization button enabled: clicking top-left corner of the grid
(above the left indicator column) produces a popup menu with
currently available column names to easily show/hide columns
* Popup menu revised (column header click)
* If SELECT returns row the "Result" tab is activated
* Fixed connection problem with MS Access (ODBC)
* Disabling "Column Grouping" now restores visibility of formerly
grouped columns
* Options|Editor|Printing: added option "Line Spacing"
* Help updated (mainly section "SQL Output Grid") with further
explanations and new screenshots
12-JAN-2006 - 4.3.73:
* Debugger: fixed function "ROUND", which returned wrong result
for values fractional value of 0 (zero).
* Multiple enhancements to SQL editor's execution of statements:
* SQL/SELECT statements are now threaded which raises the
responsiveness of the application.
* The SQL Result grid now only offers the sorting/filter
buttons in the column captions if option "Fetch ALL rows..."
is active.
* Repository Support:
* "Dataview" is now fetching all rows, unless a SQL console
is visible and has "Fetch # rows..." option active.
* "XLAT" dialog now correctly uses SQLID for DB2.
* "Schema Browser" enhanced (this is a "view only" feature).
* Open "Project" is now being prompted to be saved upon close
of application.
* "Edit Login": upon "OK" the entered repository schema (which
is usually empty, though!) will be automatically transferred
to the "DB-Schema" entry box in the Repository Support to
avoid confusion.
07-JAN-2006 - 4.3.72:
* Repository Support:
* enhanced DB2-repository SQRs to handle SQLID, which is now
passed on by the SQR Runner; improved handling of "schema"
and no longer uses it if not specified ("repdb2.sqr").
* "repdb2.ini" updated to show correct columns.
* Repository data is now only reloaded/created if tab
"Repository View" is active.
* Temporary files for Repository execution are now removed.
+ "Schema" tab added, which allows to retrieve a general
listing of Tables, Indexes, Procs. Upon double-click of
a table it will select/show the tables columns.
-> Not yet documented and just a preliminary feature.
* Option "Minimize on run" was not stored.
06-JAN-2006 - 4.3.71:
+ Logfile ("Result" tab): before loading the log- or LIS-file
the user needs to confirm to load if the filesize is > 1MB
to avoid incidental long loading times for huge log files.
* SQL editor and DB2: the SQLID was not correctly set and caused
error messages upon connection.
* "View Output File" (menu "Edit" and tab "Result"):
* the output directory name is now shown in table title, too.
* set options in the dialog are now better taken into account.
* "Logins" help topic and dialog updated to reflect recent
DB2 enhancements.
* Manual updated.
05-JAN-2006 - 4.3.70:
* SQL editor: changed SQL connection processing in order to
work better with DB2 and SQLBase.
* FTP client with MVS hosts:
* trailing dot in the directory name is being removed
* remote directory names may be enclosed by single quotes
(also host configuration: on tab "Action")
* FTP maintenance: copying a FTP host did not refresh the
host list upon "OK".
* Improved memory manager and updates to internal libraries.
* Help topic "Logins" updated.
02-JAN-2006 - 4.3.69: Happy new year! :-)
+ Tab "Options"->"Editor": added Printout setting for automatic
setting of header and footer details, such as filename, path,
page numbering and timestamp.
If unchecked, these settings may be overwritten anytime in the
"Print Page Setup" dialog (menu "File").
+ Repository Support for DB2 enhanced:
+ for DB2 on z/OS: new SQR "repdb2zos.sqr" allows DB-level
table structure retrieval.
+ for PeopleSoft/ADP on DB2: use "rep8db2.sqr" should be used!
This SQR will use the Logins' "Params" entry as SQLID to
be able to select the tables.
* Repository Support for PeopleSoft/ADP table repository: SQR
itself ran into problems on MS SQL Server (fixed inside
delivered "repfield.sqc").
* Repository Support and DB2: "XLAT" dialog enhanced to also use
a given SQLID (entry "Params" in Login) to be first used before
selecting data.
* "CTRL+ALT+R": display of table-/record names now also works
on dual-monitor environments. This hotkey provides in SQL
editor a popup-list of all record (=table) names of the DB;
in SQR editor mode with active Navigation Pane contents it
displays a popup-list with all found recordnames.
* We hope to have found a 99% cure for the focusing problem
when switching to other applications and the SQR Runner
remained visible, i.e. in less seldom cases this may still
occur, but not as frequently as till the latest release.
* Some GUI and internal changes/corrections.
* Updates to internal libraries.
