SQR Runner 4 Pro - Features and Development Benefits


Please become familiar with the SQR Runner: the following pages, each with a different focus, will give you an overview of the SQR Runner's powerful and time-saving features. The highly-integrated development environment allows for a fast ROI and enables customers to noticably lower SQR development life cycles.

The SQR Runner 4 Pro is the integrated development environment for SQR programs offering an amazing feature set such as flexible SQR and SQL editing, Navigation Pane, SQR and SQL output viewers, an integrated SQR debugger and many more...

Great benefit is the ability to work with different database types, such as Oracle, MS SQL Server, DB2 or even MS Access files or other ODBC-connections within the same application (debugger/SQL functionality).


SQR Debugging within Editor
Since the integrated SQR debugger allows to trace through the code line-by-line, even across included files, it is a must-have tool for both novice and seasoned developers.

The debugger eases the usual SQR development by e.g. identifying problems, maintaining legacy code or just understanding the flow of a program.
SQR debugging
 SQR Debugger:
  • Step-into / Step-over code
  • Breakpoints with support of conditions
  • Watches on variables/expressions
  • Expression Evaluation
  • Variable inspection with mouse
  • debugging across files
Powerful SQR Editor:
  • Editing of multiple files
  • SQR syntax highlighting
  • SQR context sensitive help
  • Remote or local SQR execution(*)
  • column selection mode
  • collapsable text regions


Integrated SQL Editor and Command Console
In addition to powerfull SQR editing also SQL commands can be edited and executed across different database types.
SQL Console example SQL Editor with:
  • support for multiple RDBMS
  • display of multiple result sets
  • transaction support (commit/rollback)
  • editable result sets
  • data import/export wizards


All about Program Structure and Flow
Navigation Pane SQR code can be complex and hard to read. The integrated Navigation Pane assists the developer to find any structural element of SQR and included SQC files, such as procedures, include references, variables and SQL statement calls.

Special Features
Special features, usually not included with competing products, are already included:
  • Multiple Logins
  • FTP integration with SFTP, FTPS and SOCKS4/5 support
  • Remote Server Execution with Telnet and RSH support
  • SQL editor and results area
  • Data Import and Export Wizards
  • Support for different database systems already built-in
  • "Expand SQR" feature to create a single file for a program

(*) local SQR execution requires - except for debugging - an existing SQR reports engine which is not included