Preface
  Document Conventions
   Typographic Conventions
   Notes and Warnings
  Who Should Use This Book
  How This Book is Structured
  Related Information
  How to Read the Syntax Diagrams
  Getting Help and Submitting Feedback
   The Open Object Rexx SourceForge Site
   The Rexx Language Association Mailing List
   comp.lang.rexx Newsgroup
 Brief Overview
  Getting Started
   Command Line Shell
  Definition of Terms
   Database Name
   Handle
   Threading Mode
  Common Concepts
   Embedded
   Database Engine
  SQLite Features
 The Object Orientated Interface to SQLite
 Primary ooSQLite Classes
  The ooSQLite Class
   Method Table
   null (Attribute)
   recordFormat (Attribute)
   compileOptionGet
   compileOptionUsed
   complete
   enquote
   errStr
   libVersion
   libVersionNumber
   memoryHighWater
   memoryUsed
   releaseMemory
   softHeapLimit64
   sourceID
   sqlite3Version
   status
   threadSafe
   version
  The ooSQLiteBackup Class
   Method Table
   new (Class method)
   finished (Attribute)
   initCode (Attribute)
   lastErrCode (Attribute)
   lastErrMsg (Attribute)
   pageCount (Attribute)
   remaining (Attribute)
   saveDestConn (Attribute)
   finish
   getDestConn
   step
  The ooSQLiteConnection Class
   Method Table
   new (Class method)
   backupDestination (Attribute)
   closed (Attribute)
   fileName (Attribute)
   initCode (Attribute)
   lastErrCode (Attribute)
   lastErrMsg (Attribute)
   null (Attribute)
   recordFormat (Attribute)
   busyHandler
    busyCallBack
   busyTimeOut
   changes
   close
   commitHook
    commitHookCallBack
   createCollation
   createFunction
   dbFileName
   dbMutex
   dbReadOnly
   dbReleaseMemory
   dbStatus
   errCode
   errMsg
   exec
    execCallBack
   extendedErrCode
   extendedResultCodes
   getAutocommit
   interrupt
   lastInsertRowID
   limit
   nextStmt
   profile
    profileCallBack
   progressHandler
    progressCallBack
   pragma
   rollbackHook
    rollbackHookCallBack
   setAuthorizer
    authorizerCallBack
   tableColumnMetadata
   totalChanges
   trace
    traceCallBack
   updateHook
    updateHookCallBack
  The ooSQLiteMutex Class
   Method Table
   new (Class method)
   closed (Attribute)
   isNull (Attribute)
   enter
   free
   leave
   try
  The ooSQLiteStmt Class
   Method Table
   new (Class method)
   initCode (Attribute)
   finalized (Attribute)
   lastErrCode (Attribute)
   lastErrMsg (Attribute)
   null (Attribute)
   recordFormat (Attribute)
   bindBlob
   bindDouble
   bindInt
   bindInt64
   bindNull
   bindParameterCount
   bindParameterIndex
   bindParameterName
   bindText
   bindValue
   bindZeroBlob
   clearBindings
   columnBlob
   columnBytes
   columnCount
   columnDataBaseName
   columnDeclType
   columnDouble
   columnIndex
   columnInt
   columnInt64
   columnName
   columnOriginName
   columnTableName
   columnText
   columnType
   columnValue
   dataCount
   dbHandle
   finalize
   reset
   step
   stmtBusy
   stmtReadonly
   stmtStatus
   value
 User Defined Extension Classes
  The ooSQLCollation Class
   new (Class method)
  The ooSQLCollationNeeded Class
   new (Class method)
  The ooSQLExtensions Class
   Method Table
   lastErrCode (Attribute)
   lastErrMsg (Attribute)
   autoBuiltin (Class method)
   autoCollationNeeded (Class method)
   autoCollation
   autoFunction
   autoPackage
   cancelAutoBuiltin
   getLibrary
   getPackage
   listBuiltins
   loadLibrary
   loadPackage
   resetAutoBuiltin
   registerBuiltin
  The ooSQLFunction Class
   new (Class method)
  The ooSQLLibrary Class
   Method Table
   new (Class method)
   lastErrCode (Attribute)
   lastErrMsg (Attribute)
  The ooSQLPackage Class
   Method Table
   new (Class method)
   lastErrCode (Attribute)
   lastErrMsg (Attribute)
   getCollation
   getCollationNeeded
   getFunction
   register
  The ooSQLResult Class
   Method Table
   blob (Class method)
  The ooSQLValue Class
   Method Table
   blob (Class method)
 The ooSQLite Constants
  All Constants Table
  Compile Time Version Constants
  ooSQLite Specific Constants
  ooSQLite Specific Result Code Constants
  Result Code Constants
  File Open Constants
  Authorizer Action Constants
  Authorizer Return Code Constants
  xAccess VFS Method Constants
  Checkpoint Operation Parameter Constants
  Configuration Option Constants
  DB Connection Configuration Constants
  DB Status Parameter Constants
  File Control Opcode Constants
  Fundamental Datatype Constants
  Device Characteristic Constants
  Run-Time Limit Constants
  File Locking Constants
  Mutex Type Constants
  xShmLock VFS Constants
  Destructor Behavior Constants
  Status Parameter Constants
  Status Parameter (stmt) Constants
  Synchronization Constants
  Text Encoding Constants
  Virtual Table Config Option Constants
  merge (Class method)
 The Classic Rexx Interface to SQLite
  Online Backup Feature
 ooSQLite Specific Functions
  ooSQLiteEnquote
  ooSQLiteMerge
  ooSQLiteRegisterBuiltin
  ooSQLiteVersion
 ooSQLite Functions A - F
  oosqlAutoExtension
  oosqlBackupFinish
  oosqlBackupInit
  oosqlBackupPageCount
  oosqlBackupRemaining
  oosqlBackupStep
  oosqlBindBlob
  oosqlBindDouble
  oosqlBindInt
  oosqlBindInt64
  oosqlBindNull
  oosqlBindParameterCount
  oosqlBindParameterIndex
  oosqlBindParameterName
  oosqlBindText
  oosqlBindValue
  oosqlBindZeroBlob
  oosqlBusyHandler
  oosqlBusyTimeOut
  oosqlCancelAutoBuiltin
  oosqlChanges
  oosqlClearBindings
  oosqlClose
  oosqlColumnBlob
  oosqlColumnBytes
  oosqlColumnCount
  oosqlColumnDatabaseName
  oosqlColumnDeclType
  oosqlColumnDouble
  oosqlColumnIndex
  oosqlColumnInt
  oosqlColumnInt64
  oosqlColumnName
  oosqlColumnOriginName
  oosqlColumnTableName
  oosqlColumnText
  oosqlColumnType
  oosqlColumnValue
  oosqlCollationNeeded
  oosqlCommitHook
  oosqlCompileOptionGet
  oosqlCompileOptionUsed
  oosqlComplete
  oosqlCreateCollation
  oosqlCreateFunction
  oosqlDataCount
  oosqlDbFileName
  oosqlDbHandle
  oosqlDbMutex
  oosqlDbReadOnly
  oosqlDbReleaseMemory
  oosqlDbStatus
  oosqlEnableLoadExtension
  oosqlErrCode
  oosqlErrMsg
  oosqlErrStr
  oosqlExec
  oosqlExtendedErrCode
  oosqlExtendedResultCodes
  oosqlFinalize
 ooSQLite Functions G - R
  oosqlGetAutocommit
  oosqlInterrupt
  oosqlIsHandleNull
  oosqlLastInsertRowID
  oosqlLibVersion
  oosqlLibVersionNumber
  oosqlLimit
  oosqlLoadExtension
  oosqlMemoryHighWater
  oosqlMemoryUsed
  oosqlMutexAlloc
  oosqlMutexEnter
  oosqlMutexFree
  oosqlMutexLeave
  oosqlMutexTry
  oosqlNextStmt
  oosqlOpen
  oosqlPrepare
  oosqlProfile
  oosqlProgressHandler
  oosqlReleaseMemory
  oosqlReset
  oosqlResetAutoExtension
  oosqlResultBlob
  oosqlResultDouble
  oosqlResultError
  oosqlResultErrorCode
  oosqlResultErrorNoMem
  oosqlResultErrorTooBig
  oosqlResultInt
  oosqlResultInt64
  oosqlResultNull
  oosqlResultText
  oosqlResultValue
  oosqlResultZeroBlob
  oosqlRollbackHook
 ooSQLite Functions S - Z
  oosqlSetAuthorizer
  oosqlSoftHeapLimit64
  oosqlSourceID
  oosqlSql
  oosqlStatus
  oosqlStep
  oosqlStmtBusy
  oosqlStmtReadonly
  oosqlStmtStatus
  oosqlStrGlob
  oosqlTableColumnMetadata
  oosqlThreadSafe
  oosqlTotalChanges
  oosqlTrace
  oosqlUpdateHook
  oosqlValueBlob
  oosqlValueBytes
  oosqlValueDouble
  oosqlValueInt
  oosqlValueNumericType
  oosqlValueText
  oosqlValueType
  oosqlVersion
 Notices
  Trademarks
  Source Code For This Document
 Common Public License Version 1.0
  Definitions
  Grant of Rights
  Requirements
  Commercial Distribution
  No Warranty
  Disclaimer of Liability
  General
 Revision History