Pop-ups in OI10


Sprezzatura recently wrote a blog posting following the release of OpenInsight 10 (OI10) and in that posting was the new way of using a standard OpenInsight pop-up to launch a selected data record.

I’ve had a few people asking for some OI10 videos and someone asked for the new pop-up method to be recorded specifically.  That video is now available on my YopuTube channel at the link below.

Please remember that I am learning fast at the moment, but hopefully the video will help you to use the same feature in your OI10 applications.

Thank you to Andrew McAuley for bringing this feature to our notice and for documenting on the Sprezzatura blog.

Fiddlesticks – More code to remove :)


So, Andrew at Sprezzatura really made my day with their latest blog posting.  As a non-programmer, I tend to do things how I was taught.  Sometimes I learned those lessons ages ago and I never think that there might be better and easier ways of doing things.

Andrew’s latest blog posting came literally a few short hours after I’d been cutting code to manage the Pop-Ups in my application and have them pass the ID to the appropriate control and read the record to display the data on screen.  It’s only a dozen or so lines of code, but after reading his blog posting, I now have a whole new way of interacting with pop-ups and I finished the day with a lesson learned and a little more OI10 knowledge.

The result is, that I now need to go back to my new OpenInsight 10 (OI10) application and rip out even more code in favour of using the options that OI10 now exposes in the quick events for most controls.  The clear benefit however, will be less code for me to maintain (or should I say mess up) and the use of professionally written code behind the scenes, easily preferable.

Just another example of how OI10 will definitely help me to produce better and more reliable systems, and much faster than before.

You can read Andrew’s blog article, which takes a first look at OpenInsight 10 here.

So, what has changed in OpenInsight 10?

Bob Catalano has written a nice summary of the features and benefits of OI10.  This is available on www.revelation.com and I have also copied it onto the RevUK website here.  This text is also being picked up on Social Media and other places and shows how exciting this new OpenInsight release is.

If you are an existing OI developer and you want to know more about the wealth of changes to the presentation layer, etc., then Carl’s Building OpenInsight 10 blog is an absolute ‘must read’.

Bob has also provided a number of new getting started documents which now ship with the OI10 software.  This includes guides for non-OpenInsight MultiValue developers who wish to explore using OI10 as a front end to their existing MultiValue databases (U2, D3, QM, etc) and SQL developers which would like to interface to their SQL databases.  There is now a brand-new data connector for some cloud databases, such as Couchbase, all with Quick Start Guides.

If that is not enough, please feel free to contact your local Revelation Software office and we’ll be pleased to take your questions and provide you with some answers.

OI10 really is ground-breaking and it’s set to make Windows and Web Application Development even easier for professional developers and hobby developers, like myself.


Nice way to start the week

Network ErrorWhen starting a brand new week, with new challenges and goals, there is nothing better than opening your email, clearing out the spam (and I get ‘a lot’) and finding a really nice positive message from a client.

This morning was one of those days.

The Universal Driver (UD) 5.x was originally only planned for release with OpenInsight 10, but because of customer needs Revelation decided to roll it back to support OpenInsight 9.4 and we now have customers upgrading their sites for the brand new reconnect (failover) and Volume Shadow Copy Service (VSS) capabilities.

Last week, I supplied a key for Aaron to upgrade one of Sprezzatura’s clients who are upgrading their UD 4.x licenses and their UDH 4.x to the UD for VSS and failover.  On checking my email this morning I found the following email, the client’s name has been removed for confidentiality reasons.

“Just to let you guys know, Company is installing the UD5 on their main servers and we’re just in the middle of basic testing now.  Initial impressions from Company are:

  1. With encryption, it seems faster than the UD Heavy.
  2. They dropped server connection for 10 seconds and it stayed connected.
  3. They like the look of the new UD manager over the old one.

All in all, everyone there seems really impressed with it so far.   Good job guys.”

Like I said, it is always nice to come into the office and receive nice positive statements from clients (end users) who are feeling the benefits of what Revelation do.

The blog postings just keep coming

With postings from Carl regarding OI 10, SRP and Sprezzatura, it looks like the blogosphere is getting busy in the Revelation world right now.

Recent postings include:

  • OpenInsight 10the blogs most recent post touches on enhanced OLE control (OCX) integration and support for OLE.  One of the main objectives is to provide the ability for developers to register OLE controls with the IDE and bind then to the database.
  • Sprezzatura have just posted a technical posting which discusses just about everything that you wanted to know about HTTP headers.  The posting discusses the need for developers to query HTTP headers sent by the client and that are not included in the default information passed forward by OECGI3.  This blog article is relevant to developers who are using O4W or calling OECGI3 directly.
  • SRP Computer Solutions have just posted a reminder of how modules can be tied to the old Application Manager UI in OI 8.0 and later.  Using their System Editor as an example, the blog posting includes full details of linking buttons and there is a free download for the companies Side Bar Images.

Please click on the links at the beginning of the bullet points to view the whole blog postings.

SRP and Sprezzatura Blog Postings

Both SRP and Sprezzatura have recently released a couple of very interesting and useful blog postings:

  • The SRP Update has posted a new article called, ‘The Case of the Jittery Java’.
    Java. It is that program that is always installed on a system and is always asking to run updates.  We don’t even consider it when troubleshooting an issue, but maybe we should…  Recently, a client requested for us to come out and give a tutorial on how to use their new smart barcode scanning units.To read the rest of the article, please visit the following link: http://blog.srpcs.com/the-case-of-the-jittery-java/
  • Sprezzatura’s latest blog posting is entitled “Using concatenated arguments – a warning.”
    Regular OpenInsight users will know that calls to SET_PROPERTY and GET_PROPERTY can be made more efficient by passing @rm delimited arrays to the routines rather than making multiple individual calls.   Although using the @rm concatenation method can lead to improved performance you need to be aware of how it is actually implemented, otherwise it can lead to some subtle bugs that may be hard to track down.To read the rest of the article, please visit the following link: http://sprezzblog.blogspot.co.uk/2013/11/using-concatenated-arguments-warning.html

#RevCon13 – Revelation X & High Availability

Revelation Software 2013 Conference LogoOK, so we all know that OpenInsight has high availability inherently built in but it is interesting to bring the two initial session titles together in such a way.

With the opening addresses now done and dusted, the conference is getting down to the technical side of the proceedings and one of the main and many reasons why OpenInsight developers from all over the world have taken the time to be in Nashville this week.

Carl Pates (Sprezzatura) and Jared Bratu (Revelation) go head to head in this first breakout session. Carl will be talking about Revelation X (OpenInsight 10) and Jared will be taking on the topic of High Availability, Network Design for O4W websites.

Revelation X
Carl Pates (Sprezzatura)
Those of you following the “Building OpenInsight 10” blog will know that the next generation of OpenInsight is well on its way. During this first public presentation about this new and exciting version of our toolset, Carl will be demonstrating some of the new features and enhancements to the Presentation Server. Those people attending his talk will finally get to see that the enhancements shown on the blog are really REAL and not faked as vapourware in Photoshop!

During his talk Carl will touch on topics that will include: The New Graphics Engine, New Controls, New Tools, What’s changed (and why) and what is yet to come.

Attendees to Carl’s talk will be encouraged to offer suggestions for further enhancements for features that they would like to see in the toolset from version 10 onwards.

High Availability: Network Design for O4W Websites
Jared Bratu (Revelation Software)
Going up against Carl and such an exciting presentation as his on version 10 will be no mean feat. However, with more and more O4W based solutions going live and into the cloud, web, internet (whatever you wish to call it today), this is sure to be another popular breakout session with the attendees.

Taking on the form of a tutorial, Jared will educate his audience on the implementation of a high availability website cluster and frontend proxy server for O4W websites. Attendees will learn how to identify key items of the cluster configuration for integration with an existing site. Jaren will talk about the advantages and disadvantages of moving the OEngine server service off of the database server and scaling it onto multiple webservers. Attendees will leave this session with valuable PowerShell scripts that will enable attendees to deploy configurations across multiple servers.

Regardless of whether you need to scale your website or you just want to understand some options that are available for the future, attendees will find out how an Open Source front-end proxy server can add capacity without making any code changes. Attendees will also gain knowledge of Open Source tools that are available to help to test a site’s capacity and then to benchmark any changes made to the site.

If you have ever wondered how many users your site can support (a question that I am asked during just about every pre-sales O4W discussion), how it can scale to support more visitors, or you are looking for improved site reliability, then you will definitely benefit from this session and walk away with knowledge that is certain to get you started on the right path.

With a schedule like that, I can see many delegates hovering outside both doors pondering which session is the must see. For me, well I’d sit in on one with a stethoscope to the wall listening to the other – they are both just too good to miss.

Reporting just got a whole lot faster.

A couple of weeks ago Sprezzatura blogged about their new report viewer which is now part of S/List and which dramatically reduces the time taken to produce reports for preview.

I had a nice little demo in which i could show the difference between running a List statement in the OpenInsight .net print engine and the new Sprezzatura Viewer. However, to get even more speed S/List is now configured to only operate with the new Sprezz Report Viewer.

Fortunately, I was so amazed by the results I took a video of the comparison and I’ll gladly take you through the video using a WebEx session if you drop me a line.  We can then also try running one of your reports (List Statements) against your data file and see what a difference it makes.

The new version of S/List is now being tested by a couple of key S/List users and reports that are coming back are more than favourable.  For example: “WOW!!! S/List Express is fast. For example in a 6000+ employee database one report that previously took 2 min 57 sec now runs in 43 sec!”.

If you are running OpenInsight version 9.x (sorry S/List Express does not work with version 8.0.8 and prior) and you’d like super fast column based reporting then drop me a line and we’ll see what S/List Express can do for you.