• Migration Guide
•  1. Planning the Upgrade
  • Overview
  • Using the New Features
  •  The Upgrade Plan
    •  1. Initiation
      • Required Installations for Upgrading
    •  2. Testing
      • How You Plan for Application Issues
    • 3. Backout Strategy
    • 4. Upgrade Scheduling
    • 5. Live Rollout
    • 6. Plan Creation
  •  Upgrade 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 Ingres 10 Client
  •  Upgrade Considerations for OpenROAD Releases
    • OpenROAD Application Images Must Be Migrated
    • Upgrading from Release 3.5
    • Upgrading from Release 4.0 or 4.1
    • Upgrading from Release 2006 (5.0)
    • Upgrading from Release 5.1
    • Upgrading from Release 6.0
    • Upgrading from a 32-bit to a 64-bit Release
  • How You Perform the Upgrade
  • Path Notation in This Guide
•  2. Creating a New OpenROAD Environment
  • Overview
  • OpenROAD 6.2 Components
  • New Environment Requirements
  • Alternatives in Establishing a New OpenROAD Environment
•  3. Upgrading from OpenROAD 3.5
  • Overview
  • Summary of the OpenROAD 3.5 Upgrade Process
  •  Phase 1: Prepare for the Upgrade
    • Ensure an Existing 3.5 Test Environment Exists
    • Make a 3.5 Development Environment Available
    • Create a 6.2 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
•  4. Upgrading from OpenROAD 4.0 or 4.1
  • Overview
  • Upgrade Approach
  • Summary of the OpenROAD 4.1 to 5.1 Upgrade Process
  •  Phase 1: Prepare for the Upgrade
    • 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
      • UNIX Installation Error
      • Ingres Result Type Differences
      • Building C Code Containing EXEC SQL Commands
  • Phase 3: Conduct Acceptance Testing
  • Phase 4: Go Live
•  5. Upgrading from OpenROAD 2006 (5.0)
  • Overview
  • Upgrade Approach
  • Summary of the OpenROAD 2006 (5.0) to 5.1 Upgrade Process
  •  Phase 1: Prepare for the Upgrade
    • 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
•  6. Upgrading from OpenROAD 5.1
  • Overview
  • Using OpenROAD 6.2 with Unicode-enabled Databases
  • Switching to a Unicode Environment
  • Upgrade Approach
  • Summary of the OpenROAD 5.1 to 6.2 Upgrade Process
  •  Phase 1: Prepare for the Upgrade
    • 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 6.2 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 6.2 Environment
    • Build and Run the Applications in OpenROAD 6.2
    • 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
•  7. Upgrading from OpenROAD 6.0
  • Overview
  • Using Integer8 Data Types in 3GL Procedures
  • Summary of the OpenROAD 6.0 to 6.2 Upgrade Process
  •  Phase 1: Prepare for the Upgrade
    • Ensure an Existing OpenROAD 6.0 Test Environment Exists
    • Make an OpenROAD 6.0 Development Environment Available
    • Create a 6.2 Test Environment
    • Create a 6.2 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 6.2 Environment
    • Build and Run the Applications in OpenROAD 6.2
    • 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
•  8. Upgrading Applications with the PropertyChanger Utility
  • Overview of PropertyChanger
  • Before You Upgrade 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 Upgrade 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. 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
•  C. 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
•  D. 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

Migration Guide

Documentation Updates