Index Rebuilding in OI10


dbmindexrebuild
The Database Manager as seen in OpenInsight 10

This is another of my ‘reminder to self’ blog postings but something that one or two of you might find useful.

In OpenInsight 10 you can view the Database Manager panel and simply select a data table, right mouse click to open the context menu and from there you can do a whole host of things, including rebuilding the index for that table (see the image to the left).

That is great, but what if you want to rebuild all of your indexes.  It’s going to be a little cumbersome and time consuming selecting each table, then right mouse clicking, then selecting rebuild index, then waiting for it to rebuild and then repeat, repeat, repeat …

Following a quick conversation with Bob, I had the solution.  For the moment, the option to rebuild all indexes in an application from a menu is not available.  A convenient menu option might well come in an update, but for now it is as easy as launching the System Monitor (but you’ll have that running already in development mode) and typing ‘update_index””,””,1’ and hitting return to execute the command (as shown below).

indexrebuild
The System Monitor, running under OpenInsight 10.

You will get a message to let you know how many tables you will be rebuilding the indexes for and a reminder that this “could take a long time”.  Click Yes to continue and OpenInsight will go away and index all of your tables.  There is no progress bar at the moment, so watch the OpenInsight 10 Main IDE’s status line for messages about the indexing.  You’ll see OpenInsight run through your tables and (assuming all goes well, which it will) you will be presented with a “Processing Completed” note in the status line.  Job done.

Thank you to Bob Carten for this tip.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Advertisements

Controlling TCL


tcl

I have recently been asked if OpenInsight 10 can be enhanced to enable developers to filter TCL commands, or in other words, to only show TCL commands that the developer wishes to expose to their end users.  For example, it is often a requirement or wish, for DELETE to be removed or screened from the users because it can cause issues.  However, it would be useful if LIST could be exposed so that knowledgeable end users could run list commands for quickly produced ad-hoc reports.

During one of my catch-up sessions with Mike, I put this to him and found that this is actually something that was introduced back in 2009.  Most likely following a customer request at tone the RUG meetings that Mike holds from time to time.

As Mike has detailed for me, configuring the system to filter TCL commands it pretty straight forward:

  1. As an OpenInsight developer, you initially need to make a record in the SYSENV file.  This record should have a key with one of the options noted below:
    • TCLCMDS*APPNAME*USERNAME
    • TCLCMDS**USERNAME
    • TCLCMDS*APPNAME
    • TCLCMDS
  2. In this record, you should enter a command that you want your users to have access to and be able to use from TCL (as shown below).  The user will then be limited to using only those those commands by typing the commands into the TCL as normal.  The TCL Assistant will also then only show those commands that are available to the users.
TCL-SYSENV
Configuration record as seen in OpenInsight 10

Now, with the options set as above, when the TCL Assistant button is pressed the user will be given a filtered list of available commands (as shown below).

tcl
Filtered TCL Assistant as shown in OpenInsight 10

If the user tries to be clever and force a command that has been filtered out of the available options (for example, DELETE or COPY_ROW), OpenInsight will return a ‘command not supported’ message and the command will not run.

This now enables developers to safely expose TCL with the controls that ensure that their systems are safe and that end users cannot run a command that is not unsupported by the developer in their application.

I no longer maintain an OpenInsight version 9 system on my machine for testing this (I’m fully OI10) and although the screen shots within this posting are taken from an OpenInsight 10 system, the above should be possible in most of the OpenInsight 9.x versions released since 2009.

Finally, thank you to Mike for helping me to put this blog posting together.

An important date for your diary.


Bob at the 2015 Conference.

Mark your calendars! On Thursday, June 7, 2018 11 am PT / 2 pm ET Revelation Software in conjunction with DBTA will be hosting a webinar on “An Introduction to the Features and Benefits of OpenInsight 10”.

Click HERE to Register for this event.

In April, 2018, Revelation Software proudly announced the official release of OpenInsight Development Suite (OI) 10.0. OI 10 has been re-engineered for 64-bit in this new release. We have rewritten nearly every bit of code in the product, from the interface with the user, to the reporting tools, and the speed of the indexing routines. OI 10 provides the following new and/or improved components:

  • New IDE – OpenInsight 10 includes a brand new IDE, visually similar to modern application development tools, yet still designed for the MultiValue developer. Each of the product’s designers, for forms, tables, reports and all others are now contained into a single, cohesive workspace.
  • Arev64 – The next generation of our Advanced Revelation emulator, utilizing the full power and capabilities of modern 64-bit architectures.
  • User and Data Security – With increased concerns about security and privacy, including upcoming GDPR requirements, a number of enhancements and changes have been made to strengthen data security.
  • Management Console – The OpenInsight Management Console is a browser-based database management tool for system administrators.
  • Git Integration – OpenInsight’s repository based environment is integrated to the Git source code management system.
  • Universal Driver 5.1 – 64-bit and VSS capability.

In this webinar Mike, Bob and Bryan will provide an overview of the new features and benefits of OpenInsight 10.

OI10 Productivity features SRP love.


SRPProductsYou will have noticed just recently that I have become more excited about the OpenInsight 10 release and how it helps application developers to get more done, more quickly, with less code, etc. etc.

Over the weekend, Don from SRP joined in with the excitement of this ground breaking release with an SRP blog posting which looks at some of the OpenInsight 10 learning resources that are now becoming available and he touches on the productivity features in OpenInsight 10 that he and the team at SRP are falling in love with and which will no doubt help them to continue to deliver great systems for their clients and now more easily and in a quicker time.

Unless you’ve stayed in extended winter hibernation, you already know that Revelation Software officially released OpenInsight 10 three weeks ago. Furthermore, SRP embraced this release and was pleased to announce the general availability of our 64-bit controls and freeware utilities. The number of new enhancements and features in OpenInsight 10 can be overwhelming to learn. Fortunately, there are a number of articles and opportunities available to quickly get you up to speed. We encourage our readers to visit the following sites:

Click below to read more of Don’s latest posting.

http://blog.srpcs.com/openinsight-10-productivity-features-we-love/ 

SRP Controls – Updates released for OI10


SRPProductsThis is a quick note to highlight that SRP have just announced the release of their SRP Utilities and SRP ActiveX Controls for the new 64-bit-only OpenInsight platform.

Since OpenInsight 10 (OI10) was released, several of you have spoken to me about support for the SRP controls in OI10 and, as expected, Don and his team have delivered very quickly following the OI10 release.

OpenInsight 10 Overview Video


Since uploading the two videos yesterday, I have had more pressure from people to get some form of overview video out for OpenInsight 10.  It seems that there is significant interest in the new version of OpenInsight but people want a quick view, rather than downloading, installing and running their own evaluation.

I have therefore just uploaded an initial overview video.  Although this video is not short (a little over 51 minutes), it is a ‘very’ quick overview of the OpenInsight 10 tool-set.

Aimed primarily at experienced OpenInsight developers who are familiar with the OpenInsight tool-set, this video takes quick look at the Integrated Development Environment (IDE), how the tools are launched and how the interface reacts to those launched tools.  We don’t look at everything and nothing is looked at in any great detail.  I’ll take that request on a module by module basis.

As always, please comment below the video on YouTube if you find this video useful.  It is the only way that I know whether these videos are worth the time and effort to produce them.

 

The Hyperlink Control in OI10


So, it was mentioned to me that I was using a static control to launch the pop-up in my video this morning.  Whereas, Andrew was using a Hyperlink Control to do the same.  So what’s the difference and why did I opt for the Static Control?

I’ve just uploaded a new video to show the difference between the two and to show why I preferred the static text control in my application – mainly for a little more control owing to the background colour scheme that I have been using in my windows – no other good reason.

I hope that you are finding these videos useful and I’ll welcome your comments, feedback and ideas for more snippet videos like this one.