wwparcel.html

Preface
- Purpose
- Audience
- Organization
- Using this manual
- Typographical conventions
- Examples of syntax descriptions
- Example procedures
- OpenEdge messages
Database Access
- Database connections
- Disconnecting databases
- Logical database names
- Database aliases
- Data-handling statements
- Adding and deleting records
- Defining a set of records to fetch
- Fetching records
- Fetching field lists
- Joining tables
- The CONTAINS operator
- Sequences
- Database trigger considerations
  - Storing triggers in an operating system directory
  - Storing triggers in an r-code library
- Using the RAW data type
- Multi-database programming techniques
- Creating schema cache files
Application Security
- Types of application security
- Elements of an application authentication model
- Elements for authenticating ABL user identity
- Authenticating and managing user identity in ABL
- Authorizing access to procedures and database resources
- Using ABL callbacks in authentication systems
- Using cryptography to secure data
Multi-tenant ABL
- Running applications in a multi-tenant database environment
  - Existing applications
  - Super-tenant applications
- Coding for super-tenant access
- Using multi-tenant-enabled sequences
  - Using multi-tenant sequences with shared and group-configured tables
  - Restrictions for using groups and sequences
- Managing access to tables with groups
ABL API for Multi-tenant and Table Partition Management
- Overview of the API
  - API packages, classes, and interfaces
    - Interface naming conventions
    - Creating and accessing objects with the API
  - API entities and entity service methods
- Instantiating a DataAdminService
- Managing the service life cycle
- Managing transactions
  - Table updates that require two transactions
- Maintaining multi-tenant and table partition entities
- Filtering and sorting
  - Filter expressions
  - Filtering on a child collection using the RequestInfo class
    - IRequestInfo interface properties
    - IRequestInfo interface methods
- Exporting and importing
  - Exporting and importing objects as JSON files
  - Exporting tenants and tenant groups as ABL code
- Exporting and Importing Partition Policies and Details
- Executing DataAdminService utilities
- Handling errors
  - Handling data errors with the DataAdminErrorHandler class
  - Controlling data errors with the IDataAdminService interface
    - IDataAminService interface public properties for error handling
    - IDataAminService interface public methods for error handling
- Configuring the sample multi-tenant database
Auditing
- Setting up application security for auditing
- Recording application events
- Developing auditing tools
  - Custom audit configuration tools
  - Custom audit archiving tools
Handling User Input
- The keyboard and the mouse
- Key codes and key labels
- Key functions
- Changing the function of a key
- Using mouse buttons and events
  - Portable and physical buttons
  - Specifying mouse events
    - Portable and three‑button event priority
    - Low‑level and high‑level events
- Telling the AVM how to continue processing
- Monitoring keystrokes during data entry
Alternate I/O Sources
- Understanding input and output
- Changing the output destination
- Changing the input source of a procedure
- Defining additional input/output streams
- Sharing streams among procedures
  - Defining a shared stream
  - Using stream object handles
- Summary of opening and closing streams
- Processes as input and output streams (NT and UNIX only)
  - Portability issues
- I/O redirection for batch jobs
- Reading the contents of a directory
- Performing code-page conversions
- Converting nonstandard input files
  - Importing and exporting data
Colors and Fonts
- Making colors and fonts available to an application
  - OpenEdge default colors
  - OpenEdge default fonts
- Assigning colors and fonts to a widget
- Assigning colors and fonts to ActiveX Automation objects and ActiveX controls
- Color and font inheritance
  - Overriding default color inheritance
- Color in character interfaces
  - Widget states and color
  - Color specification
- Colors in windows in graphical interfaces
  - Systems with the Palette Manager
    - Managing colors for multiple windows
    - Managing colors for bitmap images
  - Systems without the Palette Manager
- Managing colors and fonts in graphical applications
- Allowing the user to change colors and fonts
- Accessing the current color and font tables
  - COLOR–TABLE handle
  - FONT–TABLE handle
- Retrieving and changing color and font definitions
  - Changing resource definitions
    - Portable color and font definitions
  - Using GET–KEY–VALUE and PUT–KEY–VALUE
    - Writing portable color and font definitions
- Managing application environments
- Managing color display limitations
Creating Reports
- Report basics
- Designing an interface for viewing report data
- Converting widget values to report data
  - Printing reports and the STREAM-IO option
  - Formatting long text strings
- Generating reports with control breaks and aggregates
- Generating reports from multiple tables
- Redirecting output
- Designing frames for reports
- Using the PUT statement
  - Using PUT for printer control
- Summary
Introduction to External Program Interfaces
- Using MEMPTR to reference external data
- System clipboard
  - The system clipboard and ABL
  - Requirements for using the CLIPBOARD handle
- Named pipes
  - Named pipes and ABL
  - Requirements for using named pipes
- UNIX shared library and Windows DLL support
  - Shared libraries and ABL
  - Requirements for using shared libraries
- Windows Dynamic Data Exchange
  - DDE and ABL
  - Requirements for using DDE
- COM objects: Automation objects and ActiveX controls
- Sockets
System Clipboard
- CLIPBOARD system handle
- Single-item data transfers
- Multiple-item data transfers
Providing Help for OpenEdge Applications
- Field-level online help
  - Status messages
  - ToolTips
- Online help systems
Named Pipes
- Overview of named pipes with ABL
- UNIX named pipes
- Windows named pipes
Shared Library and DLL Support
- Using shared libraries
- Accessing a shared library entry point
  - Declaring a shared library for static access
    - Options for static access to a shared library routine
    - Windows DLL calling conventions for static access
  - Declaring a shared library for dynamic access
    - Options for dynamic access to a shared library routine
- Passing parameters to a shared library routine
- Executing a shared library routine
- Loading and unloading shared libraries
- Code samples
  - Examples of static access to a shared library
  - Examples of dynamic access to a shared library
Windows Dynamic Data Exchange
- Introduction to DDE
- Using the DDE protocol
  - The course of a DDE conversation
  - ABL statements for DDE conversations
- Structuring a DDE conversation in ABL
  - Conversation hierarchy
- Defining conversation endpoints—DDE frames
  - DDE-ERROR
  - Other DDE attributes
- Opening DDE conversations
- Exchanging data in conversations
  - Demand-driven exchanges
    - Execute exchanges
    - Request and send exchanges
  - Event-driven exchanges
- Closing DDE conversations
- DDE example
Using COM Objects in ABL
- How COM objects differ from ABL widgets
  - Functionality
  - ABL mechanisms
- Obtaining access to COM objects
- Accessing COM object properties and methods
- Managing COM objects in an application
- Locating COM object information on your system
ActiveX Automation Support
- Requirements for doing Automation
- Accessing Automation Servers
- Managing Automation objects
- Automation event support
- Example Automation applications
ActiveX Control Support
- How ABL supports ActiveX controls
- Creating a control instance in ABL
- Orienting a control in the user interface at design time
- Accessing ActiveX controls at runtime
  - Instantiating the control
  - Accessing the control handle
- Managing ActiveX controls at runtime
- Handling events
- Programming ActiveX controls in the AppBuilder
- ActiveX controls and examples installed with ABL
Sockets
- ABL for programming sockets
- Overview of tasks to implement ABL sockets
- Implementing an ABL socket server
  - Listening and responding to connection requests
  - Managing the server socket
- Implementing an ABL socket client
- Read, writing, and managing sockets on clients and servers
- Implementing ABL socket security
- Examples using ABL sockets
Host Language Call Interface
- HLC and OpenEdge
  - Requirements for using HLC
- Using HLC
- Overview of HLC
  - Using the CALL statement
  - Mapping routine identifiers using PRODSP()
- HLC files and directories
- Writing C functions
- Avoiding common HLC errors
- Memory allocation
- Data size
- Using HLC library functions
- Building an HLC executable
- HLC applications on UNIX systems
- Compiling C source files
- Example HLC application
COM Object Data Type Mapping
- Data type conversion strategy
- Conversions from COM to ABL data types
- Conversions from ABL to COM data types
  - ABL to COM data type features and limitations
- Alternate COM data type names
Audit Policy Maintenance APIs
- API overview
  - Reference to API procedure files
  - Using the generic utility and caching APIs with an AppServer
- Generic utility API
- Caching API
- Exporting policies to XML
  - _exp-policies.p
  - _exp-policies-db.p
- Importing policies from XML
- Additional audit policy procedures
HLC Library Function Reference
- Function summary
- Function reference
Command and Utility Reference
- QUOTER utility
Reference
- IAdministrator interface
  - IAdministrator properties
  - IAdministrator methods
  - IAdministrator examples
- IArea interface
  - IArea properties
  - IArea methods
  - IArea examples
    - Creating areas
    - Updating areas used for extents
- IAuthenticationSystem interface
  - IAuthenticationSystem properties
  - IAuthenticationSystem methods
  - IAuthenticationSystem examples
    - Creating an authentication system
    - Updating an existing authentication system
- IDataAdminElement interface
  - IDataAdminElement properties
  - IDataAdminElement methods
  - IDataAdminElement examples
- IDomain interface
  - IDomain properties
  - IDomain methods
  - IDomain examples
- IExtent interface
  - IExtent properties
  - IExtent methods
  - IExtent examples
- IField interface
  - IField properties
  - IField methods
- IFieldPermission interface
  - IFieldPermission properties
  - IFieldPermission methods
  - IFieldPermission examples
- IIndex interface
  - IIndex properties
  - IIndex methods
- IIndexField interface
  - IIndexField properties
- IPartition interface
  - IPartition properties
  - IPartition methods
  - IPartition examples
- ISchema interface
  - ISchema properties
  - ISchema methods
  - ISchema examples
- ISchemaElement interface
  - ISchemaElement properties
  - ISchemaElement methods
- ISequence interface
  - ISequence properties
  - ISequence methods
  - ISequence examples
    - Creating a sequence
    - Setting properties for an existing sequence
- ISequenceValue interface
  - ISequenceValue properties
  - ISequenceValue methods
  - ISequenceValue examples
    - Changing the current value of a sequence for a specific tenant
    - Changing the current value of sequence in a tenant’s sequence collection
- ITable interface
  - ITable properties
  - ITable methods
  - ITable examples
    - Allocating table partitions
    - Managing partitions for a table
- ITablePermission interface
  - ITablePermission properties
  - ITablePermission methods
  - ITablePermission examples
- ITenant interface
  - ITenant properties
  - ITenant methods
  - ITenant examples
- ITenantGroup interface
  - ITenantGroup properties
  - ITenantGroup methods
  - ITenantGroup examples
- IUser interface
  - IUser properties
  - IUser methods
  - IUser examples
    - Creating and editing a user
    - Editing an existing user
- IUserFieldPermission interface
  - IUserFieldPermission properties
  - IUserFieldPermission methods
- IUserPermission interface
  - IUserPermission properties
  - IUserPermission methods
- IUserTablePermission interface
  - IUserTablePermission properties
  - IUserTablePermission methods
- PartitionParent interface
  - IPartitionParent properties
- PartitionOwner interface
  - IPartitionOwner properties
  - IPartitionOwner methods
- PartitionPolicy interface
  - IPartitionPolicy properties
  - IPartitionPolicy methods
  - IPartitionPolicy examples
- PartitionPolicyDetail interface
  - IPartitionPolicyDetail properties
  - IPartitionPolicyDetail methods
  - IPartitionPolicyDetail examples
Database Administration Entity Collection Interface Reference
- Collection interface naming conventions
- Common collection features
- IAreaSet interface
  - IAreaSet properties
  - IAreaSet methods
- IAuthenticationSystemSet interface
  - IAuthenticationSystemSet properties
  - IAuthenticationSystemSet methods
- IDataAdminCollection interface
  - IDataAdminCollection properties
  - IDataAdminCollection methods
- IDomainSet interface
  - IDomainSet properties
  - IDomainSet methods
- IExtentList interface
  - IExtentList properties
  - IExtentList methods
- IFieldPermissionSet interface
  - IFieldPermissionSet properties
  - IFieldPermissionSet methods
- IFieldSet interface
  - IFieldSet properties
  - IFieldSet methods
- IIndexSet interface
  - IIndexSet properties
  - IIndexSet methods
- IIterator interface
  - IIterator methods
  - IIterator s
- IPartitionCollection interface
  - IPartitionCollection properties
  - IPartitionCollection methods
- IPartitionMap interface
  - IPartitionMap properties
  - IPartitionMap methods
- ISchemaPartitionMap interface
  - ISchemaPartitionMap properties
  - ISchemaPartitionMap methods
- ISequenceSet interface
  - ISequenceSet properties
  - ISequenceSet methods
- ISequenceValueMap interface
  - ISequenceValueMap properties
  - ISequenceValueMap methods
- ITablePermissionSet interface
  - ITablePermissionSet properties
  - ITablePermissionSet methods
- ITableSet interface
  - ITableSet properties
  - ITableSet methods
- ITenantGroupSet interface
  - ITenantGroupSet properties
  - ITenantGroupSet methods
- ITenantSet interface
  - ITenantSet properties
  - ITenantSet methods
- IUserFieldPermissionSet interface
  - IUserFieldPermissionSet properties
  - IUserFieldPermissionSet methods
- IUserPermissionSet interface
  - IUserPermissionSet properties
  - IUserPermissionSet methods
- IUserSet interface
  - IUserSet properties
  - IUserSet methods
- IUserTablePermissionSet interface
  - IUserTablePermissionSet properties
  - IUserTablePermissionSet methods
- PartitionPolicySet interface
  - IPartionPolicySet properties
  - IPartionPolicySet methods
- PartitionPolicyDetailSet interface
  - IPartionPolicyDetailSet properties
  - IPartionPolicyDetailSet methods