Thursday, 16 September 2010

Wednesday, 15 September 2010

9.2.1 - System Editor Enhancements



So the second little 9.2.1 teaser this week is something for our OpenInsight developers and it is again something that several of you have asked for at the recent road shows.

Within the System Editor ++ in 9.2.1, Revelation have added a new tab at the bottom of the window for your favourites. At the moment, OpenInsight maintains a list of the last 20 or so programs that you have opened under the File menu as a recent list. However most developers are opening far more programs than this list handles and very often programs that you want to com back to regularly, can get dropped from the list. The ability to save your favourites in the favourites list addresses this issue.

Better still, you can hit the play button on the favourites tab and OpenInsight will open up each of the programs in the Systems Editor ++ for editing in their own tab.

Another tab, entitled Record Info, displays the dictionary information for any field in an open record. You simply open your chosen record and then select the field in the display. The Record Information tab will then display information such as the Field Number, Column Name, Data Type, Heading, Validation, Conversion, Justification, Length and more.

The third enhancement to the System Editor ++ is with regards to Inserts ($INSERT). Whilst it is best practice to maintain your inserts at the top of your programs, it is not absolutely necessary and some developers like to maintain their Inserts as needed (or first needed) throughout their programs. This can make it hard to find those inserts and they can easily be missed if called earlier and used later, or even reused later.

The System Editor ++ in OpenInsight version 9.2.1 now includes a find facility that can be used to find Inserts throughout your programs. This makes checking if they are already called easy and also locating them in your programs a lot easier, especially in those longer programs.

Monday, 13 September 2010

9.2.1 - QBF enhancement



So it is a new week and, as promised, I have the first of three 9.2.1 golden nuggets to tease you all with. The other two will follow over the next three days, leaving the best to last and something that will have many of you beaming like Cheshire Cats :)

So, during the recent road shows at which Mike has been presenting, many of you have been asking for the ability to load QBF from an external list. So, OpenInsight 9.2.1 now has a new menu item under QBF called (you guessed it) ‘Load from External List’.

Those of you using TCL within OpenInsight will know that we now automatically save your select statements when they are run from TCL. This list can be viewed from within TCL and the statements run time and time again – a nice time saver for frequently run statements. This list of statements can be accessed from QBF in 9.2.1 via the ‘Load from External List’ dialog window by choosing the Query Table option. The required list is then simply picked from the pop-up and the results displayed as a QBF browse list in the normal way.

The second option from the dialog window is to load QBF from a saved list. The save list is created by users within TCL. Basically they enter a select statement and then save the statement within TCL – nothing new there. However, by selecting ‘Saved List’ in the dialog window, the user can now populate the QBF browse list from one of their saved searches.

Friday, 10 September 2010

Printable OpenInsight manuals.



As many of you will know, Revelation maintain a large amount of useful information in the online OpenInsight helps system. This consists of several .chm files that are exposed and fully searchable from within the OpenInsight toolset – an invaluable resource for anyone building systems using OpenInsight. However, owing to the fact that OpenInsight is being continually enhanced and new features added, hard copy manuals (the .chm file content) have not been available for some years.

However, now that we have more and more new (non-Revelation based) developers looking at and using OpenInsight, I believe that the time has come to consider creating one or more .pdf files that consist of the contents of the help system.

One of my first thoughts is to tackle the Programmer Reference Pages in the help system. A mammoth undertaking, but probably one of the more useful and appealing from a developer’s point of view.

As this will be a significant investment of my own time, I will be very grateful if you could comment below on;

  1. The usefulness of one or more .pdf files, in addition to the online help system.
  2. Whether you would prefer one huge .pdf file with all of the various manuals in one volume, or several .pdf files cover each specific topic (Native Tables, Programmers Reference, Guide to Application Development, etc.)
  3. Any other comments.

Please visit my blog if you have received this as an email or an RSS feed notification. Please also forward this email to any of your colleagues that might not frequent my blog, but who might wish to voice their opinion on the usefulness of the manuals in .pdf format. It goes without saying that, owing to the time this will take to create and then maintain, I’ll drop this idea IF there is not sufficient interest and need.

Change the look of your O4W forms & reports.



With the recent release of OpenInsight 9.2, Revelation Software’s new O4W web development tool is finally available for everyone to use. One of the key design goals for O4W is to be flexible and configurable; that’s why it’s built on the widely-supported jQuery open source toolkit. One of jQuery’s features is the ability to quickly change the look of a web page by changing which jQuery user interface “theme” is selected - and O4W developers and users can take advantage of this feature to change the look of their O4W screens in the same way.

You specify which theme you want jQuery (and thus O4W) to use on the O4W Configuration Screen. Bring up the O4W Configuration Screen (either in O4W from the main menu, or from within OpenInsight using the RTI_O4W_CFG form), and on the “scripts” tab press either the “on-line” or “off-line” button to set the default “core script” to the “on-line” version of jQuery hosted by Google’s servers (on the Google Content Delivery Network, or CDN), or the “off-line” copy of jQuery that’s distributed with O4W.

This blog article was taken from the September Rev US newsletter and more details can be found at http://tinyurl.com/2wjfxmk

Thursday, 9 September 2010

Wicked new features for OI 9.2.1



Ten minutes online with Mike and I’m already excited about some of the new features coming in 9.2.1 in a few weeks time. These new features are developments that have come specifically from OpenInsight developers and users who have attended Revelation RoadShows over the last few months, especially the Australasian gigs last week and no doubt more will come following the Houston Roadshow next week.

In addition to the O4W enhancements and new features that Revelation have just announced in their email newsletter and which I’ll be covering in the blog over the next couple of days, Mike has shown me enhancements to the System Editor, QBF and a brand new Version Control Module.

The System Editor enables you to click on a field in a record and see all of the key field information at the bottom of the System Editor’s IDE. Plus, you can now search for $Inserts within programs – extremely useful for those long programs where the inserts are spread throughout the program.

QBF has been enhanced to include TCL statements - remember that TCL now remembers your TCL List statements so that they can easily be run again and again. You can also save the statements and pick them from the recent used list, or your own library of saved statements.

The Version Control Module is just awesome and Revelation have done their homework and built in all of the best bits from version control modules in numerous other products. This includes the ability to create modules (for example an email module that includes windows, programs, etc.), assign versions to those modules and compare source code between programs. The system will colour changes for you for easy identification. Plus, you can select modules in the RDK to make deployment even easier.

These new features were being worked on whilst Mike was showing them to me and for this reason I do not yet have screen shots, nor the ability to put together some teaser videos. However, I will be writing some blog articles over the weekend with a few more details about these new features – so watch for those throughout next week.

Wednesday, 8 September 2010

A quiet blog = a busy Martyn.



Guys, just a quick apology for being so quiet on the Blog recently. However, the reason is purely available time as I’ve been heavily involved with a number of projects. These include:

1) Designing, developing and populating my own OI 9.2 based contact manager – yes, I finally ditched Maximizer (on cost) and then the Outlook plug-in on reliability.

2) Working with a number of people on cross-grade deals from ARev and early OI versions to 9.2 and also helping clients with O4W and the dashboards in O4W.

3) Continuing to evangelise the benefits and virtues of OpenInsight to the less well informed, especially now that we have the connectors.

4) Then talking of the connectors, we’ve begun to see Universe, Unidata, Univision and D3 developers here in Europe begin seriously looking at OpenInsight, building on the growing interest the Rev US have been seeing over the last year or so.

However, watch for more training videos and blog postings coming soon.

Friday, 13 August 2010

O4W Examples Application Online.



Following my recent posting about the OpenInsight 9.2 Evaluation Edition being available, several of you have asked for the O4W Quick Start Guide application to be hosted on the web. This has now been done and you can get to the O4W examples application at http://tinyurl.com/37wvmsv.

The current version includes an example of a Customer Entry Form, an Order Report and a Sales Dashboard. This provides you with the opportunity to view the application before downloading the OpenInsight 9.2 evaluation edition (or upgrade if you are a WORKS subscriber) and running through the O4W Quick Start guide yourself.

Thursday, 12 August 2010

Wednesday, 11 August 2010

3 reasons to take a look at OI 9.2.



As if you needed them, here are just three of the countless reasons why you, as a MultiValue developer, should be looking at OpenInsight 9.2. Using one fully integrated toolset, OpenInsight 9.2 now enables you to:

  1. Very quickly and easily extend the life of your leading MultiValue applications for LAN, WAN and the Web deployments. Creating a web interface for your application can be done in just a few minutes using OpenInsight 9.2’s O4W.

  2. Interact with the entire Windows world in the easiest ways possible. This includes consuming .NET controls, ActiveX controls, Widgets, API’s, Windows hardware, third party applications and more.

  3. Seamlessly support multiple databases from within your application using OpenInsight 9.2’s data connectors. Currently supported databases include OpenInsight’s linear Hash, Rocket Software’s Universe and Unidata (U2), TigerLogic’s D3 and numerous flavours of SQL (including mySQL, MS SQL Server, Oracle, etc.). Support for Univision will follow in a few weeks time.

    This can enable you to enhance your users experience and workflow by aggregating disparate data sources into one interface, whilst continuing to maintain those separate islands of data. This ensures data integrity is retained, whilst enabling your application’s users to read, write and maintain those islands of data AND it enables the users of those islands of data to continue to work with them outside of your application, as they do now.

OK, so there is a fourth reason. Revelation Software has just recently released a free to use OpenInsight 9.2 evaluation version of the toolset – including the data connectors and O4W.

Mention this code (MDP92100810) and you’ll receive an installation key for a full 60 day period, rather than the usual 30 days.