Index
AllowMoveLast Property
Append (OraCollection) Method
Append (OraLOB) Method
AppendChunk Method
AppendChunk Method Example
AppendChunkByte Method
AppendChunkByte Method Example
AQ,using
AQAgent (OraAQMsg) Method
AQMsg (OraAQ) Method
ArcCos (OraNumber) Method
ArcSin (OraNumber) Method
ArcTan (OraNumber) Method
ArcTan2 (OraNumber) Method
ArraySize Property
Attribute (OraMetaData) Method
AutoBindDisable Method
AutoBindDisable Method Example
AutoBindEnable Method
AutoBindEnable Method Example
AutoBinding Property
AutoBinding Property Example
AutoCommit Property
automation objects
available objects
BackColor Property
basics of client applications
Batch Insert Form
BeginTrans Method
BeginTrans Method Example
Bind Variables
BOC (OraCollection) Property
BOF Property
BOF Property Example
Bookmark Property
Bookmark Property Example
BookMarkable Property
CacheBlocks Property
CacheChanged Property
CacheMaximumSize Property
CacheOptimalSize Property
CacheSliceSize Property
CacheSliceSizePerBlock Property
CancelEdit (Oraref) Method
Caption Property
Ceil (OraNumber) Method
ChangePassword (OraServer) Method
ChangePassword (OraSession) Method
Client Property
Clone (OraCollection) Method
Clone (OraLOB/BFILE) Method
Clone (OraNumber) Method
Clone (OraObject/OraRef) Method
Clone Method
Close (OraBFILE) Method
Close Method
CloseAll (OraBFILE) Method
Coding the Add Button
Coding the Batch Insert Form_Load() Procedure
Coding the CmdAddtoGrid() Procedure
Coding the Commit Button (Add)
Coding the Commit Button (Update and Add)
Coding the CommitGrid_Click() Procedure
Coding the Update Button
Collection Errors,errors
collections,using
Column Default Mode
COM
Commit_Click() Event Procedure
Commit_Click() Procedure (Add)
CommitGrid_Click() Procedure
CommitTrans Method
CommitTrans Method Example
Compare (OraLOB) Method
Component Object Model (COM)
Connect Property: OLE Server
Connect Property: Data Control
Connect Property Example
Connecting to the Oracle Database
connection multiplexing
Connection Property
Connections Property
ConnectSession Method
ConnectSession Method Example
Constants
Consumer (AQ) Property
Copy (OraLOB) Method
CopyFromBFILE (OraLOB) Method
CopyFromFile (OraLOB) Method
Copyright
CopyToClipboard Method
CopyToClipboard Method Example
CopyToFile (OraLOB/BFILE) Method
Correlate (AQ) Property
Correlation (AQ) Property
Cos (OraNumber) Method
Count (OraMetaData) Property
Count (OraObject/OraRef) Property
Count Property
Count Property Example
CreateAQ (OraDatabase) Method
CreateCustomDynaset Method
CreateCustomDynaset Method Example
CreateDatabasePool Method
CreateDynaset Method Example
CreateDynasetMethod
CreateIterator Method
CreateNamedSession Method
CreateNamedSession Method Example
CreateOraNumber Method
CreateOraObject (OraDatabase) Method
CreatePLSQLCustomDynaset Method
CreatePlsqlDynaset Method
CreatePLSQLDynaset Method Example
CreateSession Method
CreateSession Method Example
CreateSQL Method
CreateSQL Method Example
Creating a Dynaset
creating a VARRAY Collection Type
creating,a Dynaset from an OraCollection
custom cache and fetch parameters
Data Control
Data Control Events
Data Control Methods
Data Control Properties
Data Control,errors
Database Object Property
Database Property
DatabaseName
DatabaseName Property
DatabaseName Property Example
Databases Property
Date Format
DbPoolCurrentSize Property
DbPoolInitialSize Property
DbPoolMaxSize Property
default column values
Delay (AQ) Property
Delete (OraCollection) Method
Delete (Oraref) Method
Delete Method
Delete Method Example
DeleteIterator Method
Deleting Records
Deleting Rows
DEMOBLD7.SQL
DEMODRP7.SQL
Dequeue (OraAQ) Method
DequeueMode (AQ) Property
DequeueMsgId (AQ) Property
Describe (OraDatabase) Method
describing,database schema objects
DestroyDatabasePool Method
DirectoryName (OraBFILE) Property
DirtyWrite Property
DisableBuffering (OraLOB) Method
Div (OraNumber) Method
DoValidationChecks() Function
Drag Method
DragDrop Event
DragIcon Property
DragMode Property
DragOver Event
DynasetCacheParams Method
DynasetOption
Edit (Oraref) Method
Edit Method
Edit Method Example
EditMode Property
EditOption (OraRef) Property
ElementType (OraCollection) Property
ElementValue Method
Employee Form
EmpRefresh Subroutine
EnableBuffering (OraLOB) Method
Enabled Property
Enqueue (OraAQ) Method
EOC (OraCollection) Property
EOF Property
EOF Property Example
Erase (OraLOB) Method
Error Event
error messages
Errors
errors
Events
example,GetRows
ExampleDb
examples
ExceptionQueue (AQ) Property
ExecuteSQL Method
ExecuteSQL Method Example
executing commands
Executing Data Definition Language (DDL) statements
Executing Data Manipulation Language (DML) statements
Executing PL/SQL blocks
Executing Queries
executing,member method of Oracle object instance
Exist (OraCollection) Method
Exists (OraBFILE) Property
Exp (OraNumber) Method
Expiration (AQ) Property
features, added in releases 2.2 and 2.3
Fetching data from a long or long raw column
FetchLimit Property
FetchSize Property
FieldIndex Property
FieldName Property
FieldOriginalName Property
FieldOriginalNameIndex Property
Fields Property
FieldSize Method
FileName (OraBFILE) Property
Filter Property
Find Method Parser,errors
Find Method Runtime,errors
Find Methods Example
Find_Click() Event Procedure
FindFirst Method
FindLast Method
FindNext Method
FindPrevious Method
Floor (OraNumber) Method
FlushBuffer (OraLOB) Method
Font Property
ForeColor Property
Format (OraNumber) Property
general protection fault errors
Get_Value Method
GetChunk Method
GetChunk Method Example
GetChunkByte Method
GetChunkByte Method Example
GetChunkByteEx Method
GetChunkByteEx method,example
GetDatabaseFromPool Method
GetRows example
GetRows Method
getting started
Getting Started: Steps to Accessing Oracle Data
Height Property
HypCos (OraNumber) Method
HypSin (OraNumber) Method
HypTan (OraNumber) Method
IIS,Internet Information Server
Index Property
Information Sources
initializing,Oracle LOBs, objects, and collections
InitIterator Method
Input parameters
Inserting Rows
Inserting Rows in Batch
IsEqual (OraNumber) Method
IsGreater (OraNumber) Method
IsLess (OraNumber) Method
IsLocator (OraCollection) Property
IsMDObject (OraMDAttribute) Property
IsNull (LOB/BFILE) Property
IsNull (OraCollection) Property
IsNull (OraObject) Property
IsOpen (BFILE) Property
IsRefNull (OraRef) Property
IterNext Method
IterPrev Method
large objects (LOBs),using
LastErrorText Property
LastModified Property
LastServerErr Property
LastServerErr Property Example
LastServerErrPos Property
LastServerErrReset Property
LastServerErrText Property
LastServerErrText Property Example
Left Property
Ln (OraNumber) Method
LOB
Lock No-Wait Mode
Lock Wait Mode
Log (OraNumber) Method
Long and Long Raw Columns
Long columns
MatchPos (OraLOB/BFILE) Method
MaxSize (OraCollection) Property
messages,error
Methods
Microsoft Transaction Server (MTS)
Microsoft Transaction Server support
Microsoft Visual C++
migrating,from Long Raw to LOB/BFILE
MinimumSize Property
MinimumSize Property Esample
Mod (OraNumber) Method
Modifying Attributes of a Referenceable Instance
Modifying Attributes of an Embedded/Value Instance
Modifying Collection Elements
monitoring messages,OraAQ Object
MonitorStart (OraAQ) Method
MonitorStop (OraAQ) Method
MouseDown Event
MouseMove Event
MousePointer Property
MouseUp Event
Move Method
MoveFirst Method
MoveFirst Method Example
MoveFirstn, MoveLastn, MoveRel Method
MoveLast Method
MoveLast Method Example,MoveNext Method Example,MovePrevious Method Example
MoveNext Method
MovePrevious Method
Moving to First and Last Rows
Moving to the Next Row
Moving to the Previous Row
MTS support
MTS, Microsoft Transaction Server
Mul (OraNumber) Method
Multiple Cursor Return from PL/SQL Procedure, example
Multiple Cursor Return from PL/SQL Procedures
Multiple Piece Read Operation
Multiple Piece Write Operation
multiple server connections
Name (AQ) Property
Name (OraAttribute) Property
Name (OraMDAttribute) Property
Name Property
Navigating Through Data
Navigation (AQ) Property
Neg (OraNumber) Method
network errors
new features
No cache dynasets
No Refetch Mode
NoMatch Property
Non-Blocking Mode
NoRefetch Property
Number Errors,errors
object datatypes,using
Object Instance,errors
object-relational and LOB datatypes diagram
object-relational and LOB datatypes,support for
Objects
objects, programmable
Offset (OraLOB/BFILE) Property
oip8.tlb,setting up in a VB project
OIPVersionNumber Property
OLE automation
OLE Automation Errors
OLE automation,errors
OLE errors
OLE Initialization Errors
OO4O Automation Server
OO4O Automation server,accessing and connecting
OO4O Automation with Active Server Pages (ASP)
OO4O Automation with Excel,using
OO4O Automation with Visual Basic,using
OO4O Server Methods
OO4O Server Objects
OO4O Server Properties
Open (OraBFILE) Method
Open (OraServer) Method
OpenDatabase Method
OpenDatabase Method Example
Options Property
OraAQ Object
OraAQAgent Object
OraAQMsg Object
OraAttribute Object
OraBFILE Object
OraBLOB Object
Oracle Data Control
Oracle Data Control with MS VC++,using
Oracle Data Control with Visual Basic,using
Oracle Data Control,registering
Oracle Mode (No Refetch)
Oracle Notes
Oracle Object Server
Oracle Objects for OLE C++ Class Library
Oracle Objects for OLE,files
Oracle,errors
Oracle7 Server
OracleMode
OraClient Object
OraCLOB Object
OraCollection Iterator example
OraCollection Object
OraConnection Object
OraConnections Collection
ORACONST.TXT
OraDatabase Object
ORADC.OCX
OraDynaset Object
ORAEXAMP.SQL
OraField Object
OraFields Collection
OraIDataType Property
ORAIPSRV.DLL
ORAIPSRV.REG
ORAIPSRV.TLB
OraLOB Object
OraMaxDSize Property
OraMaxSize Property
OraMDAttribute Object
OraMetaData Object
OraNullOK Property
OraNumber Object
OraObject Object
OraParamArray Example
OraParamArray Object
OraParameter Object
OraParameters Collection
OraPrecision Property
OraRef Object
OraScale Property
OraServer Object
OraSession Object
OraSessions Collection
OraSQLStmt Object
OriginalItem Method
OriginalItem Method Example
OriginalName Method
OriginalName Method Example
Other Information Sources
Output parameters
overview
Parameter Array Object
Parameter binding
Parameters
Parameters Property
Parse Errors
Password
Performance Considerations with LOB Read and Write
PinOption (OraRef) Property
PL/SQL
PL/SQL Language
PLSQL_Supports
PollingAmount (OraLOB/BFILE) Property
Power (OraNumber) Method
Priority (AQ) Property
programmable objects
Properties
Put_Value Method
Querying the Database
Quick Tour with Visual Basic
quick tours
RDDMSVersion Property
Read (OraLOB) Method
Read consistency
ReadChunk Method
Reading LOB Data
Read-only dynasets
ReadOnly Property
Record Count Example for OraSQLStmt
RecordCount Property
RecordCount Property Example
Recordset Property
RecordSource Property
RecordSource Property Example
redistributable files
Refresh (Oraref) Method
Refresh Method
Refresh Method Example
Refresh Method Example (OraSqlStmt)
Refresh Method: OLE Server
Refreshing Screen Data
registering,Oracle Data Control
RelMsgId (AQ) Property
Remove Method
Remove Method Example
RemoveFromPool Method
Reposition Event
requirements
ResetTrans Method
ResetTrans Method Example
Retrieving a Collection Type Instance from the Database
Retrieving a REF from the Database
Retrieving an Embedded/Value Instance from the Database
Retrieving LOBs from the Database
Returning PL/SQL Cursor Variables
Returning PL/SQL Tables
Rollback Method
Rollback Method Example
Round (OraNumber) Method
ROWID
RowPosition Property
SafeArray (OraCollection) Property
Sample Code
schema objects,describing
See VB
SELECT ... FOR UPDATE
SELECT ... FOR UPDATE Example
SELECT statement
Server Property
ServerType Property
ServerType Property Example
Session Object Property
Session Property
Sessions Property
SetAfterCommitFlags() Subroutine
SetPi (OraNumber) Method
setups
Sin (OraNumber) Method
Single Piece Read Operation
Single Piece Write Operation
Size (LOB/BFILE) Property
Size (OraCollection) Property
Size Property
SnapShot Property
software layers
Sort Property
SQL
SQL Language
SQL Property
SQL Property Example
SQL Statement Object
SQL*Net
SQL*Net aliases
SQL*Net Errors
Sqrt (OraNumber) Method
Starting the Oracle In Process Server
Status (OraLOB/BFILE) Property
Status Property
Status Property Example
Sub (OraNumber) Method
table (ORAMD_TABLE) attributes
TableName (OraRef) Property
TableSize (OraCollection) Property
Tag Property
Tan (OraNumber) Method
Technical Notes
Thread Safety
Top Property
Trailing blanks
TrailingBlanks Property
transaction control
Transactions
Transactions Property
Trim (OraCollection) Method
Trim (OraLOB) Method
Troubleshooting
Trunc (OraNumber) Method
Truncated Property
tuning, and Customization
two-phase commit
Type (OraAttribute) Property
Type (OraCollection) Property
Type (OraMetaData) Property
type library,setting up in a VB project
Type Property
TypeName (OraObject/OraRef) Property
Updatable dynasets
Updatable Property
Updatable Property Example
Update (Oraref) Method
Update Method
Update Method Example
Update_Dynaset_Fields() Function
UpdateControls Method
UpdateControls Method Example
UpdateRecord Method
Updating Database Records
Updating Records
Username
using automation clients,overview
using ExecuteSQL and CreateSQL,to execute PL/SQL Blocks
Using Read-only:Forward-only Dynaset
Using the Connection Pool Management Facility
using the OraObject Interface
Using the OraRef Interface
Validate Event
Value (AQ) Property
Value (OraAttribute) Property
Value (OraMDAttribute) Property
Value (OraNumber) Property
Value Property
VBA,Visual Basic for Applications
Version (OraObject/OraRef) Property
Visible (AQ) Property
Visible Property
Visual Basic
Visual Basic for Applications (VBA)
Visual Basic Mode
Wait (AQ) Property
Width Property
Write (OraLOB) Method
Writing LOB Data
ZOrder Method