Martyn's blog for the Revelation Software community, sharing ideas, news, views and more. NOTE – Views and opinions expressed in this blog are personal and do not necessarily represent those of Revelation Software.

Month: September 2011

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:

Case options now work correctly on selects.

Environment ini files have been enhanced to allow for user environments.

Selecting with parentheses in the selection criteria no longer causes the select to cancel.

ARev32 and CTO configuration records have been enhanced to conform to the CFG_XXX format.

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.

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.

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+.

The COLDROPDOWNLIST message now repaints combo controls when they are being set.

EMAIL_FORMAT now allows domains that begin with numbers.

The CREATE_TABLE command will no longer append the user’s name and the ‘@’ sign when created by non-system administrators.

DELETE_TABLE will now remove the bang table from the database.

GET_ENV now returns values above 53.

An issue where any popup would not return any value if the last popup had a system error.

RTI_REMOVE_INDEX has been created to remove all indexes from a table including deleting the bang table and SI.MFS.

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.

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.

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:

The resolution of an issue with Header Fonts in ADDTABLE if COLHDRFONT was not used.

OpenInsight no longer crashes when the user closes the preview prematurely.

Fonts now clear when running an OLIST report or using RUN_REPORT.

COLHDRSUPP is now working correctly.

Fonts are now printing correctly when using the page break option on breaks.

An issue with the radius calculation of the drawcircle command has been resolved.

Resolved an issue when using two clauses in a list statement separated by an OR.

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.

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:

The addition of dropdowns to the Data Type, Key, Not Null, S/M and Just fields.

The Report Builder now launches in an MDI frame and utilises the tab interface.

A dropdown has been provided for S/M Types in calculated columns.

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.

People often ask me about the recommended configuration for OpenInsight running on Citrix systems and Revelation now have a useful configuration recommendation article available from the main Knowledge Base. It is available by clicking here.

For those of you that I have forwarded information to over the last couple of years, here are some additional notes. The general recommendation is still the same but Jared has informed me that you are not prevented from having different versions of the application.

If this is something that you need, then you simply create and use different shares for your application. Let’s say you have a common set of database files in \\server\datafiles\compdata. You could have an OpenInsight application in \\server\oi8\oinsight.exe that attached to \\server\datafiles\compdata. In addition to this application, you could install OpenInsight in another location like \\server\oi9\oinsight.exe – making sure that you have the right number of licenses and don’t simply duplicate the licenses from the first system. As long as the \datafiles, \oi8, and \oi9 paths all had REVPARAM files appropriate for the server machine then both versions should be able to share the same application.

Well the Revelation Conference is approaching very quickly and it’ll only be a few days now before I’m heading off to Vegas to catch up with friends from around the world. With this in mind Mike and I were chatting the other day and he mentioned that Revelation have now sold over 10,000 new OpenInsight seats since the last conference. Given the fact that those are new paid seats and that figure does not include the countless FREE single user runtimes that are deployed around the world every year, this is quite a nice number given the tough times that we are living in.

Well done and thank you to all of our VARs who have made this possible.