documentation.HELP! Microsoft ActiveX Data Objects (ADO) Documentation

Microsoft ActiveX Data Objects 2.5 (ADO)

Microsoft ActiveX Data Objects (ADO)

Table of contents

• Microsoft ActiveX Data Objects (ADO)
  • ADO Programmer's Guide
    • Introduction
      • What's New in ADO
      • Prerequisites
      • The ADO Family of Libraries
      • The Role of ADO in Microsoft Data Access
      • ADO Task Table
      • ADO Technology Table
    • Section I: ActiveX Data Objects (ADO)
      • Chapter 1: ADO Fundamentals
        • What You Can Do With ADO
        • The ADO Object Model
        • HelloData: A Simple ADO Application
          • HelloData Details
          • HelloData Code
        • OLE DB Providers
          • Data Providers
          • Service Providers and Components
        • Errors
      • Chapter 2: Getting Data
        • Making a Connection
        • Using the Connection Object
          • Creating the Connection String
          • Controlling Transactions
        • Using the Command Object
          • Command Object Overview
          • Creating and Executing a Simple Command
          • Command Object Parameters
          • Calling a Stored Procedure with a Command
          • Named Commands
        • Adding Data to a Recordset
          • The Recordset Object Open Method
      • Chapter 3: Examining Data
        • Locating the Current Record
          • Counting Rows
          • The Limits of a Recordset
        • Navigating Through the Data
          • Jumping to a Record
          • More Ways to Move in a Recordset
          • Using Bookmarks
          • Using Pages
          • Recordset Positioning
        • Understanding Recordset Structure
          • The Fields Collection
          • The Field Object
          • Working with Recordsets
      • Chapter 4: Editing Data
        • Editing Existing Records
        • Adding Records
          • Adding Records Using AddNew
          • Adding Multiple Fields
          • Determining Edit Mode
          • Using AddNew in Immediate and Batch Modes
        • Determining What is Supported
        • Deleting Records Using the Delete Method
        • Alternatives: Using SQL Statements
      • Chapter 5: Updating and Persisting Data
        • Updating Data
          • Immediate Mode
          • Batch Mode
            • Sending the Updates: UpdateBatch
            • Filtering for Updated Records
            • Dealing with Failed Updates
            • Detecting and Resolving Conflicts
            • Disconnecting and Reconnecting the Recordset
            • Updating JOINed Results: Unique Table
          • Transaction Processing
        • Persisting Data
          • More About Recordset Persistence
          • Persisting Filtered and Hierarchical Recordsets
          • Persisting Records in XML Format
            • XML Persistence Format
            • Namespaces
            • Schema Section
            • Data Section
            • Hierarchical Recordsets in XML
            • Recordset Dynamic Properties in XML
            • XSLT Transformations
            • Saving to the XML DOM Object
            • XML Security Considerations
            • XML Recordset Persistence Scenario
              • Step 1: Set Up the Application
              • Step 2: Get the Data
              • Step 3: Send the Data
              • Step 4: Receive and Display the Data
      • Chapter 6: Error Handling
        • ADO Errors
          • ADO Error Reference
        • Provider Errors
        • Field-Related Error Information
        • Recordset-Related Error Information
        • Handling Errors In Other Languages
          • Handling Errors in VBScript
          • Handling Errors in Visual C++
          • Handline Errors in Visual J++
          • Handling Errors in JScript
        • Anticipating Errors
      • Chapter 7: Handling ADO Events
        • ADO Event Handler Summary
        • Types of Events
        • Event Parameters
        • How Event Handlers Work Together
        • ADO Event Instantiation by Language
          • Visual Basic
          • Visual C++
          • Visual J++
          • VBScript
          • JScript
          • ADO/WFC
      • Chapter 8: Understanding Cursors and Locks
        • What is a Cursor?
        • Types of Cursors
          • Forward-Only Cursors
          • Static Cursors
          • Keyset Cursors
          • Dynamic Cursors
        • The Significance of Cursor Location
        • The Microsoft Cursor Service for OLE DB
        • What is a Lock?
          • Types of Locks
        • Using CacheSize
        • Cursor and Lock Characteristics
      • Chapter 9: Data Shaping
        • Data Shaping Summary
          • Data Shaping
          • Reshaping
          • Grandchild Aggregates
          • Parameterized Commands with Intervening COMPUTE Commands
          • Persisting Hierarchical Recordsets
        • Required Providers for Data Shaping
        • Shape Commands in General
          • Aggregate Functions, the CALC Function, and the NEW Keyword
          • Issuing Commands to the Underlying Data Provider
        • Shape Append Clause
          • Operation of Non-Parameterized Commands
          • Operation of Parameterized Commands
          • Hybrid Commands
          • Intervening Shape COMPUTE Clauses
        • Shape Compute Clause
        • Fabricating Hierarchical Recordsets
        • Accessing Rows in a Hierarchical Recordset
        • Formal Shape Grammar
        • Visual Basic for Applications functions
      • Chapter 10: Records and Streams
        • Streams and Persistence
        • Using ADO for Internet Publishing
          • The OLE DB Provider for Internet Publishing
          • Internet Publishing Scenario
            • Step 1: Set Up the Visual Basic Project
            • Step 2: Initialize the Main List Box
            • Step 3: Populate the Fields List Box
            • Step 4: Populate the Details Text Box
          • Absolute and Relative URLs
          • Records and Provider-Supplied Fields
    • Section II: Remote Data Service (RDS)
      • Chapter 11: RDS Fundamentals
        • Solutions for Remote Data Access
        • Basic RDS Programming Model
        • RDS Programming Model in Detail
        • RDS Programming Model with Objects
        • RDS Object Model Summary
        • RDS Scenario
          • System Requirements for the Address Book Application
          • Running the Address Book Sample Application
          • Address Book Data-Binding Object
          • Address Book Command Buttons
          • Address Book Navigation Buttons
      • Chapter 12: RDS Tutorial
        • Step 1: Specify a Server Program (RDS Tutorial)
        • Step 2: Invoke the Server Program (RDS Tutorial)
        • Step 3: Server Obtains a Recordset (RDS Tutorial)
        • Step 4: Server Returns the Recordset (RDS Tutorial)
        • Step 5: DataControl is Made Usable (RDS Tutorial)
        • Step 6: Changes are Sent to the Server (RDS Tutorial)
        • RDS Tutorial (VBScript)
        • RDS Tutorial (Visual J++)
      • Chapter 13: RDS Usage and Security
        • Configuring RDS
        • Granting Guest Privileges to a Web Server Computer; RDS guest privileges [ADO]
        • Registering a Custom Business Object
        • Marking Business Objects as Safe for Scripting
        • Registering Business Objects on the Client for Use with DCOM
        • Setting DCOM Stream Marshaling Format
        • Enabling a DLL to Run on DCOM
        • Configuring Virtual Servers on IIS
        • Specifying Threads Per Processor on IIS
        • Securing RDS Applications
        • Configuring DataFactory for Safe or Unrestricted Modes
        • Using Related Technologies with RDS
          • Using RDS with ODBC Connection Pooling
          • Running Business Objects in Component Services
        • DataFactory Customization
          • Understanding the Customization File
          • Customization File Connect Section
          • Customization File SQL Section
          • Customization File UserList Section
          • Customization File Logs Section
          • Required Client Settings
          • Writing Your Own Customized Handler
        • Troubleshooting RDS
          • Configuring RDS on Windows 2000
          • "Internet Server Error: Access Denied"
          • RDS Returns "Stream Not Read" Error
          • Deadlocks With Read Repeatable Isolation Level
          • Ensuring Sufficient TempDB Space
          • Minimizing Log File Space Usage
    • Section III: ADO (Multidimensional) (ADO MD)
      • Chapter 14: ADO MD Fundamentals
        • Overview of Multidimensional Schemas and Data
        • Working with Multidimensional Data
        • Using ADO with ADO MD
        • Programming with ADO MD
    • Section IV: ADO Extensions for Data Definition Language and Security (ADOX)
      • Chapter 15: ADOX Fundamentals
        • Provider Support for ADOX
    • Section V: Appendixes
      • Appendix A: Providers
        • Microsoft OLE DB Provider for ODBC
        • Microsoft OLE DB Provider for Microsoft Indexing Service
        • Microsoft OLE DB Provider for Microsoft Active Directory Service
        • Microsoft OLE DB Provider for Microsoft Jet
        • Microsoft OLE DB Provider for SQL Server
        • Microsoft OLE DB Provider for Oracle
        • Microsoft OLE DB Provider for Internet Publishing
        • Microsoft Data Shaping Service for OLE DB (ADO Service Provider)
        • Microsoft OLE DB Persistence Provider (ADO Service Provider)
        • Microsoft OLE DB Remoting Provider (ADO Service Provider)
        • Microsoft Cursor Service for OLE DB (ADO Service Component)
      • Appendix B: ADO Errors
        • ADO Error Codes
        • DataControl Error Codes
        • Internet Explorer Error Codes
        • Internet Information Services Error Codes
      • Appendix C: Programming with ADO
        • Using ADO with Microsoft Visual Basic
        • Using ADO with Scripting Languages
          • VBScript ADO Programming
          • JScript ADO Programming
        • Using ADO with Microsoft Visual C++
          • Visual C++ ADO Programming
          • Visual C++ Extensions for ADO
          • Using Visual C++ Extensions
          • Visual C++ Extensions Header
          • Visual C++ Extensions Example
        • Using ADO with Microsoft Visual J++
          • ADO/WFC Programming
          • Using the Java Type Library Wizard
          • Using the Microsoft SDK for Java
          • ADO Java Class Wrappers
      • Appendix D: ADO Samples
    • ADO Glossary
  • ADO Programmer's Reference
    • ADO API Reference
      • ADO Object Model
      • ADO Objects and Interfaces
        • ADORecordConstruction Interface (ADO)
        • ADORecordsetConstruction Interface (ADO)
        • Command Object (ADO)
          • Properties, Methods, and Events
        • Connection Object (ADO)
          • Properties, Methods, and Events
        • Error Object (ADO)
          • Properties, Methods, and Events
        • Field Object (ADO)
          • Properties, Methods, and Events
        • Parameter Object (ADO)
          • Properties, Methods, and Events
        • Property Object (ADO)
          • Properties, Methods, and Events
        • Record Object (ADO)
          • Properties, Methods, and Events
        • Recordset Object (ADO)
          • Properties, Methods, and Events
        • Stream Object (ADO)
          • Properties, Methods, and Events
      • ADO Collections
        • Errors Collection (ADO)
          • Errors Collection Properties, Methods, and Events
        • Fields Collection (ADO)
          • Fields Collection Properties, Methods, and Events
        • Parameters Collection (ADO)
          • Parameters Collection Properties, Methods, and Events
        • Properties Collection (ADO)
          • Properties Collection Properties, Methods, and Events
      • ADO Properties
        • AbsolutePage Property (ADO)
        • AbsolutePosition Property (ADO)
        • ActiveCommand Property (ADO)
        • ActiveConnection Property (ADO)
        • ActualSize Property (ADO)
        • Attributes Property (ADO)
        • BOF, EOF Properties (ADO)
        • Bookmark Property (ADO)
        • CacheSize Property (ADO)
        • Chapter Property (ADO)
        • Charset Property (ADO)
        • CommandText Property (ADO)
        • CommandTimeout Property (ADO)
        • CommandType Property (ADO)
        • ConnectionString Property (ADO)
        • ConnectionTimeout Property (ADO)
        • Count Property (ADO)
        • CursorLocation Property (ADO)
        • CursorType Property (ADO)
        • DataMember Property (ADO)
        • DataSource Property (ADO)
        • DefaultDatabase Property (ADO)
        • DefinedSize Property (ADO)
        • Description Property (ADO)
        • Direction Property (ADO)
        • EditMode Property (ADO)
        • EOS Property (ADO)
        • Filter Property (ADO)
        • HelpContext, HelpFile Properties (ADO)
        • Index Property (ADO)
        • IsolationLevel Property (ADO)
        • Item Property (ADO)
        • LineSeparator Property (ADO)
        • LockType Property (ADO)
        • MarshalOptions Property (ADO)
        • MaxRecords Property (ADO)
        • Mode Property (ADO)
        • Name Property (ADO)
        • NativeError Property (ADO)
        • Number Property (ADO)
        • NumericScale Property (ADO)
        • OriginalValue Property (ADO)
        • PageCount Property (ADO)
        • PageSize Property (ADO)
        • ParentRow Property (ADO)
        • ParentURL Property (ADO)
        • Position Property (ADO)
        • Precision Property (ADO)
        • Prepared Property (ADO)
        • Provider Property (ADO)
        • RecordCount Property (ADO)
        • RecordType Property (ADO)
        • Row Property (ADO)
        • RowPosition Property (ADO)
        • Rowset Property (ADO)
        • Size Property (ADO)
        • Size Property (ADO Stream)
        • Sort Property (ADO)
        • Source Property (ADO Error)
        • Source Property (ADO Record)
        • Source Property (ADO Recordset)
        • SQLState Property (ADO)
        • State Property (ADO)
        • Status Property (ADO Field)
        • Status Property (ADO Recordset)
        • StayInSync Property (ADO)
        • Type Property (ADO)
        • Type Property (ADO Stream)
        • UnderlyingValue Property (ADO)
        • Value Property (ADO)
        • Version Property (ADO)
      • ADO Dynamic Properties
        • ADO Dynamic Property Index
        • Optimize Property--Dynamic (ADO)
        • Prompt Property--Dynamic (ADO)
        • Reshape Name Property--Dynamic (ADO)
        • Resync Command Property--Dynamic (ADO)
        • Unique Table, Unique Schema, Unique Catalog Properties--Dynamic (ADO)
        • Update Resync Property--Dynamic (ADO)
      • ADO Methods
        • AddNew Method (ADO)
        • Append Method (ADO)
        • AppendChunk Method (ADO)
        • BeginTrans, CommitTrans, and RollbackTrans Methods (ADO)
        • Cancel Method (ADO)
        • CancelBatch Method (ADO)
        • CancelUpdate Method (ADO)
        • Clear Method (ADO)
        • Clone Method (ADO)
        • Close Method (ADO)
        • CompareBookmarks Method (ADO)
        • CopyRecord Method (ADO)
        • CopyTo Method (ADO)
        • CreateParameter Method (ADO)
        • Delete Method (ADO Parameters Collection)
        • Delete Method (ADO Fields Collection)
        • Delete Method (ADO Recordset)
        • DeleteRecord Method (ADO)
        • Execute Method (ADO Command)
        • Execute Method (ADO Connection)
        • Find Method (ADO)
        • Flush Method (ADO)
        • GetChildren Method (ADO)
        • GetChunk Method (ADO)
        • GetRows Method (ADO)
        • GetString Method (ADO)
        • LoadFromFile Method (ADO)
        • Move Method (ADO)
        • MoveFirst, MoveLast, MoveNext, and MovePrevious Methods (ADO)
        • MoveRecord Method (ADO)
        • NextRecordset Method (ADO)
        • Open Method (ADO Connection)
        • Open Method (ADO Record)
        • Open Method (ADO Recordset)
        • Open Method (ADO Stream)
        • OpenSchema Method (ADO)
        • Read Method (ADO)
        • ReadText Method (ADO)
        • Refresh Method (ADO)
        • Requery Method (ADO)
        • Resync Method (ADO)
        • Save Method (ADO)
        • SaveToFile Method (ADO)
        • Seek Method (ADO)
        • SetEOS Method (ADO)
        • SkipLine Method (ADO)
        • Stat Method (ADO)
        • Supports Method (ADO)
        • Update Method (ADO)
        • UpdateBatch Method (ADO)
        • Write Method (ADO)
        • WriteText Method (ADO)
      • ADO Events
        • BeginTransComplete, CommitTransComplete, and RollbackTransComplete Events (ADO)
        • ConnectComplete and Disconnect Events (ADO)
        • EndOfRecordset Event (ADO)
        • ExecuteComplete Event (ADO)
        • FetchComplete Event (ADO)
        • FetchProgress Event (ADO)
        • InfoMessage Event (ADO)
        • WillChangeField and FieldChangeComplete Events (ADO)
        • WillChangeRecord and RecordChangeComplete Events (ADO)
        • WillChangeRecordset and RecordsetChangeComplete Events (ADO)
        • WillConnect Event (ADO)
        • WillExecute Event (ADO)
        • WillMove and MoveComplete Events (ADO)
      • ADO Enumerated Constants
        • ADCPROP_ASYNCTHREADPRIORITY_ENUM
        • ADCPROP_AUTORECALC_ENUM
        • ADCPROP_UPDATECRITERIA_ENUM
        • ADCPROP_UPDATERESYNC_ENUM
        • AffectEnum
        • BookmarkEnum
        • CommandTypeEnum
        • CompareEnum
        • ConnectModeEnum
        • ConnectOptionEnum
        • ConnectPromptEnum
        • CopyRecordOptionsEnum
        • CursorLocationEnum
        • CursorOptionEnum
        • CursorTypeEnum
        • DataTypeEnum
        • EditModeEnum
        • ErrorValueEnum
        • EventReasonEnum
        • EventStatusEnum
        • ExecuteOptionEnum
        • FieldEnum
        • FieldAttributeEnum
        • FieldStatusEnum
        • FilterGroupEnum
        • GetRowsOptionEnum
        • IsolationLevelEnum
        • LineSeparatorsEnum
        • LockTypeEnum
        • MarshalOptionsEnum
        • MoveRecordOptionsEnum
        • ObjectStateEnum
        • ParameterAttributesEnum
        • ParameterDirectionEnum
        • PersistFormatEnum
        • PositionEnum
        • PropertyAttributesEnum
        • RecordCreateOptionsEnum
        • RecordOpenOptionsEnum
        • RecordStatusEnum
        • RecordTypeEnum
        • ResyncEnum
        • SaveOptionsEnum
        • SchemaEnum
        • SearchDirectionEnum
        • SeekEnum
        • StreamOpenOptionsEnum
        • StreamReadEnum
        • StreamTypeEnum
        • StreamWriteEnum
        • StringFormatEnum
        • XactAttributeEnum
        • ADO Syntax Indexes
          • ADO for Visual C++ Syntax Index for COM
            • Collections (ADO for Visual C++ Syntax)
            • Command (ADO for Visual C++ Syntax)
            • Connection (ADO for Visual C++ Syntax)
            • Error (ADO for Visual C++ Syntax)
            • Field (ADO for Visual C++ Syntax)
            • Parameter (ADO for Visual C++ Syntax)
            • Record (ADO for Visual C++ Syntax)
            • Recordset (ADO for Visual C++ Syntax)
            • Stream (ADO for Visual C++ Syntax)
          • ADO for Visual C++ Syntax Index with #import
            • Collections (Visual C++ Syntax Index with #import)
            • Command (Visual C++ Syntax Index with #import)
            • Connection (Visual C++ Syntax Index with #import)
            • Error (Visual C++ Syntax Index with #import)
            • Field (Visual C++ Syntax Index with #import)
            • Parameter (Visual C++ Syntax Index with #import)
            • Property (Visual C++ Syntax Index with #import)
            • Record (Visual C++ Syntax Index with #import)
            • Recordset (Visual C++ Syntax Index with #import)
            • Stream (Visual C++ Syntax Index with #import)
            • ConnectionEvents (Visual C++ Syntax Index with #import)
            • RecordsetEvents (Visual C++ Syntax Index with #import)
          • ADO/WFC Syntax Index
            • Collections (ADO/WFC Syntax)
            • Command (ADO/WFC Syntax)
            • Connection (ADO/WFC Syntax)
            • DataSpace (ADO/WFC Syntax)
            • Error (ADO/WFC Syntax)
            • Field (ADO/WFC Syntax)
            • ObjectProxy (ADO/WFC Syntax)
            • Parameter (ADO/WFC Syntax)
            • Recordset (ADO/WFC Syntax)
      • ADO Code Examples
        • ADO Code Examples in Microsoft Visual Basic
          • AbsolutePage, PageCount, and PageSize Properties Example (VB)
          • AbsolutePosition and CursorLocation Properties Example (VB)
          • ActiveCommand Property Example (VB)
          • ActiveConnection, CommandText, CommandTimeout, CommandType, Size, and Direction Properties Example (VB)
          • ActualSize and DefinedSize Properties Example (VB)
          • AddNew Method Example (VB)
          • Append and CreateParameter Methods Example (VB)
          • AppendChunk and GetChunk Methods Example (VB)
          • Attributes and Name Properties Example (VB)
          • BeginTrans, CommitTrans, and RollbackTrans Methods Example (VB)
          • BOF, EOF, and Bookmark Properties Example (VB)
          • CacheSize Property Example (VB)
          • Cancel Method Example (VB)
          • Clone Method Example (VB)
          • CompareBookmarks Method Example (VB)
          • ConnectionString, ConnectionTimeout, and State Properties Example (VB)
          • ConvertToString Method Example (VB)
          • CopyRecord, CopyTo, and SaveToFile Methods Example (VB)
          • Count Property Example (VB)
          • CreateRecordset Method Example (VB)
          • CursorType, LockType, and EditMode Properties Example (VB)
          • Delete Method Example (VB)
          • DeleteRecord and MoveRecord Methods Example (VB)
          • Description, HelpContext, HelpFile, NativeError, Number, Source, and SQLState Properties Example (VB)
          • EOS and LineSeparator Properties and SkipLine Method Example (VB)
          • Execute, Requery, and Clear Methods Example (VB)
          • Filter and RecordCount Properties Example (VB)
          • Find Method Example (VB)
          • GetRows Method Example (VB)
          • GetString Method Example (VB)
          • IsolationLevel and Mode Properties Example (VB)
          • Item Property Example (VB)
          • MarshalOptions Property Example (VB)
          • MaxRecords Property Example (VB)
          • Move Method Example (VB)
          • MoveFirst, MoveLast, MoveNext, and MovePrevious Methods Example (VB)
          • NextRecordset Method Example (VB)
          • NumericScale and Precision Properties Example (VB)
          • Open and Close Methods Example (VB)
          • OpenSchema Method Example (VB)
          • Optimize Property Example (VB)
          • OriginalValue and UnderlyingValue Properties Example (VB)
          • Prepared Property Example (VB)
          • Provider and DefaultDatabase Properties Example (VB)
          • Read, ReadText, Write, and WriteText Methods Example (VB)
          • Refresh Method Example (VB)
          • Resync Method Example (VB)
          • Save and Open Methods Example (VB)
          • Seek Method and Index Property Example (VB)
          • Sort Property Example (VB)
          • Source Property Example (VB)
          • State Property Example (VB)
          • Status Property Example (Field) (VB)
          • Status Property Example (Recordset) (VB)
          • StayInSync Property Example (VB)
          • Supports Method Example (VB)
          • Type Property Example (Field) (VB)
          • Type Property Example (Property) (VB)
          • Update and CancelUpdate Methods Example (VB)
          • UpdateBatch and CancelBatch Methods Example (VB)
          • Value Property Example (VB)
          • Version Property Example (VB)
        • ADO Code Examples in Microsoft Visual Basic Scripting Edition
          • AddNew Method Example (VBScript)
          • Clone Method Example (VBScript)
          • Delete Method Example (VBScript)
          • Execute, Requery, and Clear Methods Example (VBScript)
          • Move Method Example (VBScript)
          • MoveFirst, MoveLast, MoveNext, and MovePrevious Methods Example (VBScript)
          • Open and Close Methods Example (VBScript)
        • ADO Code Examples in Microsoft Visual C++
          • ADO Events Model Example (VC++)
          • AbsolutePage, PageCount, and PageSize Properties Example (VC++)
          • AbsolutePosition and CursorLocation Properties Example (VC++)
          • ActiveCommand Property Example (VC++)
          • ActiveConnection, CommandText, CommandTimeout, CommandType, Size, and Direction Properties Example (VC++)
          • ActualSize and DefinedSize Properties Example (VC++)
          • AddNew Method Example (VC++)
          • Append and CreateParameter Methods Example (VC++)
          • AppendChunk and GetChunk Methods Example (VC++)
          • Attributes and Name Properties Example (VC++)
          • BeginTrans, CommitTrans, and RollbackTrans Methods Example (VC++)
          • BOF, EOF, and Bookmark Properties Example (VC++)
          • CacheSize Property Example (VC++)
          • Cancel Method Example (VC++)
          • Clone Method Example (VC++)
          • CompareBookmarks Method Example (VC++)
          • ConnectionString, ConnectionTimeout, and State Properties Example (VC++)
          • Count Property Example (VC++)
          • CursorType, LockType, and EditMode Properties Example (VC++)
          • Delete Method Example (VC++)
          • Description, HelpContext, HelpFile, NativeError, Number, Source, and SQLState Properties Example (VC++)
          • Execute, Requery, and Clear Methods Example (VC++)
          • Filter and RecordCount Properties Example (VC++)
          • Find Method Example (VC++)
          • GetRows Method Example (VC++)
          • GetString Method Example (VC++)
          • IsolationLevel and Mode Properties Example (VC++)
          • Item Property Example (VC++)
          • MarshalOptions Property Example (VC++)
          • MaxRecords Property Example (VC++)
          • Move Method Example (VC++)
          • MoveFirst, MoveLast, MoveNext, and MovePrevious Methods Example (VC++)
          • NextRecordset Method Example (VC++)
          • NumericScale and Precision Properties Example (VC++)
          • Open and Close Methods Example (VC++)
          • OpenSchema Method Example (VC++)
          • Optimize Property Example (VC++)
          • OriginalValue and UnderlyingValue Properties Example (VC++)
          • Prepared Property Example (VC++)
          • Provider and DefaultDatabase Properties Example (VC++)
          • Refresh Method Example (VC++)
          • Resync Method Example (VC++)
          • Save and Open Methods Example (VC++)
          • Seek Method and Index Property Example (VC++)
          • Sort Property Example (VC++)
          • Source Property Example (VC++)
          • State Property Example (VC++)
          • Status Property Example (VC++)
          • StayInSync Property Example (VC++)
          • Supports Method Example (VC++)
          • Type Property Example (Field) (VC++)
          • Type Property Example (Property) (VC++)
          • Update and CancelUpdate Methods Example (VC++)
          • UpdateBatch and CancelBatch Methods Example (VC++)
          • Value Property Example (VC++)
          • Version Property Example (VC++)
        • ADO Code Examples in Microsoft Visual J++
          • AbsolutePage, PageCount, and PageSize Properties Example (VJ++)
          • AbsolutePosition and CursorLocation Properties Example (VJ++)
          • ActiveCommand Property Example (VJ++)
          • ActiveConnection, CommandText, CommandTimeout, CommandType, Size, and Direction Properties Example (VJ++)
          • ActualSize and DefinedSize Properties Example (VJ++)
          • AddNew Method Example (VJ++)
          • Append and CreateParameter Methods Example (VJ++)
          • AppendChunk and GetChunk Methods Example (VJ++)
          • Attributes and Name Properties Example (VJ++)
          • BeginTrans, CommitTrans, and RollbackTrans Methods Example (VJ++)
          • BOF, EOF, and Bookmark Properties Example (VJ++)
          • CacheSize Property Example (VJ++)
          • Cancel Method Example (VJ++)
          • Clone Method Example (VJ++)
          • CompareBookmarks Method Example (VJ++)
          • ConnectionString, ConnectionTimeout, and State Properties Example (VJ++)
          • Count Property Example (VJ++)
          • CursorType, LockType, and EditMode Properties Example (VJ++)
          • Delete Method Example (VJ++)
          • Description, HelpContext, HelpFile, NativeError, Number, Source, and SQLState Properties Example (VJ++)
          • Execute, Requery, and Clear Methods Example (VJ++)
          • Filter and RecordCount Properties Example (VJ++)
          • Find Method Example (VJ++)
          • GetRows Method Example (VJ++)
          • GetString Method Example (VJ++)
          • IsolationLevel and Mode Properties Example (VJ++)
          • Item Property Example (VJ++)
          • MarshalOptions Property Example (VJ++)
          • MaxRecords Property Example (VJ++)
          • Move Method Example (VJ++)
          • MoveFirst, MoveLast, MoveNext, and MovePrevious Methods Example (VJ++)
          • NextRecordset Method Example (VJ++)
          • NumericScale and Precision Properties Example (VJ++)
          • Open and Close Methods Example (VJ++)
          • OpenSchema Method Example (VJ++)
          • Optimize Property Example (VJ++)
          • OriginalValue and UnderlyingValue Properties Example (VJ++)
          • Prepared Property Example (VJ++)
          • Provider and DefaultDatabase Properties Example (VJ++)
          • Refresh Method Example (VJ++)
          • Resync Method Example (VJ++)
          • Save and Open Methods Example (VJ++)
          • Sort Property Example (VJ++)
          • Source Property Example (VJ++)
          • State Property Example (VJ++)
          • Status Property Example (VJ++)
          • StayInSync Property Example (VJ++)
          • Supports Method Example (VJ++)
          • Type Property Example (Field) (VJ++)
          • Type Property Example (Property) (VJ++)
          • Update and CancelUpdate Methods Example (VJ++)
          • UpdateBatch and CancelBatch Methods Example (VJ++)
          • Value Property Example (VJ++)
          • Version Property Example (VJ++)
        • ADO Code Examples in Microsoft JScript
          • AbsolutePage, PageCount, and PageSize Properties Example (JScript)
          • AbsolutePosition and CursorLocation Properties Example (JScript)
          • ActiveCommand Property Example (JScript)
          • ActiveConnection, CommandText, CommandTimeout, CommandType, Size, and Direction Properties Example (JScript)
          • ActualSize and DefinedSize Properties Example (JScript)
          • AddNew Method Example (JScript)
          • Append and CreateParameter Methods Example (JScript)
          • CacheSize Property Example (JScript)
          • Execute, Requery, and Clear Methods Example (JScript)
          • Filter and RecordCount Properties Example (JScript)
          • Find Method Example (JScript)
          • GetRows Method Example (JScript)
    • RDS API Reference
      • RDS Objects
        • DataControl Object (RDS)
          • Properties, Methods, and Events
        • DataFactory Object (RDSServer)
          • Properties, Methods, and Events
        • DataSpace Object (RDS)
          • Properties, Methods, and Events
      • RDS Properties
        • Connect Property (RDS)
        • ExecuteOptions Property (RDS)
        • FetchOptions Property (RDS)
        • FilterColumn Property (RDS)
        • FilterCriterion Property (RDS)
        • FilterValue Property (RDS)
        • Handler Property (RDS)
        • InternetTimeout Property (RDS)
        • ReadyState Property (RDS)
        • Recordset, SourceRecordset Properties (RDS)
        • Server Property (RDS)
        • SortColumn Property (RDS)
        • SortDirection Property (RDS)
        • SQL property [ADO]
        • URL Property (RDS)
      • RDS Methods
        • Cancel Method (RDS)
        • CancelUpdate Method (RDS)
        • ConvertToString Method (RDS)
        • CreateObject Method (RDS)
        • CreateRecordset Method (RDS)
        • MoveFirst, MoveLast, MoveNext, and MovePrevious Methods (RDS)
        • Query Method (RDS)
        • Refresh Method (RDS)
        • Reset Method (RDS)
        • SubmitChanges Method (RDS)
      • RDS Events
        • onError Event (RDS)
        • onReadyStateChange Event (RDS)
      • RDS Code Examples
        • RDS Code Examples in Microsoft Visual Basic
          • Handler Property Example (VB)
          • InternetTimeout Property Example (VB)
        • RDS Code Examples in Microsoft Visual Basic Scripting Edition
          • Cancel Method Example (VBScript)
          • CancelUpdate Method Example (VBScript)
          • Connect Property Example (VBScript)
          • ConvertToString Method Example (VBScript)
          • CreateRecordset Method Example (VBScript)
          • DataControl Object Example (VBScript)
          • DataSpace Object and CreateObject Method Example (VBScript)
          • DataFactory Object, Query Method, and CreateObject Method Example (VBScript)
          • ExecuteOptions and FetchOptions Properties Example (VBScript)
          • FilterColumn, FilterCriterion, FilterValue, SortColumn, and SortDirection Properties and Reset Method Example (VBScript)
          • ReadyState Property Example (VBScript)
          • Recordset and SourceRecordset Properties Example (VBScript)
          • Refresh Method Example (VBScript)
          • Server Property Example (VBScript)
          • SQL Property Example (VBScript)
          • SubmitChanges Method Example (VBScript)
          • URL Property Example (VBScript)
        • RDS Code Examples in Microsoft Visual C++
          • Handler Property Example (VC++)
          • InternetTimeout Property Example (VC++)
        • RDS Code Examples in Microsoft Visual J++
          • Handler Property Example (VJ++)
          • InternetTimeout Property Example (VJ++)
    • ADO MD API Reference
      • ADO MD Object Model
      • ADO MD Objects
        • Axis Object (ADO MD)
          • Properties, Methods, and Events
        • Catalog Object (ADO MD)
          • Properties, Methods, and Events
        • Cell Object (ADO MD)
          • Properties, Methods, and Events
        • Cellset Object (ADO MD)
          • Properties, Methods, and Events
        • CubeDef Object (ADO MD)
          • Properties, Methods, and Events
        • Dimension Object (ADO MD)
          • Properties, Methods, and Events
        • Hierarchy Object (ADO MD)
          • Properties, Methods, and Events
        • Level Object (ADO MD)
          • Properties, Methods, and Events
        • Member Object (ADO MD)
          • Properties, Methods, and Events
        • Position Object (ADO MD)
          • Properties, Methods, and Events
      • ADO MD Collections
        • Axes Collection (ADO MD)
          • Axes Collection Properties, Methods, and Events
        • CubeDefs Collection (ADO MD)
          • CubeDefs Collection Properties, Methods, and Events
        • Dimensions Collection (ADO MD)
          • Dimensions Collection Properties, Methods, and Events
        • Hierarchies Collection (ADO MD)
          • Hierarchies Collection Properties, Methods, and Events
        • Levels Collection (ADO MD)
          • Levels Collection Properties, Methods, and Events
        • Members Collection (ADO MD)
          • Members Collection Properties, Methods, and Events
        • Positions Collection (ADO MD)
          • Positions Collection Properties, Methods, and Events
      • ADO MD Properties
        • ActiveConnection Property (ADO MD)
        • Caption Property (ADO MD)
        • ChildCount Property (ADO MD)
        • Children Property (ADO MD)
        • Depth Property (ADO MD)
        • Description Property (ADO MD)
        • DimensionCount Property (ADO MD)
        • DrilledDown Property (ADO MD)
        • FilterAxis Property (ADO MD)
        • FormattedValue Property (ADO MD)
        • Item Property (ADO MD Cellset)
        • LevelDepth Property (ADO MD)
        • LevelName Property (ADO MD)
        • Name Property (ADO MD)
        • Ordinal Property (ADO MD Cell)
        • Ordinal Property (ADO MD Position)
        • Parent Property (ADO MD)
        • ParentSameAsPrev Property (ADO MD)
        • Source Property (ADO MD)
        • State Property (ADO MD)
        • Type Property (ADO MD)
        • UniqueName Property (ADO MD)
        • Value Property (ADO MD)
      • ADO MD Methods
        • Close Method (ADO MD)
        • Open Method (ADO MD)
      • ADO MD Enumerated Constants
        • MemberTypeEnum
      • ADO MD Code Examples
        • ADO MD Code Examples in Visual Basic
          • Cellset Example (VB)
          • Catalog Example (VB)
        • ADO MD Code Examples in Visual Basic, Scripting Edition
          • Axis Example (VBScript)
          • Members Example (VBScript)
          • CubeDef Example (VBScript)
    • ADOX API Reference
      • ADOX Object Model
      • ADOX Objects
        • Catalog Object (ADOX)
          • Properties, Methods, and Events
        • Column Object (ADOX)
          • Properties, Methods, and Events
        • Group Object (ADOX)
          • Properties, Methods, and Events
        • Index Object (ADOX)
          • Properties, Methods, and Events
        • Key Object (ADOX)
          • Properties, Methods, and Events
        • Procedure Object (ADOX)
          • Properties, Methods, and Events
        • Table Object (ADOX)
          • Properties, Methods, and Events
        • User Object (ADOX)
          • Properties, Methods, and Events
        • View Object (ADOX)
          • Properties, Methods, and Events
      • ADOX Collections
        • Columns Collection (ADOX)
          • Columns Collection Properties, Methods, and Events
        • Groups Collection (ADOX)
          • Groups Collection Properties, Methods, and Events
        • Indexes Collection (ADOX)
          • Indexes Collection Properties, Methods, and Events
        • Keys Collection (ADOX)
          • Keys Collection Properties, Methods, and Events
        • Procedures Collection (ADOX)
          • Procedures Collection Properties, Methods, and Events
        • Tables Collection (ADOX)
          • Tables Collection Properties, Methods, and Events
        • Users Collection (ADOX)
          • Users Collection Properties, Methods, and Events
        • Views Collection (ADOX)
          • Views Collection Properties, Methods, and Events
      • ADOX Properties
        • ActiveConnection Property (ADOX)
        • Attributes Property (ADOX)
        • Clustered Property (ADOX)
        • Command Property (ADOX)
        • DateCreated Property (ADOX)
        • DateModified Property (ADOX)
        • DefinedSize Property (ADOX)
        • DeleteRule Property (ADOX)
        • IndexNulls Property (ADOX)
        • Name Property (ADOX)
        • NumericScale Property (ADOX)
        • ParentCatalog Property (ADOX)
        • Precision Property (ADOX)
        • PrimaryKey Property (ADOX)
        • RelatedColumn Property (ADOX)
        • RelatedTable Property (ADOX)
        • SortOrder Property (ADOX)
        • Type Property (Column) (ADOX)
        • Type Property (Key) (ADOX)
        • Type Property (Table) (ADOX)
        • Unique Property (ADOX)
        • UpdateRule Property (ADOX)
      • ADOX Methods
        • Append Method (ADOX Columns)
        • Append Method (ADOX Groups)
        • Append Method (ADOX Indexes)
        • Append Method (ADOX Keys)
        • Append Method (ADOX Procedures)
        • Append Method (ADOX Tables)
        • Append Method (ADOX Users)
        • Append Method (ADOX Views)
        • ChangePassword Method (ADOX)
        • Create Method (ADOX)
        • Delete Method (ADOX Collections)
        • GetObjectOwner Method (ADOX)
        • GetPermissions Method (ADOX)
        • SetObjectOwner method [ADOX]
        • SetPermissions Method (ADOX)
      • ADOX Enumerated Constants
        • ActionEnum
        • AllowNullsEnum
        • ColumnAttributesEnum
        • InheritTypeEnum
        • KeyTypeEnum
        • ObjectTypeEnum
        • RightsEnum
        • RuleEnum
        • SortOrderEnum
      • ADOX Code Examples
        • ADOX Code Examples in Microsoft Visual Basic
          • Attributes Property Example (VB)
          • Catalog ActiveConnection Property Example (VB)
          • Clustered Property Example (VB)
          • Columns and Tables Append Methods, Name Property Example (VB)
          • Command and CommandText Properties Example (VB)
          • Connection Close Method, Table Type Property Example (VB)
          • Create Method Example (VB)
          • DateCreated and DateModified Properties Example (VB)
          • DefinedSize Property Example (VB)
          • DeleteRule Property Example (VB)
          • GetObjectOwner and SetObjectOwner Methods Example (VB)
          • GetPermissions and SetPermissions Methods Example (VB)
          • Groups and Users Append, ChangePassword Methods Example (VB)
          • Indexes Append Method Example (VB)
          • IndexNulls Property Example (VB)
          • Keys Append Method, Key Type, RelatedColumn, RelatedTable and UpdateRule Properties Example (VB)
          • NumericScale and Precision Properties Example (VB)
          • Parameters Collection, Command Property Example (VB)
          • ParentCatalog Property Example (VB)
          • PrimaryKey and Unique Properties Example (VB)
          • Procedures Append Method Example (VB)
          • Procedures Delete Method Example (VB)
          • Procedures Refresh Method Example (VB)
          • SortOrder Property Example (VB)
          • Views and Fields Collections Example (VB)
          • Views Append Method Example (VB)
          • Views Collection, CommandText Property Example (VB)
          • Views Delete Method Example (VB)
          • Views Refresh Method Example (VB)
        • ADOX Code Examples in Microsoft Visual C++
          • Attributes Property Example (VC++)
          • Catalog ActiveConnection Property Example (VC++)
          • Clustered Property Example (VC++)
          • Columns and Tables Append Methods, Name Property Example (VC++)
          • Command and CommandText Properties Example (VC++)
          • Connection Close Method, Table Type Property Example (VC++)
          • Create Method Example (VC++)
          • DateCreated and DateModified Properties Example (VC++)
          • DefinedSize Property Example (VC++)
          • DeleteRule Property Example (VC++)
          • GetObjectOwner and SetObjectOwner Methods Example (VC++)
          • GetPermissions and SetPermissions Methods Example (VC++)
          • Groups and Users Append, ChangePassword Methods Example (VC++)
          • Indexes Append Method Example (VC++)
          • IndexNulls Property Example (VC++)
          • Keys Append Method, Key Type, RelatedColumn, RelatedTable and UpdateRule Properties Example (VC++)
          • NumericScale and Precision Properties Example (VC++)
          • Parameters Collection, Command Property Example (VC++)
          • ParentCatalog Property Example (VC++)
          • PrimaryKey and Unique Properties Example (VC++)
  • Legal and Copyright Information

next page

Get in touch

Submit feedback about this site to:

• [email protected]