• Migration Guide
  • Planning the Migration
    • Overview
    • Using the New Features
    • The Migration Plan
      • 1. Initiation
        • Required Installations for Migrating
      • 2. Testing
        • How You Plan for Application Issues
      • 3. Backout Strategy
      • 4. Migration Scheduling
      • 5. Live Rollout
      • 6. Plan Creation
    • Migration Methods
      • Uninstalling the Previous Version OpenROAD and Installing the New Version
      • Installing OpenROAD into the Same Ingres Instance as the Older Version of OpenROAD
      • Installing OpenROAD into a New Ingres Instance
      • Installing OpenROAD with a Standalone Embedded Version of the Actian Client is not supported
    • Migration Considerations for OpenROAD Releases
      • OpenROAD Application Images Must Be Migrated
      • Migrating from Release 3.5
      • Migrating from Release 4.0 or 4.1
      • Migrating from Release 2006 (5.0)
      • Migrating from Release 5.1
      • Migrating from Release 6.0
      • Migrating from Release 6.2
      • Migrating from a 32-bit to a 64-bit Release
    • How You Perform the Migration
    • Path Notation in This Guide
  • Creating a New OpenROAD Environment
    • Overview
    • OpenROAD Components
    • New Environment Requirements
    • Alternatives in Establishing a New OpenROAD Environment
  • Migrating Applications with the PropertyChanger Utility
    • Overview of PropertyChanger
    • Before You Migration Your Applications Using PropertyChanger
    • How the PropertyChanger Utility Works
      • PropertyChanger Utility Components
    • Customize the PropertyChanger
    • Restyling Your Applications to Microsoft Windows 7 Standards
      • Run the Migration Assistant
      • Test Your Applications
    • Modifying Default w7styler Settings
      • Customize Default Settings
      • Test Your Customizations
  • A. Features Introduced in OpenROAD 4.1
    • OpenROAD 4.1 New Features
      • Property Option Menu Enhancements
      • TableField Enhancements
      • Keystroke Events on EntryFields
      • Auto-completion for OptionFields
      • New Field Styles
      • SizeGrip
      • TrueType Fonts
      • Button Styling
      • Progress Bars
      • Group Boxes
      • Wizard Frames
      • Icon Images
      • 24-bit Color Bitmaps
      • System Color Remapping
      • RGB Color support
        • RGB Function
      • Drag and Drop
      • Standard Toolbars Bitmaps
      • Flat Toolbars with Hot Tracking
      • Spin Controls
      • Date Picker
      • CompositeField Enhancements
      • ActiveX Error Handling Enhancements
      • UserClassObject Allocation Limit Increase
      • Report Writer Conversion to OpenROAD
      • StackField Separator (Screen Divider)
      • Minimizing Informational Messages in Trace Windows
      • Destroy a Single Component Flag in DestroyApp
      • Reporter API Documentation
      • Make Defining Break Columns Optional in Reporter
      • New OpenROAD Workbench Startup Options
    • OpenROAD 4.1 Demo Overview
      • Active Server Page Demo
      • SISUI Demo
      • Meeting Point Tutorial Demo
      • Object Factory Demo
    • Application Server Support for OpenROAD 4.1
      • Utilizing COM
      • 4GL Remote Procedure Calls
      • Automation Types
      • Fixed Signature, Dynamic Data
      • Structured Data
      • The Remote Server Object
      • The Parameter Data Object
      • The 4GL RemoteServer System Class
      • Private Server, Shared Server
      • Visual ASA
      • Application Server Object Library (ASOLib)
    • Reporter Enhancements
      • Enhanced Runtime Support
      • Changes to Reporter
        • Main Menu
        • Query Editor
        • Variable List Frame
        • Variable Properties Frame
        • Print Dialog
        • Reporter Procedure Tool
      • Report Procedure Tool
        • Dynamic Procedure List
        • Database/Application Information
        • Report List
        • Menu Bar
      • Tutorial
        • Before You Begin
        • Using the Procedure Tool
        • File Names
        • Saving Report Procedures
        • Running Report Procedures
        • Importing Reports to Target Applications
        • Working With Image Trim
      • Call Interface to Dialog Frames and Reporter Procedures
        • Calling via Dialog Frame
        • Calling a Report Procedure
    • OpenROAD 4.1/0109 Enhancements
      • Installer Enhancements
        • Installation of the Application Server
        • Upgrade of Enterprise Access
        • Installation of JDBC
        • Running VASA in a Runtime-only Installation
        • Determining Whether a Reboot Is Recommended
        • Installation of Thin Client Demos
      • Speed Keys Supported
      • New System Classes
        • DecimalObject Class
        • KeyDownData Class
      • New Events
        • ChildKeyDown Event
        • KeyDown Event
      • New Attributes
        • EntryField Class ExitBehavior Attribute
        • FrameExec Class NextTargetField Attribute
        • Object Class Attributes
        • SessionObject Class
      • New Methods
        • LongByteObject Class ConvertFromString Method
        • StringObject Class ConvertFromBinary Method
      • Application Server
        • Authorized Applications Only
        • Forced Shutdown
        • DPO
        • SPO Launch Permissions
      • Workbench
        • Application Workbench Frame
        • Edit Connections Profile Frame
        • Script Editor Frame
        • Reporter Query Editor Frame
        • Reporter Component
      • OpenROAD Runtime
        • ExtObjects
        • Reporter
        • TableFields
      • Demos
        • UNIX
        • Windows
      • VASA
        • SPO Details Pane
        • ASO Details Pane
        • Disable New Connections
        • Auto-Suspend
        • Stateless Application Housekeeping
        • User-defined Procedure - iiasohousekeep
        • Support for RP_LOCAL
      • ASOLIB
        • COM Errors
        • NameServer
        • XML-in
        • XML-out
        • Pre-process, Post-process User-written Routines for XML-in, XML-out
        • Load Balancing
      • UNIX
  • B. Migrating from OpenROAD 4.0 or 4.1
    • Overview
    • Migration Approach
    • Summary of the OpenROAD 4.1 to 5.1 Migration Process
    • Phase 1: Prepare for the Migration
      • Ensure an Existing 4.1 Test Environment Exists
      • Make a 4.1 Development Environment Available
      • Create a 5.1 Test Environment
      • Create a 5.1 Development Environment
      • Build and Test the Application Under 4.1
    • Phase 2: Convert the Applications
      • Copy the Applications from the 4.1 Environment to the 5.1 Environment
      • Build and Run the Applications in OpenROAD 5.1
      • Identify and Correct Any Remaining Issues
      • Update the About Dialog
      • Known 4.1 Issues to Resolve
        • Incorrect FP_CLEAR Field Setting
        • Incorrect Field Colors
        • Incorrect Truncation of Date-times
        • Change in Handling of Synchronous ActiveX Events
        • Ingres Result Type Differences
        • Building C Code Containing EXEC SQL Commands
    • Phase 3: Conduct Acceptance Testing
    • Phase 4: Go Live
  • C. Features Introduced in OpenROAD 2006 (5.0)
    • New Features
      • Modal Statistical Function
      • Makeimage Command Line Options
      • Alternative Access to the OpenROAD Server
        • Java Access to the OpenROAD Server
        • .NET Access to the OpenROAD Server
        • HTTP Routing Support
      • New Events
      • mClient
      • CellAttribute
      • User Class Constructors
      • Portlet Support
      • New System Class Features
        • TabBar
        • EntryField
        • ButtonField, CellAttribute, CompositeField, EntryField, EnumField, TreeviewField, SliderField, TabBar
        • SliderField
        • ButtonField
        • StringObject
        • SessionObject
    • Changes to Existing Features
      • ImportApp/ExportApp
      • Workbench Interface
      • Debugger
      • Documentation
  • D. Migrating from OpenROAD 2006 (5.0)
    • Overview
    • Migration Approach
    • Summary of the OpenROAD 2006 (5.0) to 5.1 Migration Process
    • Phase 1: Prepare for the Migration
      • Ensure an Existing OpenROAD 2006 (5.0) Test Environment Exists
      • Make an OpenROAD 2006 (5.0) Development Environment Available
      • Create a 5.1 Test Environment
      • Create a 5.1 Development Environment
      • Build and Test the Application Under OpenROAD 2006 (5.0)
    • Phase 2: Convert the Applications
      • Copy the Applications from the OpenROAD 2006 (5.0) Environment to the 5.1 Environment
      • Build and Run the Applications in OpenROAD 5.1
      • Identify and Correct Any Remaining Issues
      • Update the About Dialog
      • Known Ingres Issues to Resolve
    • Phase 3: Conduct Acceptance Testing
    • Phase 4: Go Live
  • E. Features Introduced in OpenROAD 5.1
    • New Features
      • XML Support
        • New XML System Classes
      • Query Tool Demo Application
      • New Configurable HTTP Gatekeeper
      • ToString Core Library Function
      • Hash Table Support
      • Array Class
      • Future Enforcement of Read-only and Read-write-once Attributes
      • FormField.BgDisplayPolicy Attribute
      • FrameExec.IsMaximized Attribute
      • FrameSource.IsMaximized Attribute
      • ProcExec Attributes
      • RadioField Attributes
      • SessionObject Attributes
      • StringObject Methods
      • Environment Variables
      • New Way to Invoke Application for Component Importing
      • StringValue Support for Trim Fields in Property Inspector
      • Workbench ImportComp Utility
      • Workbench ExportComp Utility
      • 64-bit DLLs to Access the 32-bit OpenROAD Server
    • Changes to Existing Features
      • Changes to “w4gldev backupapp” Commands
        • Importing Applications and Components
        • Exporting Applications and Components
      • Changes to the Workbench ImportApp Utility
      • Changes to Methods
        • AppSource.ExportApp Method
        • AppSource.ImportComp Method
        • ArrayObject.Find Method
        • CompSource.ExportComp Method
      • Easier Way to Create Composite Fields
      • Workbench IDE Resizable
      • Automatic Display of Workbench Develop Tab
      • Enhancements to Portlet Guest Frame Blocking and Shielding
        • Previous Behavior
        • New Behavior
        • ProcExec.PortletBlocking Attribute Added
        • Environment Variable Added
      • Enhancements to Class Browser Portlet on Develop Tab of Workbench
      • Enhancement to Class Editor
      • OpenROAD mClient Support for New Microsoft Windows Mobile Platforms
      • Documentation
  • F. Migrating from OpenROAD 5.1
    • Overview
    • Using OpenROAD 12.0 with Unicode-enabled Databases
    • Switching to a Unicode Environment
    • Migration Approach
    • Summary of the OpenROAD 5.1 to 12.0 Migration Process
    • Phase 1: Prepare for the Migration
      • Ensure an Existing OpenROAD 5.1 Test Environment Exists
      • Make an OpenROAD 5.1 Development Environment Available
      • Create a 6.2 Test Environment
      • Create a 12.0 Development Environment
      • Build and Test the Application Under OpenROAD 5.1
    • Phase 2: Convert the Applications
      • Copy the Applications from the OpenROAD 5.1 Environment to the 12.0 Environment
      • Build and Run the Applications in OpenROAD 12.0
      • Identify and Correct Any Remaining Issues
      • Update the About Dialog
      • Known 5.1 Issues to Resolve
        • Copy Profiles to Connect to the Same Ingres Instance
        • Recreate Profiles to Connect to a New Ingres Instance
        • Migrate EntryFields
      • Known Ingres Issues to Resolve
        • Ingres Result Type Differences
        • Building C Code Containing EXEC SQL Commands
      • OpenROAD 6.0 Behavior Change
      • Issuing Table-less Queries Against Enterprise Access
    • Phase 3: Conduct Acceptance Testing
    • Phase 4: Go Live
    • Special Considerations for Using Enterprise Access for Microsoft SQL Server
      • Unicode Extended System Catalog
      • Query Layer
      • Direct Execute Immediate Statements
  • G. Features Introduced in OpenROAD 6.0
    • New Features
      • Introduction
      • Transparent Unicode Support
      • New Location for Database Connection Profiles
      • OpenROAD Command Window
      • Expanded Ingres Functionality
        • Data Type Support
        • Function Support
        • Additional Statement Support
    • Changes to Existing Features
      • Changes to System Classes
      • Original Gatekeeper Deprecated
      • Documentation Updates
  • H. Migrating from OpenROAD 6.0
    • Overview
    • Using Integer8 Data Types in 3GL Procedures
    • Summary of the OpenROAD 6.0 to 12.0 Migration Process
    • Phase 1: Prepare for the Migration
      • Ensure an Existing OpenROAD 6.0 Test Environment Exists
      • Make an OpenROAD 6.0 Development Environment Available
      • Create a 12.0 Test Environment
      • Create an 12.0 Development Environment
      • Build and Test the Application Under OpenROAD 6.0
    • Phase 2: Convert the Applications
      • Copy the Applications from the OpenROAD 6.0 Environment to the 12.0 Environment
      • Build and Run the Applications in OpenROAD 12.0
      • Identify and Correct Any Remaining Issues
      • Update the About Dialog
      • Known 6.0 Issues to Resolve
        • Copy Profiles to Connect to the Same Ingres Instance
        • Recreate Profiles to Connect to a New Ingres Instance
        • Building C Code Containing EXEC SQL Commands
      • Known Ingres Issues to Resolve
        • Ingres Result Type Differences
      • OpenROAD 6.0 Behavior Change
      • Issuing Table-less Queries Against Enterprise Access
    • Phase 3: Conduct Acceptance Testing
    • Phase 4: Go Live
  • I. Features Introduced in OpenROAD 6.2
    • New Features
      • Introduction
      • New Environment Variables
        • II_SCINT_EDITOR Specifies the Scintilla-based 4GL Script Editor
        • II_TIMER_FOR_CURSOR Specifies Time to Wait Before Displaying Busy Cursor
        • II_W4GL_ALLOW_NVARCHAR Allows the Use of Nchar and Nvarchar Data Types
        • II_W4GL_EXPORT_WITH_DEFAULTS Includes Default Attribute Values in XML Export
        • II_W4GL_PASS_NVARCHAR_AS_WCHAR Enables Passing Nvarchars as Wide Chars
        • II_W4GL_TRACE_PAUSE_ON_ERROR Enables an Error Popup Box
        • II_W4GL_TRACE_PROC3GL_CALL Traces 3GL Procedure Calls
        • II_W4GL_UTEXE_SHARE_DBSESSION Shares DBSession Connection
      • CreateApp Command Line Utility Creates New Applications
      • Find Previous Functionality Added
      • Frames Without a Titlebar Can Be Dragged
      • HashTableEntry Class Added
      • InputEvent Class Added
      • JSON Classes Added
        • JsonArray Class
        • JsonBoolean Class
        • JsonHandler Class
        • JsonNull Class
        • JsonNumber Class
        • JsonObject Class
        • JsonString Class
        • JsonValue Class
      • MainBar System Class Added; FrameExec and FrameSource Get New Attributes
      • Microsoft Common Controls 6.0 Now Used for Windows Application Controls
      • MouseData Class and New Mouse Events Added
      • RenameApp Command Line Utility Renames Applications or Components
      • RequestManager Class Added
      • TaggedValue Class Added
      • w7_display Frame Template Added to Core Library
      • CompileApp Command Line Utility Gets New Flag to Transpile JavaScript from 4GL
      • Improvements to Workbench for Windows Script Editor
        • Shift-Ctrl-C Lets You Copy and Paste Syntax-highlighted Text in RTF
        • Ctrl-Spacebar Opens Keywords Auto-complete List
        • Ctrl-Enter Opens Word Auto-complete List
      • New CurExec System Variable Added
      • JsonHandler Class Gets New Attribute
    • Changes to Existing Features
      • ActiveField.OutlineStyle Attribute Gets New Setting for Subforms
      • AppSource Class Gets New Attribute and Methods
      • ArrayObject Class Gets New Attribute
      • AttributeObject Class Gets New Attribute and Methods
      • BitmapObject Class Gets New Attribute and Methods
      • CompositeField Class Gets New FieldsByProperty Method
      • CompSource Class Gets New Attributes and Values
      • EntryField.UseWidestCharacter Attribute Gets New Setting
      • FieldObject Class Gets New Attributes and Methods
      • FormField.BgDisplayPolicy Attribute Gets New Border Settings
      • FormField.UpdBackground Method Gets New Parameters for Active Field Background Bitmaps
      • FrameExec Class Gets New and Updated Attributes
      • FrameForm Class Gets New Transparency Attribute
      • HashTable Class Gets New Attributes and Methods
      • Improved Connection Profile Assistant
      • Input Event Class Gets New StopEventBehavior Method
      • IntegerObject.Value Attribute Changes Data Type
      • ListviewField Class Gets New Sort Method
      • LongVcharObject and StringObject Classes Get New FileEncoding Attribute
      • MethodObject Class Gets New Attribute and Method
      • Object.InstanceIdentifier Attribute Changes Data Type
      • OptionField OutlineStyle Attribute Gets New Setting
      • ProcExec Class Gets New InInitialize Attribute
      • ProcExec FilePopup Method Gets New Parameters
      • ProcExec.Trace Method Gets New Parameter
      • Scope Class Gets New Method
      • SubForm Class Gets New Attributes
      • Size of ToolTipText Attribute Increased
      • TabBar Class Gets New Attribute
      • Tree Class Gets New and Updated Attributes and Methods
      • TreeNode Class Gets New and Updated Attributes
      • TreeviewField Class Gets New and Updated Attributes and Method
      • TreeviewField Class Gets New Events
      • XMLDocument Gets New ParserCallbacks Attribute
      • XMLParserCallbacks Class Improves Processing of Large XML Documents
      • Loadnrun Enables Deployment of eClient Applications for Non-privileged Users
        • Loadnrun Compared to eClient
      • PropertyChanger Utility Updated to Enable Windows 7 Styling
      • Reduced Error Messaging with the Connect to DB Dialog
      • Updates to Components Portlet
      • New Fields on Select a Database Table Dialog
      • Table List for Importing Attributes Now Sortable
      • Enhanced User Class Attribute Creation from Database Tables
      • TableField Exact Height and Exact Width Now Programmable
      • Drag-and-Drop Enabled on Empty TableFields, ListFields, and Rows
      • EntryField Margins Now Adjustable
      • Character Width Settings for EntryFields Now Definable
        • New EntryField.WidestCharacterWidth Attribute
        • New System Constants for EntryField.UseWidestCharacter Attribute
      • File Selection Dialog Now Resizable
      • Dialogs Now Display Default File Names and Extensions
      • Qualified Class Names Displayed in Class Editor’s Inheritance Information
      • Continue Batch Execution and Log Exception Parameters Added to OpenROAD Application and Component Utilities
      • Renaming Applications or Components Improved
      • Property Inspector Always On Top
      • Improved Variable Value Assignment in Debugger
      • Foreground and Background Patterns Now Accommodate Transparent Bitmap Images
      • Fields Remain Selected in Frame Editor After Saving
      • Field Tree Gains Search Capabilities
      • User Classes Can Be Created from a Display
      • Toolbar Editor Enhanced
      • ControlButtons Now Modifiable from the Property Inspector and 4GL Runtime
      • BitmapObject.WriteToFile Method Now Supports PNG Bitmap Format
      • Using Integer8 Data Types in 3GL Procedures
      • FormField.RequireRealField Runtime Default Now TRUE
      • SK_BREAK Key Gets New Functions
        • Stops Code Execution in Development
        • Displays 4GL Call Stack Output from an Executing Image
      • Older OpenROAD Application Images Must Be Migrated
      • Support Added for Transparent 32-bit Icons
      • WindowPlacement Gets New Constants
      • Documentation Updates
        • Path Notation Standardized for Windows
    • Deprecated Features
      • OpenROAD 2.0 Flag Fully Deprecated and Removed
      • OpenROAD realfields Flag Fully Deprecated
      • mClient Deprecated and Removed
      • MenuButton, MenuGroup, MenuList Attributes Deprecated
      • TreeviewField AllowLabelEdit Attribute Deprecated
      • Workbench Classic Deprecated
  • J. Migrating from OpenROAD 6.2
    • Overview
    • Using Integer8 Data Types in 3GL Procedures
    • Summary of the OpenROAD 6.2 to 12.0 Migration Process
    • Phase 1: Prepare for the Migration
      • Ensure an Existing OpenROAD 6.2 Test Environment Exists
      • Make an OpenROAD 6.2 Development Environment Available
      • Create an 12.0 Test Environment
      • Create an 12.0 Development Environment
      • Build and Test the Application Under OpenROAD 6.2
    • Phase 2: Convert the Applications
      • Copy the Applications from the OpenROAD 6.2 Environment to the 12.0 Environment
      • Build and Run the Applications in OpenROAD 12.0
      • Identify and Correct Any Remaining Issues
      • Update the About Dialog
      • Known 6.2 Issues to Resolve
        • Copy Profiles to Connect to the Same Ingres Instance
        • Recreate Profiles to Connect to a New Ingres Instance
        • Building C Code Containing EXEC SQL Commands
      • Known Ingres Issues to Resolve
        • Ingres Result Type Differences
      • OpenROAD 6.2 Behavior Change
      • Issuing Table-less Queries Against Enterprise Access
    • Phase 3: Conduct Acceptance Testing
    • Phase 4: Go Live
  • K. Features Introduced in OpenROAD 11.1
    • New and Updated Features
      • Ingres 11 Support
      • IANA Time Zones
      • WebGen
      • Y2K38
      • JSON-RPC 2.0 Interface
      • JsonHandler Class Gets New Attribute GenMixedCaseMemberNames
      • New Environment Variable II_DICTIONARY_OK
      • Use of JSON File Instead of Windows Registry for Storing OpenROAD Server Configuration Information
      • ProcExec.Trace Method Gets New Parameter
    • Deprecated Features
      • eClient Deployment Deprecated
  • L. Features Introduced in OpenROAD 11.2
    • New and Updated Features
      • Ingres 11.2 Support
      • New abf2or Frame Template
      • COPY TABLE...APPEND Supported
      • New Environment Variables
      • General Environment Variables
      • Environment Variable for WebGen
      • Environment Variables for Memory Management
      • Manage OpenROAD Server Configuration File with the Orserveradm.py Python Script
      • Command Line Utilities Get New Replacement Parameters
      • New UrlConnection Class
      • XMLSchemeCache Class Gets New Attribute
      • WebView2 Updates
      • Support for the Enterprise Access ODBC Gateway
    • Deprecated Features
      • eClient Deployment Deprecated
  • M. Migrating from OpenROAD 3.5
    • Overview
    • Summary of the OpenROAD 3.5 Migration Process
    • Phase 1: Prepare for the Migration
      • Ensure an Existing 3.5 Test Environment Exists
      • Make a 3.5 Development Environment Available
      • Create an 12.0 Test Environment
      • Create a 5.1 Development Environment
      • Build and Test the Application Under 3.5
    • Phase 2: Convert the Applications
      • Copy the Applications from the 3.5 Environment to the 5.1 Environment
      • Build and Run the Applications in OpenROAD 5.1
      • Identify and Correct Any Remaining Issues
      • Update the About Dialog
      • Known 3.5 Issues to Resolve
        • Field Property-related Issues
        • Date Datatype Related Issues
        • Code Related Issues
        • Ingres Result Type Differences
        • Database Related Issues
        • Platform Related Issues
        • UNIX-specific Issues
    • Phase 3: Conduct Acceptance Testing
    • Phase 4: Go Live

Migration Guide

Phase 4: Go Live