Omnis Command Reference
Omnis Command Reference
About this Manual
Command Groups
Obsolete Commands
Command Filters
Client Commands
Error Codes
Commands A-Z
# Comment
Accept advise requests
Accept commands
Accept field requests
Accept field values
Add line to list
Advise on find/next/previous
Advise on OK
Advise on redraw
AND selected and saved
Begin critical block
Begin print job
Begin reversible block
Begin statement
Begin text block
Break to end of loop
Break to end of switch
Breakpoint
Bring window instance to front
Build export format list
Build externals list
Build field names list
Build file list
Build indexes
Build installed menu list
Build list columns list
Build list from file
Build menu list
Build open window list
Build report list
Build search list
Build window list
Omnis Studio External Com
Omnis Studio External Components
About This Manual
Chapter 1—Omnis External Components
Introduction
Creating your own External Components
Components in Omnis
Windows and Child Windows
Data types Defined by the Component Library
Types of visual components
Types of non-visual components
Writing Thread-Safe Components
Source Files on the Omnis web site
Getting Started with Generic
Setting up your development tree
Moving On From Generic
General Hints
Creating Non-Visual Components
Static Functions
Class Objects
Control Handlers
Background Components
ECM_OBJCONSTRUCT
ECM_CONNECT
ECM_PRINT
Web Client Components
Chapter 2—Structures, Messages & Functions
Structures
ECOmethodEvent (for methods)
ECOmethodEvent (for events)
ECOproperty
EXTclipType
EXTCompInfo
EXTParamInfo
EXTParamTypeInfo (v3.1)
EXTSerialise (v3.1)
Flags
EXTD_OBJFLAG_xxx
EXTD_OBJFLAG_SINGLE_NOTIFY
EXTD_OBJFLAG_WORKER
EXTD_EFLAG_xxx
EXTD_EFLAG_REPFONT
EXTD_EFLAG_MVDBUTTON
EXTD_EFLAG_LISTDATEFORMATCUSTOM
EXTD_EFLAG_LISTNUMBERFORMAT
EXTD_EFLAG_ISDATANAME
EXTD_EFLAG_NOEXPORT
EXTD_EFLAG_REPORT_MEASURE
EXTD_EFLAG_EXT_PROPERTIES_CRB
EXTD_FLAG_xxx
EXTD_FLAG_BUTTON
EXTD_FLAG_EDITRONLY
EXTD_FLAG_ENUM
EXTD_FLAG_EXTCONSTANT
EXTD_FLAG_FAR_SRCH
EXTD_FLAG_FONTPROP
EXTD_FLAG_HIDDEN
EXTD_FLAG_INTCONSTANT
EXTD_FLAG_PARAMALTER
EXTD_FLAG_PARAMOPT
EXTD_FLAG_PRIMEDATA
EXTD_FLAG_PROPACT
EXTD_FLAG_PROPAPP
EXTD_FLAG_PROPCOLS
EXTD_FLAG_PROPCUSTOM
EXTD_FLAG_PROPDATA
EXTD_FLAG_PROPGENERAL
EXTD_FLAG_PROPGRP1
EXTD_FLAG_PROPJAVA
EXTD_FLAG_PROPPREFS
EXTD_FLAG_PROPPANE
EXTD_FLAG_PROPSECTIONS
EXTD_FLAG_PROPTEXT
EXTD_FLAG_PWINDCOL
EXTD_FLAG_PWINDCOL256
EXTD_FLAG_PWINDCURSOR (v3.1)
EXTD_FLAG_PWINDFSTYLE
EXTD_FLAG_PWINDICON
EXTD_FLAG_PWINDLSTYLE
EXTD_FLAG_PWINDMLINE
EXTD_FLAG_PWINDPAT
EXTD_FLAG_PWINDSET
EXTD_FLAG_PWINDTYPE
EXTD_FLAG_RUNTIMEONLY
EXTD_FLAG_SECTIONS
EXTD_FLAG_SINGLESEL
EXTD_FLAG_STATEONLY
EXTD_FLAG_SUPPRESS
General Messages
ECM_ADDTOPRINTJOB
ECM_BOBJ_EXERASE
ECM_CANADDTOPRINTJOB
ECM_CANCLICK (Web Client 1.0)
ECM_CANFOCUS (Web Client 1.0)
ECM_CANSHOWSYSTEMFOCUS (V3.2)
ECM_CMPPRIMARYDATA
ECM_COMPONENTCMD
ECM_CONNECT
ECM_CONSTPREFIX
ECM_CONVFROMHPIXMAP (Studio 2.1)
ECM_CONVHEADER (Studio 2.1)
ECM_CONVTOHPIXMAP (Studio 2.1)
ECM_CUSTOMTABNAME
ECM_DEBUGGING
ECM_DISCONNECT
ECM_EVENTRESULT (Web Client 1.0)
ECM_FMT_CANASSIGN
ECM_FMT_GETPROPERTY
ECM_FMT_SETPROPERTY
ECM_GETCOMPICON
ECM_GETCOMPID
ECM_GETCOMPLIBINFO
ECM_GETCOMPSTOREGROUP (Studio 2.1)
ECM_GETCOMPSTOREICON (Studio 2.1)
ECM_GETCONSTNAME
ECM_GETEVENTMETHOD
ECM_GETEVENTNAME
ECM_GETHANDLERICON
ECM_GETMETHODNAME
ECM_GETOBJECT
ECM_GETOBJECTRECT
ECM_GETPICTFILEDESC (Studio 2.1)
ECM_GETPICTFORMAT (Studio 2.1)
ECM_GETPICTUREDIM
ECM_GETPRIMARYDATA
ECM_GETPRIMARYDATALEN
ECM_GETPROPERTY
ECM_GETPROPERTYENUMS
ECM_GETPROPNAME
ECM_GETSTATICOBJECT
ECM_GETVERSION
ECM_HASPRIMARYDATACHANGED (Web Client V1.0)
ECM_ICONDRAWENTRY
ECM_INBUILT_OVERRIDE
ECM_INSTALLLIBRARY
ECM_ISCONVFORMAT (Studio 2.1)
ECM_LISTDRAWLINE
ECM_MEMORYDELETION
ECM_METHODCALL
ECM_NEWMETHODFLAGS
ECM_NEWPROPERTYFLAGS
ECM_OBJCONSTRUCT
ECM_OBJDESTRUCT
ECM_OBJECTDATABLOCK
ECM_OBJECT_COPY
ECM_OBJECT_REBUILD
ECM_OBJINITIALIZE
ECM_PAINTCONTENTS
ECM_PRIMARYDATACHANGE
ECM_PRINT
ECM_PRINTMAPPING
ECM_PROPERTYCALCTYPE
ECM_PROPERTYCANASSIGN
ECM_SETPRIMARYDATA
ECM_SETPROPERTY
ECM_SQLOBJECT_COPY (v3.1)
ECM_TEXTDRAWENTRY
WM_CONTROL Messages
DESKTOP_MENU_ENABLED
DRAW_DESIGN_NAME
DRAW_MULTIDESIGN_KNOBS
DRAW_NUMBER
GET_MENUHANDLE (Windows only)
GET_OMNIS_HPALETTE (Windows only)
HAS_FOCUS
HIDE_TOOLTIP
IS_FLD_EDITABLE
IS_IN_DESIGN
IS_MULTISELECTED
IS_OMNIS_IN_BUILDMODE
IS_SELECTED
IS_SERIALISED (v3.1)
IS_SETUP
IS_SHOWNUMBER
IS_WINDOW_TOP
LIST_SETLINEHEIGHT
OMNIS_IN_BACKGROUND
PICTURE_ERASEBKGROUND
PICTURE_UPDSCROLLRANGE
RESET_METHOD_FLAGS
RESET_PROPERTY_FLAGS
SET_EDITMENU
SET_PALETTE
SET_STATUSBAR_TEXT
SET_TOOLGRPS_VISIBLE
SET_WINDOWS_VISIBLE
SETNOERASEFORPICTURES
UPDATE_PROPINSPECTOR
General Functions
ECOaddParam()
ECOaddTraceLine()
ECOcanSendEvent() (web client only)
ECOclipboardGetPicture() (v2.4)
ECOclipboardGetPictureEx() (v5.1)
ECOclipboardGetText() (v2.4)
ECOclipboardHasFormat() (v3.1)
ECOclipboardSetPicture() (v3.1)
ECOclipboardSetText() (v2.4)
ECOconvertHFSToPosix() (v3.3)
ECOconvertPosixToHFS() (v3.3)
ECOconvKnownJavaObjs() (v4.2)
ECOdoMethod()
ECOdoMethodECI()
ECOdrawDesignName()
ECOdrawMultiKnobs()
ECOdrawNumber()
ECOexcludeToolTipRect()
ECOfindObject()
ECOfindNVObject()
ECOfindParamNum()
ECOfindString() (v5.0)
ECOgetApp()
ECOgetBundleRef() (v3.1) Mac OSX only
ECOgetCrbFieldInfo() (V2.2)
ECOgetDeviceParms()
ECOgetDirectoryDialog()
ECOgetFont()
ECOgetFont()
ECOgetFontIndex()
ECOgetId()
ECOgetLocalIpAddress() (v4.3)
ECOgetNVObject() (v3.3)
ECOgetOmnisVersionNumber() (v5.1.1)
ECOgetParamCount()
ECOgetParamInfo() (v3.1)
ECOgetProperty()
ECOgetStyle()
ECOgetToolTipRect()
ECOhasFocus()
ECOhideTooltip()
ECOinsertObject()
ECOinsertNVObject()
ECOinvalBackObj() (v3.1)
ECOisDesign()
ECOisMultiSelected()
ECOisOMNISinTrueRuntime()
ECOisSelected()
ECOisSerialised()
ECOisSetup()
ECOisShowNumber()
ECOisWndTop()
ECOlistFonts()
ECOlistSetLineHeight()
ECOloadFileDialog()
ECOmapString() (v5.0)
ECOmemoryDeletion()
ECOmessageBox() (v3.3)
ECOpaintGrayFrame() (v5.0)
ECOreadLocalisationItem()
ECOreloadLibData() (v4.1)
ECOremoveObject()
ECOremoveNVObject()
ECOresetObjDetails()
ECOreturnCompID()
ECOreturnCompInfo()
ECOreturnConstants()
ECOreturnCStoreGrpName()
ECOreturnEventMethod()
ECOreturnEventMethod()
ECOreturnEvents()
ECOreturnIcon()
ECOreturnMethodEvents
ECOreturnMethods()
ECOreturnObjects()
ECOreturnProperties()
ECOreturnVersion()
ECOreturnVersion() (Web Client 1.2)
ECOsendCompEvent()
ECOsendEvent()
ECOsetCustomTabName()
ECOsetDTformat()
ECOsetError()
ECOsetParameterChanged()
ECOsetProperty()
ECOsetupCallbacks()
ECOupdatePropInsp()
ECOuprCmp() (v5.1)
WNDdefWindowProc()
Memory Functions
MEMcalloc()
MEMdataLen()
MEMdecAddr()
MEMfree()
MEMglobalAlloc()
MEMglobalFree()
MEMglobalHandle()
MEMglobalLock()
MEMglobalReAlloc()
MEMglobalSize()
MEMglobalUnlock()
MEMincAddr()
MEMmalloc()
MEMmemcmp()
MEMmemFill()
MEMmovel()
MEMmover()
MEMrealloc()
MEMscanf()
HANglobalAlloc()
HANglobalReAlloc()
HANglobalSize()
HANglobalFree()
qHandlePtr Class
qHandlePtr::qHandlePtr
qHandlePtr::qHandlePtr()
qHandlePtr::qHandlePtr()
qHandlePtr::operator =()
qHandlePtr::operator =()
qHandlePtr::operator +=()
qHandlePtr::operator -=()
qHandlePtr::operator +()
qHandlePtr::operator -()
qHandlePtr::operator !()
qHandlePtr::operator *()
qHandlePtr::operator *()
qHandlePtr::operator []()
qHandlePtr::dataLen()
qHandlePtr::dataLen()
qHandlePtr::getOffset()
qHandlePtr::getHandle()
qHandlePtr::set()
qHandlePtr::setOffset()
qHandlePtr::setNull()
Resource Functions
REScloseLibrary()
REScloseResourceFork() (MacOS only)
RESloadBitmap()
RESloadDialog()
RESloadString()
RESloadString()
RESopenLibrary()
RESopenResourceFork() (MacOS only)
Bit Functions
bitClear()
bitSet()
bitSet()
bitTest()
ObjInst Functions
EXTobjinst()
EXTobjinst()
EXTobjinst()
Chapter 3—strxxx Class Reference
Member Functions strxxx Class
strxxx::strxxx()
strxxx::assign()
strxxx::compare()
strxxx::concat()
strxxx::concat()
strxxx::concat()
strxxx::copy()
strxxx::cString()
strxxx::deleet()
strxxx::insert()
strxxx::insert()
strxxx::insertStr()
strxxx::insertStr0()
strxxx::length()
strxxx::maxLength()
strxxx::operator !()
strxxx::operator != ()
strxxx::operator [ ]()
strxxx::operator <()
strxxx::operator <=()
strxxx::operator =()
strxxx::operator =(qniltype qnil)
strxxx::operator ==()
strxxx::operator >()
strxxx::operator >=()
strxxx::pos()
strxxx::pos()
strxxx::pString()
strxxx::repWith0()
strxxx::upps()
strxxx::uprCmp()
Member Functions str15 Class
str15::str15()
str15::str15()
str15::str15()
str15::str15()
str15::str15()
str15::str15()
Member Functions str80 Class
str80::str80()
str80::str80()
str80::str80()
str80::str80()
str80::str80()
str80::str80()
Member Functions str255 Class
str255::str255()
str255::str255()
str255::str255()
str255::str255()
str255::str255()
str255::str255()
Other Functions
qlongToString()
qrealToString()
stringToQlong()
stringToQreal()
lowC()
uppC()
uppC()
uprCmp()
Chapter 4—Unicode Character Conversion
Introduction
Unicode Data Types
qchar
qoschar
qbyte
Utility Classes
CHRconvToOs
CHRconvFromOs
CHRconvToAscii
CHRunicode
CHRconvToUtf16
CHRconvFromUtf16
CHRconvToBytes
CHRconvFromBytes
CHRconvFromLatin1ApiBytes
CHRconvToLatin1ApiBytes
CHRconvToEncodedCharacters
CHRconvFromEncodedCharacters
CHRconvToOmnis
CHRconvFromOmnis
CHRconvToUniChar
CHRconvFromCodePage
CHRconvToCodePage
CHRconvFromUnicodeEncoding
CHRconvToUnicodeEncoding
CHRconvToUtf32FromChar
CHRconvFromUtf32ToChar
Other Functions
OMstr… Functions
QTEXT() Macro
QCHARLEN() and QOSCHARLEN() Macros
QBYTELEN() and QOSBYTELEN() Macros
Chapter 5—EXTBMPref & EXTCURref
Introdcution
Enumerations
ePicModes (EXTBMPref only)
ePicSize (EXTBMPref only)
EXTBMPref Class Reference
EXTBMPref::EXTBMPref()
EXTBMPref::~EXTBMPref()
EXTBMPref::addBmpSize()
EXTBMPref::copyImage()
EXTBMPref::copyImage()
EXTBMPref::copyMask()
EXTBMPref::draw()
EXTBMPref::drawMask()
EXTBMPref::getBmpSize()
EXTBMPref::getIconId()
EXTBMPref::getRect()
EXTBMPref::hasMode()
EXTBMPref::hasSize()
EXTBMPref::transparentColor()
EXTCURref Class Reference (v2.2)
EXTCURref::EXTCURref()
EXTCURref::~EXTCURref()
EXTCURref::getCursor()
EXTCURref::getCursorId()
Chapter 6—qkey Reference
Introduction
Enumerations
qkey Class Reference
qkey::qkey()
qkey::qkey()
qkey::qkey()
qkey::qkey()
qkey::getPChar()
qkey::getVChar()
qkey::isAlt()
qkey::isControl()
qkey::isShift()
qkey::operator !()
qkey::operator !=()
qkey::operator ==()
qkey::uppc()
Other Functions
isShift()
isAlt()
Omnis Programming
Omnis Programming
About This Manual
If you are new to Omnis Studio
Chapter 1—The Omnis Environment
Studio Browser
Search Filter
Developer Hub
Libraries in the Studio Browser
Color Themes and Appearance
Exporting & Importing Custom Themes
Window Frame Themes
Appearance Property
Appearance and Theme Files
Appearance Configuration File Contents
Appearance Subgroups
Changing and Testing Colors
Platform Specific Notes
Window Frame Appearance on Windows
App Builder
Creating a New Library
Creating an app from your Database
Omnis Preferences
Environment Font Size
Omnis Configuration
Template Configuration File
IDE Animation
Configuration File Methods
Studio Toolbars and Menus
Windows
macOS
Standard toolbar
View toolbar
Tools toolbar
Desktop toolbar
Omnis Menu Bar
Tools menu
Context Menus
Class Context Menu
Variable Context menus
Find and Replace
Regular Expressions
Find Log sorting & searching
Renaming objects
Component Store
Property Manager
Property Filter
Property Search
Save Window Setup
Property Descriptions
Copying Properties
Show Property Context Menu
Dragging methods from the Property Manager
Notation Inspector
Finding the notation for an object
Dragging notation from the Notation Inspector
Code Assistant
Catalog
Dragging items from the Catalog
SQL Browser
Creating and Editing a Session
Opening a session and accessing your data
SQL Query Builder
SQL Query Builder window
Creating a Query
Running a Query
Saving a Query
Deleting a Query
Query Reports
Query Info
Options
Creating a Query Class
Creating a Table class
Exporting Data
Creating a Statement Block
SQL Query Builder App
Version Control System
Auto Updates
Update Feedback
Example
External Class Editor
Omnis Help
Code Signed Omnis (macOS)
Firstruninstall and Application Support folders
Updating Components
Deployment
Patching a signed tree
Update Manifest Files (macOS)
Omnis data folder
Chapter 2—Libraries and Classes
Omnis Libraries
Library Conversion
Library Properties
Library Default name
Multi-library Projects
Omnis VCS
Comparing Classes
Shared Access to Libraries on macOS
Default Classes
The Startup task
System Classes
Class Types
Class Templates and Wizards
New Class templates
Class Wizards
Data Classes and Wizards
Accessing SQL databases
Data type mapping
Omnis Datafiles
Omnis Data Types
Character
National
Number
Boolean
Date time
Sequence
Picture
List
Row
Object
Object reference
Binary
Item reference
Field reference
Nulls and empty values
Formatting strings and input masks
Current Record Buffer
Schema classes
Creating schema classes automatically
Query Classes
Table Classes
Exporting Libraries to JSON
Exporting Libraries
Importing Libraries
Directory and JSON File Structure
Library Dependencies
External File classes & Tokenization
Export & Import JSON Notation
Export & Import JSON Preferences
Chapter 3—Omnis Programming
Variables
Declaration and Scope
Parameter Variables
Local Variables
Instance Variables
Class Variables
Task Variables
Hash Variables
Adding a Variable
Variable Initial Values
Viewing Variables in the Catalog
Auto Fill Variable Option
Custom Variable Types
Comparing Variables
Methods
Commands
The Flag (#F)
Notation
Do Command and Executing Methods
Calculate Command and Evaluating Expressions
Calling Methods
Quitting Methods
Flow Control Commands
Reversible Blocks
Error Handling
Redrawing Objects
Message Boxes
Events
Event Handling Methods
Mouse Events
Discarding Events
Window Events
Key events
Control Methods and Passing Events
Container Fields and Events
Queuing Events
Using Tasks
Default and Startup Tasks
Creating Task Classes
Opening Tasks
Current and Active Tasks
Closing Tasks
Task Variables
Private Instances
Private Libraries
Multiple Tasks
Preferences on macOS
External Component Notation
Debugging errors in the OCX handler
Chapter 4—Debugging Methods
Inserting and Editing Methods
Maximum Number of Methods
Line Numbers
Showing Inherited Methods First
Adding Blank Method Lines
Method Notes
Code Editor
Tokenization
Fonts
Ctrl-space
Multi Undo and Redo
Read-only Mode
Entering Commands
Menus and Keyboard Shortcuts
Keyboard Shortcuts
Language Syntax
Library Conversion
Syntax Coloring
JavaScript: Editor
Trace Log
Error Processing
Dynamic Methods & Objects
Code Assistant
Shortcut Keys and Help
What Help does the Code Assistant Provide?
Debugging Methods
The Go Point
Execution Errors
Stepping through a Method
Tracing a Method
Private Methods
Method History
Inspecting Variable Values
Variable Menu
Variable Panel
The Values List
Displaying Control Characters
Watching Variable Values
Breakpoints
Breaking on Variable Change
Breaking on Calculation
The Method Stack
Method stack list
Debugger Options
Debugger Commands
Checking Methods
Interpreting Errors and Warnings
Method Performance
Collecting Performance Data
Sequence Logging
Remote Debugger
Connectivity
Preparing Code For Remote Debugging
Remote Debugger Interface
Chapter 5—Object Oriented Programming
Inheritance
Making a Subclass
Overloading Properties, Methods, and Variables
Inheritance Tree
Showing Superclasses in the Studio Browser
Inheritance Notation
Custom Properties and Methods
Using Custom Methods
Object Classes
Using Object Classes
Libraryname prefix for object variables
Dynamic Object Instances
Self-contained Object Instances
Object References
Constructing new objects
Listing instances created using an Object reference
Destructing objects
Testing an object reference for validity
Copying an object reference
External Objects
Using External Objects
External Object Events
External Object Notation
Interface Manager
Dragging methods from the Interface Manager
Chapter 6—List Programming
Declaring List or Row Variables
Lists in the JavaScript Client
Defining List or Row Variables
Defining Lists from Variables
Defining Lists and Rows from SQL Classes
Defining Lists using SQL Workers
Defining Lists from File classes
List/Row subtypes
Adding columns
Building List Variables
Building a List from SQL Data
Viewing the contents of a list variable
List Variable Values
List and Row functions
The
list()
Function
The
row()
Function
Accessing List Columns and Rows
List Variable Notation
List Properties and Methods
Properties and Methods of a List Column
Properties and Methods of a List Row
Properties of a List Cell
Manipulating Lists
Dynamic List Redefinition
Clearing List Data
Searching Lists
Selecting List Lines
Merging Lists
Sorting Lists
Removing Duplicate Values
Smart Lists
Smart Lists and the JavaScript Client
Enabling Smart List Behavior
The History List
Properties of the History List
Properties of Rows in the History List
Tracking the Changes
Change Tracking Methods
Filtering
Sorting smart lists
Committing Changes to the Server
List Commands and Smart Lists
Chapter 7—SQL Programming
Overview
Setting up a Database Connection
Clientware
64-bit DAMs
INI files under macOS
Connecting to your Database
Creating a Session Object
Logging on to a Session Object
Logging Off from a Session Object
Interacting with your Server
Creating a Statement Object
Mapping the Data
Sending SQL to the Server
Fetching Results
Describing Results
Substituting Variables Into SQL Commands
Bind Variables
Constructing SQL Queries From Row Variables
Table and Column names
SQL Errors
Data Type Mapping
Clearing Statements and Sessions
Listing Database Objects
Listing Tables and Views
Listing Columns
Listing Indexes
Building Schema Classes
Defining Lists from Server Tables
Remote Procedures
Listing Remote Procedures
Listing Remote Procedure Parameters
Calling a Remote Procedure
Transactions
Transaction Modes
Cursor Results Sets
Non-Unicode Compatibility
Switching to 8-bit compatibility mode
Handling Extended Characters
Interpreting 8-bit Data
Server Specific Programming
Stripping Spaces
Treatment of Date Values
Large Objects
Blob Size
Chunking Large Objects
Session Pools
Creating a Session Pool
Obtaining a Session Instance From a Pool
Session Pool Notation
Destroying a Session Pool
Diagnosing Problems
Session and Statement Properties and Methods
SQL Multi-tasking and SQL Workers
Overview
SQL Worker Object Methods
SQL Worker Object Properties
Creating SQL Worker Objects
How SQL Worker Objects work
Additional Notifications
SQL Worker Lists
Using a Worker in a SQL List or Row
Selecting & Fetching Data
Inserts, Updates and Deletes
Smart List Methods
Completion Row
Chapter 8—SQL Classes and Notation
Schema Classes
Schema Class Notation
List/Row subtypes
Make Schema from Server Table
Query Classes
Calculated Columns
Query Class Notation
Table Classes
Table Class Notation
Table Instances
Passing Parameters to a Table instance
Adding Columns to a SQL List
Table Instance Notation
Table Instance Methods
SQL Classes and Sessions
Table Class Methods and Sessions
Chapter 9—Server-Specific Programming
Server and Clientware Compatibility
64-bit DAMs
Oracle
Properties and Methods
Connecting to your Database
Mixing Unicode and Non-Unicode Data Types
Insertion/Update of CHAR and VARCHAR2 data
Insertion/Update of CLOB data
Fetching Very Large Objects
Insertion/Update of LONG data
PL/SQL
Positioned Updates and Deletes
Oracle 8 Data types
Oracle 9i Data types
Retrieving XML and URI data
Inserting XML and URI data
Updating XML and URI data
Oracle Data Type Mapping
Oracle Troubleshooting
Sybase
Properties and Methods
Connecting to your Database
Multiple Select Tables
Program Name
Error Handling
Large Objects (LOBs)
Remote Procedure Calls
Multiple Cursors
Meta-Data Queries
Logon Problems using the SYBASEDAM
Sybase Troubleshooting
Sybase Data Type Mapping
DB2
Properties and Methods
Connecting to your Database
Transactions
Dates
Boolean Type
BLOB Type
Meta-Data Queries
DB2 Troubleshooting
DB2 Data Type Mapping
MySQL
Properties and Methods
Logging on to MySQL
Transactions
MySQL Data Type Mapping
MySQL Troubleshooting
PostgreSQL
PostgreSQL Client Libraries
Properties and Methods
Logging on to PostgreSQL
Metadata Functions
Transactions
Remote Procedure Calls
Notification Channels
Handling Dates
UUID, ENUM and XML Column Types
Large Object Support
JSON Column Types
PostgreSQL Data Type Mapping
PostgreSQL Troubleshooting
SQLite
Server-specific Programming
SQLite Encryption
Session Properties
Session Methods
Data Type Mapping
Troubleshooting
ODBC
Properties and Methods
Connecting to your Database
Transactions
Dates
Multiple cursors
SQL Server 2000 Data Types
ODBC Administration
ODBC Troubleshooting
ODBC Data Type Mapping
JDBC
Minimum Requirements
Properties and Methods
Connecting to your Database
Transactions
Dates
Multiple cursors
JDBC Data Type Mapping
Amazon SimpleDB DAM
Dependencies
Logging on to SimpleDB
Meta Data
SimpleDB Attributes and Multi-Values
Creating a Domain
Inserting Data
Deleting Data
Replacing Data
Fetching Data
Machine Utilization
Read Consistency
Conditional Puts and Deletes
Session Properties
Session Methods
Statement Properties
Statement Methods
Implementation Notes
Chapter 10—Report Programming
Report Fields and Sections
Report Wizard
Report Tools
Zoom In/Out
Report Sections
Page Headers and Footers
Printing Sections as Record Sections
Borders and shading
Watermarks
Section Positioning
Page Mode
Start Mode
Record Spacing
Position Sections
Section Print Height
Section Calculations
Custom Sections
Hiding Sections in design mode
Sorting and Subtotaling
Subtotal Sections
Calculated Fields
Printing Reports
Report Destination Dialog
Printer Report Destination
Page Preview Destination
Screen Report Destination
Disk Report Destination
Clipboard Report Destination
Port Destination
File Report Destination
RTF Report Destination
HTML Report Destination
PDF Report Destination
Memory Report Device
DDE/Publisher Device (Obsolete)
Printing Errors
Tabs in Reports
Using style() in Reports
Report and Field Methods
Print Devices and the Current Device
Print Devices
Global Printing Preferences
Report Instances
Page Setup Report instance properties
Printing a report from a list
Screen Report Fields
Report Field and Section Methods
Report Object Positioning
Page layout
Inheriting Sections
Report Fonts
Unknown macOS Fonts
Report Text Labels
Port Profiles
Port Profile Management
Port Profiles at Runtime
Printer Escapes
Labels
HTML Report Device
Setting the HTML Device Parameters
Sending Text or Data
HTML Report Objects