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

Section I: ActiveX Data Objects (ADO)

Microsoft ActiveX Data Objects (ADO)

previous page next page
ADO 2.5

Section I: ActiveX Data Objects (ADO)

This section contains the following chapters:

  • Chapter 1: ADO Fundamentals
  • Chapter 2: Getting Data
  • Chapter 3: Examining Data
  • Chapter 4: Editing Data
  • Chapter 5: Updating and Persisting Data
  • Chapter 6: Error Handling
  • Chapter 7: Handling ADO Events
  • Chapter 8: Understanding Cursors and Locks
  • Chapter 9: Data Shaping
  • Chapter 10: Records and Streams

© 1998-2003 Microsoft Corporation. All rights reserved.

previous page start next page

Menu

  • Homepage

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

Get in touch

Submit feedback about this site to:

  • [email protected]

© documentation.help. Design: rehmann.co.