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