>Commuter Routine Generator

>Did you know that you can use the WebOI Commuter Routine Generator to create commuter routines for any OpenInsight window that is currently based on Quick Events and Scripts. The use of commuter routines is widely considered to be best practice and that leads to an easier to maintain, faster to operate and more organised application. At the present time the routine can be executed from the WebOI utility in the new IDE or from the System Monitor.

The commuter routine generator includes an option to create ‘case statement stubs’ in the commuter routine for all controls and supported events on the form. You would usually only select those that you want to include, but there might be times when you would want them all. When checking the box, OpenInsight (from version 9.0.1) will not only double check that you really want to create the empty case statement stubs along with your define stubs, but it will also notify you of how many stubs will be created so that you can make a more informed decision.



I am still running into developers reporting issues with OpenInsight being left running in the task manager when OpenInsight is closed. This is mostly on Vista machines, but I thought it worthwhile to include another posting here dedicated to this issue. It will not be any surprise to you that this results in some undesirable behaviour. Revelation therefore jumped on this issue very quickly and the latest RCL4.dll file resolves that issue.

>Server failure at our ISP

>I am aware of issues associated with several pages on the www.revsoft.co.uk and www.sprezzatura.com web sites, most noticeably with the submission of the forms, etc. This issue has come about following a server failure at our ISP and what I believe to be a less than complete restore of the sites to the new server. This issue has also left me with the inability to post changes and notifications about the issue to the sites themselves.

I apologise for any inconvenience that this might cause and I will be grateful if you could send an email to info@revsoft.co.uk or info@sprezzatura.com should you require an assistance.

>OpenInsight running on 64-bit Servers

>Did you know that there is no need to wait for 64-bit OpenInsight to begin taking advantage of deploying to 64-bit servers, such as Windows 2008? Whilst not officially supported as formal testing continues, there are already several OpenInsight systems running on 64-bit servers.

Following a support thread with one client recently, I thought that it might be useful to post some useful information on the topic, even though this is in the WORKS forum on the main Revelation web site.

There are primarily two main points to note:

  1. To run OpenInsight you will need to ensure that you include the OpenInsight registry settings in the 32-bit virtual (WOW64) registry.
  2. If you are planning on using OpenInsight’s OEngineServer service (SocketServer, OECGI2), then you must ensure that you install 32-bit Java for OpenInsight to use and not the 64-bit version, otherwise the SocketServer will fail. In the recent case, this meant downgrading Java from version 6 (64-bit) to version 5 (32-bit).

Once correctly configured, OpenInsight (both desktop and web) should run without any problems. However, it is highly advisable to ensure that you are using the Universal Driver 4.5 (Windows) and a late version 8 or 9.x of OpenInsight.

In addition, there is a useful MSDN article entitled 32-bit and 64-bit Application Data in the Registry that you should refer to, as well as searching for ‘32-bit applications 64-bit server’ in the Microsoft resource and please don’t forget to search the Revelation WORKS forum for real world help as well.

NOTE: This posting will be updated as more information is made available to me. Please also use the comments facility in this posting to post your hints tips and experiences with configuring OpenInsight on 64-bit machines. Please remember to include your version of OI.

>Drag & Drop – Windows files

>Did you know that by using drag & drop and a simple OLE control, you can easily enable a user to drag any file into your application and then display that file from within your OpenInsight application. Obviously the users machine needs to know how to handle the file (you will need Word installed to display a .doc or .docx file), but you can easily allow users to drag a .pdf, MS Word, Notepad, text file, html page, etc. onto a form and display the content. In addition, application files like MS Excel 2003 spreadsheets can be displayed (with edit capabilities) from within your OpenInsight application.

Images can also be dragged into an OpenInsight application and displayed on a form. In this instance a simple bitmap control and edit line is used. Furthermore, with a few lines of code, you can enable your users to drag the contents of an edit table cell from one cell to another or between two edit tables.

I hope to have some demonstrable examples of these techniques shortly, so please let me know if you would more details and I will be glad to set up a meeting or a WebEx meeting online.

>List Populator in version 9.0.1


Following suggestions from attendees at the recent RUG in London, Mike and his team have included some of the suggestions into the 9.0.1 release and included others for consideration for a future release. Whoever said that it’s not worth the time to attend these meetings 😉

One such suggestion came whilst Mike was showing how a list can be populated with a simple string in the items list, something that I touched on back in our February 2008 newsletter and a white paper on the subject.

There were two suggestions at the RUG. The first was for the items displayed using the technique to be sorted and the second was for items from the database to be displayed and, above those, items that were added by the developer into the controls items on the property window. Furthermore, Mike has included the option to sort the data in various ways, including descending left (DL), descending right (DR), ascending left (AL) and ascending right (AR).

Both of these customer requests should be included in the 9.0.1 release in a few weeks time.

>OpenInsight 9.x Workstation Installation Notes

>To roll out an OpenInsight 9.x application to a workstation requires that several libraries and controls be registered by an administrative user. Some of the components will automatically install upon first use if the local user has workstation administrator access. Since many organizations do not provide users local administrator rights to the workstation some manual configuration is required. Read on.