OI 9.3 Beta – ARev32


And finally we reach day nine and the last of my postings taking a look at the OpenInsight 9.3 beta release highlights.  Today we will take a look at what the new release has in store for our ARev clients that are making (or planning on making) the move to ARev32.  The readme includes five modifications and they include:

  1. Case options now work correctly on selects.
  2. Environment ini files have been enhanced to allow for user environments.
  3. Selecting with parentheses in the selection criteria no longer causes the select to cancel.
  4. ARev32 and CTO configuration records have been enhanced to conform to the CFG_XXX format.
  5. An additional AREV32/CTO configuration option has been included.  Setting field 6 to “<<NONE>>” will suppress the auto-start of ARev32 in AREV32_xxx_FORM (for graphical debugging.
  6. V23 (AREV32 RUN) has also been updated to save the stack when running in graphical debugging mode.

The 9.3 beta readme includes more details about the above items and the remaining items that I have not noted above.  In addition, it also includes many of the new features, enhancements and fixes throughout the 9.x releases.  Please drop
me a line
if you would like to receive a copy of the full 9.3 beta readme file.

OI 9.3 Beta – Basic +


Just two more postings and we’ll have covered the highlights of the OpenInsight 9.3 beta release.  Today, we will turn our attention to enhancements that have been made to Basic+.

  1. The COLDROPDOWNLIST message now repaints combo controls when they are being set.
  2. EMAIL_FORMAT now allows domains that begin with numbers.
  3. The CREATE_TABLE command will no longer append the user’s name and the ‘@’ sign when created by non-system administrators.
  4. DELETE_TABLE will now remove the bang table from the database.
  5. GET_ENV now returns values above 53.
  6. An issue where any popup would not return any value if the last popup had a system error.
  7. RTI_REMOVE_INDEX has been created to remove all indexes from a table including deleting the bang table and SI.MFS.
  8. New extended math operators have been added.

The 9.3 beta readme includes more details about the above items and the remaining items that I have not noted above.  In addition, it also includes many of the new features, enhancements and fixes throughout the 9.x releases.  Please drop
me a line
if you would like to receive a copy of the full 9.3 beta readme file.

OI 9.3 Beta – IDE


Boy yesterday was busy and for that reason today’s look at the OpenInsight 9.3 beta readme will be a short one.

The IDE has not been forgotten in the new release and it sees three small modifications.  There have been two changes to accommodate O4W and they include a tab for mobile on the O4W Configuration Screen and a new O4W Plugin configuration form has been created to define or modify jQuery plugins that are used by O4W.

In addition, the IDE itself has been enhanced so that tools launched from the new IDE will no longer be owned by the IDE.   This will enable the IDE to be minimised without the tools themselves being minimised.  This also allows for the use of ALT+TAB to navigate through the open windows.

The 9.3 beta readme includes more details about the above items and the remaining items that I have not noted above.  In addition, it also includes many of the new features, enhancements and fixes throughout the 9.x releases.  Please drop me a line if you would like to receive a copy of the full 9.3 beta readme file.

OI 9.3 Beta – Reporting


Another week and another section review of the OpenInsight 9.3 beta readme.  Today, I will continue to look at reporting enhancements within the OpenInsight toolset, starting with OIPI.net/OIPI.  The readme file lists 9 bullets made up of 7 fixes and 2 modifications to OIPI.net and OIPI.  They include:

  1. The resolution of an issue with Header Fonts in ADDTABLE if COLHDRFONT was not used.
  2. OpenInsight no longer crashes when the user closes the preview prematurely.
  3. Fonts now clear when running an OLIST report or using RUN_REPORT.
  4. COLHDRSUPP is now working correctly.
  5. Fonts are now printing correctly when using the page break option on breaks.
  6. An issue with the radius calculation of the drawcircle command has been resolved.
  7. Resolved an issue when using two clauses in a list statement separated by an OR.
  8. Creating a PDF whilst the temp file could not be written to could cause OI to hang.  The routine has been modified so that it will now bypass the pdffile and write an error message in SYSTEMP under the username *oipierr.
  9. OIPI can now print multiple reports in one session.  Please check the readme for more information about the use of the TERM command and the appendon and appenoff options.

As well as OIPI, OpenInsight 9.3 sees a few enhancements to the built in Revelation Reporter.  They include:

  1. The addition of dropdowns to the Data Type, Key, Not Null, S/M and Just fields.
  2. The Report Builder now launches in an MDI frame and utilises the tab interface.
  3. A dropdown has been provided for S/M Types in calculated columns.
  4. An issue when using (WITH statements in the selection criteria has been resolved.

The 9.3 beta readme includes more details about the above items and the remaining items that I have not noted above.  In addition, it also includes many of the new features, enhancements and fixes throughout the 9.x releases.  Please drop me a line if you would like to receive a copy of the full 9.3 beta readme file.

OI 9.3 beta – Banded Report Writer


Well, I reach day 5 in my look at the OpenInsight 9.3 beta readme file and still there are a good number of sections to pick some highlights from.  To finish off this week, I thought that I’d choose another of the modules that people have shown interest in.  Today it is the new Banded Report Writer.

This is an entirely new Banded Report Writer that has been created using an industry standard user interface.  Mike gave me a quick sneak peak at the BRW back in May and it is a wonderful looking tool that (in my opinion) could see you replacing your old reporting tools with this one single tool.  This is a tool that you really need to take a look at in the beta software as there is too much for me to cover in this blog posting.  However, the readme includes four bullets of information to note and I’ll include all of those here:

  1. RTI_BRW_FILTER provided so that system administrators and developers can customize which tables and fields are available for the BRW.
  2. RTI_GenerateBRWReport(reportFile, reportName, outputName, reportType, bUseGUI) stored procedure provided to generate BRW output.
  3. O4W_BRWReport routine provided to generate BRW output from O4W.
  4. OIPI.Net call “LOADREPORT” added to allow for inclusion of BRW output in OIPI (note: only available via SET_PRINTER2 or with VSPRINTER2 specified in configuration file).

The 9.3 beta readme includes more details about the above items and the remaining items that I have not noted above.  In addition, it also includes many of the new features, enhancements and fixes throughout the 9.x releases.  Please drop
me a line
if you would like to receive a copy of the full 9.3 beta readme file.

OI 9.3 Beta – Data Encryption


Moving into day 4 of my look at the contents of the current OpenInsight 9.3 beta readme and today we’ll be looking at one of the big highlights for many of you, especially those of you in the USA – Data Encryption.  The readme lists four items, being:

  1. OI 9.3 includes a module to encrypt your data. The major pieces are an encryption server (rtiDERServer), an encryption client (rtiDERClient) and a BFS (RTP57E).
    Encryption works in conjunction with the Linear Hash filing system.  When you use DER the linear hash service just stores encrypted keys and rows rather than plaintext.  Data Encryption is mostly transparent.  Once you install the server and client, you create an encrypted volume and copy tables to that volume.  Tables and indexes function normally, but if you look at the .LK or .OV files with a text editor you will see encrypted data.
  2. Added new functionality to create “encrypted” volumes.
  3. Updated CREATE_TABLE, COPY_TABLE to support creation and copy of tables in encrypted volumes.
  4. Added CREATE_VOLUME_PASS, ATTACH_TABLE_PASS to create and attach PASS (Password Authenticated Single Session) volumes.

The 9.3 beta readme includes more details about the above items and the remaining items that I have not noted above.  In addition, it also includes many of the new features, enhancements and fixes throughout the 9.x releases.  Please drop
me a line
if you would like to receive a copy of the full 9.3 beta readme file.

OI 9.3 beta – O4W


O4W (OpenInsight for the Web) continues to prove a very popular route to the web for OpenInsight and MultiValue developers.  Even thought the technology has only been available for a short time, there are now a number of O4W solutions in use around the world and more and more people are showing interest as O4W moves into its next release as part of the larger OpenInsight 9.3 release.

This release includes 33 bulleted enhancements, new features and fixes listed in the 9.3 beta readme.  Just a few of their highlights include:

  1. Enhanced Logon.
  2. jQuery Mobile supported.
  3. Updated available jQuery versions.
  4. Module assignments added in all functions.
  5. RDK Definition Builder and Installer added.
  6. Module Builder added.
  7. Additional paginator included.
  8. New O4W_BRWREPORT routine created to generate PDF/HTML/TIFF.TXT to browser from the new OI BRW.
  9. Updated configuration screen with many new choices.
  10. Updated RSS feed routine.
  11. Updated some controls to support some HTML5 options.
  12. Updates to countless routines including O4W_LOGON, O4WCOOKIE, O4WLISTBOX, O4WCODES/ERROR_TRACKING, O4W_EDIT_PROC, O4W_DEFINE_DASHBOARD, O4W_DEFINE_FORM, O4W_DEFINE_MENU, O4W_DEFINE_REPORT, RUN_OECGI_REQUEST, O4WSetCell, O4WForm, O4WDownload, O4WHeader, O4WFooter, O4W_RUN_FORM, O4WUploadBox, etc.

The 9.3 beta readme includes more details about the above items and the remaining items that I have not noted above.  In addition, it also includes many of the new features, enhancements and fixes throughout the 9.x releases.  Please drop me a line if you would like to receive a copy of the full 9.3 beta readme file.