In Development
As we stated in the OCTOBER 2009 NEWSLETTER, OpenInsight for Web (O4W) is being designed to bind to SQL tables. This has led to the development of a new SQL Connector that will also be included in OpenInsight 9.2.

The SQL Connector is a Base Filing System (BFS), not a Modified Filing System (MFS) that is currently part of the Client/Server Workspace of OpenInsight. In the past SQL data was only accessible to the Form Designer via the C/S Workspace. With the SQL Connector, SQL tables are now seen as native tables to all components of OpenInsight including forms, reports, popups and stored procedures.

Within each of these components, opens, reads, writes, locks, unlocks and selects all work the same.

The SQL Connector works with the SQL statement that is placed in a dataset. This means that you can bind to tables, use views and multi-table SQL selects. The SQL Connector will point at a dataset and it will create OpenInsight F-type fields for each column in the dataset. Developers can add symbolics, including Xlates to other SQL based tables.

The SQL Connector also utilizes ADO record sets which eliminates the need for developers to deploy ODBC connections to client workstations.

OPENINSIGHT RELEASE 9.1.1
Revelation Software will be releasing OpenInsight 9.1.1 on November 30, 2009. This is a patch release to OpenInsight 9.1 and includes enhancements to the following components of OpenInsight:

* Arev32
* OIPI.net/OIPI
* Database Manager
* DotNetExplorer
* TCL
* System Editor ++
* Client/Server Workspace
* IDX Sets

 

2009 ROADSHOW
The San Francisco Area Road Show has been scheduled for Wednesday, December 2nd.CLICK HERE for more details. The Boston Area Road Show has been scheduled for Tuesday, December 8th. CLICK HERE for more details.

FALL CLASSES IN SESSION
It's November and our Fall Classes have commenced. CLICK HERE for our Fall Class schedule.

REVELATION USERS' CONFERENCE 2010
Revelation Software is pleased to announce that our keynote speaker for our 2010 Conference isTHOMAS J WILSON, president and CEO of Unisphere Media which publishes DATABASE TRENDS AND APPLICATIONS. Tom's keynote presentation is titled "Ten Trends Shaping Information Management in 2010".

Our 2010 Users' Conference will be held at the Rio All-Suite Hotel and Casino in Las Vegas, Nevada on Tuesday, April 27th - Friday, April 30th, 2010. Contact This email address is being protected from spambots. You need JavaScript enabled to view it. or call our Customer Care Department at 800-262-4747 for more information.

Tech Tips
Did you know...

That you can change the look and feel of your OpenInsight application by setting window gradients for the background color and style of a window.

Gradients my be set programmatically using the GRADIENTSTYLE and BACKCOLOR properties of a window. They can also be set in the Form Designer by opening the Windows Properties dialog and clicking on the Gradient button located on the right hand side of the dialog box.

The Gradient Definition dialog box contains a drop down list of available Gradient Types. The available types are: "None", "Vertical", "Horizontal", "Ellipse", "Pyramid" and "Mountain". When a type other than "None" is selected, the "Grade To Color..." button is enabled. Clicking the button will display the Choosecolor dialog box. Once the Grade to Color is set, click the OK button. The settings will be stored on the OpenInsight form.