• Migration Guide
•  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
•  Creating a New OpenROAD Environment
  • Overview
  • OpenROAD 6.2 Components
  • New Environment Requirements
  • Alternatives in Establishing a New OpenROAD Environment
•  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
•  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
•  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
•  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
•  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
•  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
•  E. 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
    • 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

Migration Guide

Workbench Classic Deprecated