OpenInsight 10.0.6 is now available


didyouknowoi10As many of your will know, I have been a avid supported of OpenInsight 10, working with the alpha, beta and now every release since it was released to the world.

With every new release I find something that makes my life as a developer easier, faster and more pleasurable.  Only last week, I stumbled on the fact that I no longer need my VScroll code to make tab controls work, you now only need the click event and OI10 take care of the rest.  Yet another example of more of my code that I can remove in place of professionally written and optimised code and a time saver for the future when adding new tab controls to my forms.

So, what is new in OpenInsight 10.0.6, which has just been released.

Presentation Server

General

  • Optimised page swap rendering
  • Implemented PAGESWAPRENDERMODE property for paging components
  • Implemented REPAINT method
  • Added Repaint parameter to the INVALIDATE method
  • Removed “inherited event” processing
  • Added RDW_FRAME when setting REDRAW back to TRUE$

DATETIME object

  • Implemented Relative time specifiers for VALUE-based properties

WINDOW object

  • Implemented READPREV method

O4W

General

  • Improved performance by reducing redundant output (for duplicate events and classes)

O4WQUALIFYEVENT

  • Added new event “classlink” for optimization (used for example with a whole table of links or buttons so that there’s only a single function that gets called to act on the click, based on a class name )

O4W Form Wizard

  • Changed to use new optimised classclick event instead of individual qualifyevents on icon buttons
  • Added ability to specify foreground and background colours on search results page

O4W Report Wizard

  • Changed to use new optimised classclick event instead of individual qualifyevents when called as multi-select popup

Lock Manager (OI Console)

  • Changed to use new classclick event

Banded Report Writer (BRW)

  • Added support for SYSDICT items.  Example code added to supplied RTI_BRW_SUPPORT example routine.

Miscellaneous

RTI_CHAIN_SELECT

  • New routine to optimise multiple sequential SELECT statements, when issued either to local OI system or back-end BFS.
  • Subroutine accepts a series of SELECT statements (@fm delimited), determines if local or server selects, runs the statements as a block, and returns the final set of keys as an active select list.
  • Currently implemented for OI, D3, QM hosts.

Click HERE for a copy of the OpenInsight 10.0.6 ChangeLog.

 

Advertisements

New Create User Details function


RTI_CREATE_USER_DETAILS function for OpenInsight 10.0.5 and above.

didyouknowoi

OpenInsight 10 provides support for login policies including locking out of users after a definable number of unsuccessful attempts, password construction requirements, etc. Sensitive data for policy and user information is stored in AES encrypted records.  Policies and users are maintained via the OpenInsight 10 IDE.

OpenInsight 10.0.5 and above introduces a new function called RTI_CREATE_USER_DETAILS that allows developers the ability to create a new user or modify information about an existing user in the OpenInsight database.

Description: Creates a new user or modifies information about an existing user in the current database.

Note:  Only Level 1 (Administrator) and Level 2 (System Administrator) users can create users. Level 0 (User) users can only change their own, existing information.

Syntax: RTI_CREATE_USER_DETAILS(userID, currentPwd, userpassword, fullName, validValue, disabledFlag, disabledDate, disabledTime, resetFlag, userType, userLevel, o4wLevel, expirval, expirdate, errDetails)

Return: “1” if the create or edit succeeded
Value: “” or “0” if the create or edit failed, and additional details are returned in the errDetails parameter.

Parameters: The function has the following parameters.

ParameterDescriptionParameterDescription

Parameter Description
userID A user identifier. userID must begin with an alpha character, followed by any combination of characters, digits, and underscores and cannot include spaces.
currentPwd If enhanced authentication is enabled on this OpenInsight system, then a User-level user who wishes to change any user information must pass in the current password in this parameter. This allows the system to verify that they are authorised to make changes to this user information.
userpassword The new password for this user. If enhanced authentication is enabled, then the password must match the specified authentication policy. If legacy authentication is used instead, the password must be a string of characters, 6 to 20 characters in length, and – if not specified – the default is null, and a password is not required to access the database as this user.
fullName The full name of the user.
validValue This is a user-defined parameter that allows the developer to specify additional information that they would like returned if the user’s logged-in state is queried (for example, to implement additional permission levels and groups). By default, this value is “1”.
disabledFlag If enhanced authentication is enabled on this OpenInsight system, then if set (value is “1”), the user will be disabled; if it is reset (value is “0”), the user will no longer be disabled. If the user is disabled, pass in the additional disabledDate and disabledTime parameters.
disabledDate If enhanced authentication is enabled on this OpenInsight system, and the disabledFlag has been set, this parameter specifies the internal date that the user is disabled until.
disabledTime If enhanced authentication is enabled on this OpenInsight system, and the disabledFlag has been set, this parameter specifies the internal time that the user is disabled until.
resetFlag If this parameter is set (“1”), the user must reset their password at the next login.
userType If this user should only be allowed to access the OpenInsight desktop interface, specify “0” for this parameter. If this user should only be allowed to access OpenInsight via O4W, specify “1” for this parameter. If the user should be able to access both desktop and O4W instances, specify “2” for this parameter.
Userlevel If the user is defined as an OI user, or as both an OI and O4W user, specify the OI permissions level here. There are three levels of users. When the user is logged in, the value is stored in the system variable @ADMIN.

There is no default value for Userlevel. If you do not specify a value, execution fails, and an error is generated.

Value Description
0 User
1 Administrator
2 System Administrator
o4wLevel If the user is defined as an O4W user, or both an O4W and OI user, specify the O4W permissions level here. The valid values for O4W permission groups are customisable on a per-site basis.
expirval Expiration parameter for the password. Possible values are:
Value Description
0 Expires at next login
1 Never Expires (default)
2 Expires at the expiry date
expirdate If expirval = 2, the expiration date (passed as a standard output converted date in a format such as mm/dd/yyyy).  Only required if expirval = 2. Note that this value is only relevant when legacy authentication is used on the OpenInsight system; if enhanced authentication is enabled, expiration will be as per policy.
errDetails If any errors are encountered during the execution of this function, they are returned in this parameter.

 

OpenInsight 10.0.5 now available for download.


OI10whiteOpenInsight 10.0.5 is now available in both full install and upgrade options from the WORKS subscriber area on www.revelation.com.

OpenInsight 10 is Revelation Software’s flagship product that provides modern application development tools for both desktop and web (mobile) based solutions.  With everything on one box, the tool-set is fully integrated to enable very fast and cost effective application development and deployment.  With Git features built right into the Integrated Development Environment (IDE), the tools support individual developers right up to multi-disciplined teams spread across countries around the world.

To find out more about the enhancements in this latest release, please click here for the  OpenInsight 10.0.5 Change Log.

To get a copy of the OpenInsight 10.0.5 evaluation and access to the OpenInsight Quick Start Guide videos, please click here.

 

Truly a Milestone Day for OpenInsight


didyouknowoi10Today is a real milestone day for Mike, Carl and everyone at Revelation Software who have been involved with the OpenInsight 10 release.

Over the last few weeks, many of you have been asking me how the project has been progressing and when you will see the final release.  Well today that day has arrived with Revelation Software releasing the final shipping version of OpenInsight 10 to WORKS subscriber overnight.

The new version is a world away from what we had before.  The interface for the desktop development suite is so much nicer to work in, it is more intuitive, you can work on multiple things at once and you’ll be building interfaces with far less code than before.  Revelation really have taken a lot of the hard work away by exposing and including a whole host of new properties.  O4W has not been forgotten either, and Bryan has introduced a whole new layer of design control, but I’m yet to get into O4W 10 for the moment, so more on this later.

In addition, OpenInsight now includes support for some cloud based databases, glyph buttons, the toolset is more DPI aware with the option for you to use numerous sizes of images for better representation within your applications, a powerful new OIConsole Manager, performance enhancements and much, much more.

I hope to run a small video of the new release later today (time permitting).  In the meantime, if you are an OpenInsight WORKS subscriber, you can get the full release from the WORKS area in the normal place.  If you are not a WORKS subscriber, please contact your local Revelation Software office to find out more about how OpenInsight can help you to build better applications.

When is a bug not a bug…


… when Martyn is playing with the OpenInsight 10 Beta and his knowledge of the new system is lacking <lol>.

OI10Beta

As many of you will know, I have been working with the OpenInsight 10 alpha for sometime and I recently downloaded and begun playing with the official OI10 Beta which was released a week or so ago.

I’d reported a good number of issues to RevUS during the Alpha program and I’m pleased to see many of those issues resolved in the Beta and a mountain of other things now working and working really nicely.

OI10 is a massive change from the old 9.x versions.  It is so much easier to use and massively more developer friendly.  I’ve only really played in the forms designer (image above), popup designer and scripting tools but it is a brand new world compared to the old interface and tools.

For example, the Main Application Manager window lists your recently accessed entities, making access to those entities a day or two later super easy.  Once in the forms designer, you can now have multiple forms open and you can work on them all at the same time – although I’ve confused myself on numerous occasions and found that the tab bar gets a little full.  However, I absolutely love the ability to have a form open and then scripts and Quick Events open for that form, popups associated with that form, graphic files associated with that form and more – it’s just so intuitive and super, super easy to jump between entities.  No more closing things, drilling down to find new entities and opening them – it’s just a massive, massive time saver, let alone more organised.

Then you have the properties and events readily available at the side of the interface.  I usually have the Properties panel open because there are just so many properties that have been exposed to make life even easier for developers.

I used to write loads of lines of code to handle row shading, window positioning and the like, now it’s a value in the properties window.  This makes for exact positioning, the creation of some lovely looking windows, better graphics handling and much much more.

As I get more into OpenInsight 10, I find that it is the little details that are making all the difference.  For example, when compiling a form, I get an immediate notification of an issue in the output panel at the bottom of the window in red text.  So  much more is delivered right to the developer in the interface.

All of the usual tools are in the toolset, although just about everything has had a makeover or some level of enhancement.  The changes within the toolset are huge and massively beneficial.  The only downside is that there is going to be work for all of us moving existing OpenInsight applications to OpenInsight 10 but the benefits will be well, well worth the time and effort.

As for non-OpenInsight developers.  Well, Revelation are now delivering one of the few fully integrated application development suites for both super rich desktop and amazing web based applications.  We now have a very intuitive toolset that developers using other tools will be right at home with and which features form design tools, coding tools, debugging tools, reporting tools and much, much more for both desktop and web, right on one comprehensive toolset.

Another massive leap forward is O4W.  This ground breaking toolset, that I used some time ago (as a non developer) to build a proof of concept application and which was finished by the VAR and now used by the employees of some of the Internets biggest names (no need for me to say who), used to be based on a couple of columns and creating more complex interfaces was not overly easy.  With OpenInsight 10, all of that has been addressed and O4W10 (not it’s official name) has really matured into a brilliant piece of technology for those of us who don’t want to learn HTML5, Javascript and the like.

I might be more than a little biased, but I am totally and utterly blown away by what Revelation are now very close to delivering to the OpenInsight development community, the MultiValue development community for widely and business in general.

The beta program is currently open to all OpenInsight WORKS subscribers.  If you are reading this and you are not a WORKS member or you are new to Revelation Software, please contact your nearest Revelation office and we’ll be pleased to assist you in any way that we can.

I was told sometime ago that OpenInsight 10 was set to be a game changer.  I now know why that person said that to me and I can’t wait to learn more about converting my applications and building new systems and proof of concepts for clients and prospects.

OpenInsight 10 – Alpha 7


OI10whiteRevelation have made some good progress with the OpenInsight 10 Alpha and I’m currently working through my bug list and closing a nice number of reported issues from earlier alphas, something that I’ll continue with over the weekend.

In line with their open and transparent policy for OpenInsight 10, they Alpha v7 is now available for download to all Works Members.

The Alpha v7 is available as a full install. So, if you have worked with earlier alpha’s please use the AppBackup facility to backup your old alpha work and restore it into the new alpha.  This is what I do but one word of warning.  If you keep your data, images and other supporting files in a specific folder (I keep things in C:\RevSoft10.6\MDPmyApp) you’ll need to copy that folder from the earlier alpha and into the new alpha once installed.  The app restore will then use the new folder and the restore should run just fine.

This version includes many enhancements to the IDE, Form Designer, Table Builder and O4W, so it is well worth a look and to take the opportunity to report any issues that you find to Revelation and have those issue addressed before Revelation releases the beta.

OpenInsight for Web (O4W) v2.0, included in the OpenInsight 10 Alpha v7, is a rapid application development tool that lets you generate responsive forms, reports, and dashboards.  Use the powerful GUI drag-and-drop to lay out your forms and then test in both desktop and mobile browser mode. Or use the toolset’s full-function API to create the most sophisticated web pages.

Alpha v7 is set to expire on April 4, 2017.

OI10 Alpha 3


OI10whiteThis is just a quick reminder that the Alpha 3 is available to all OpenInsight WORKS members via the WORKS area on http://www.revelation.com.

Whereas previous alpha releases were full installation only, this release is provided as a full installation or and upgrade, allowing you to continue any work that you have done in the previous Alpha 2 release.

This version includes many enhancements to the IDE, Form Designer, Table Builder and O4W.  In fact O4W sees a lot of change and it is now badged as OpenInsight for Web (O4W) v2.0.

O4W 2.0 is a rapid application development tool that enables you to very quickly and easily generate responsive forms, reports and dashboards.   This new version supports more drag and drop functionality and it now enables developers to lay out forms using the drag and drop features.  Once complete, you can then test them in both desktop and mobile browser modes, or you can use O4W’s full-function API to create the most sophisticated web pages for just about any mobile or desktop device that runs a browser.