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

ADO Code Examples in Microsoft JScript

Microsoft ActiveX Data Objects (ADO)

previous page next page
ADO 2.5 Samples

ADO Code Examples in Microsoft JScript

Use the following code examples to learn how to use the ADO methods, properties, and events when writing in JScript.

Note   Paste the entire code example, from beginning to end, into your code editor. The example may not run correctly if partial examples are used or if paragraph formatting is lost.

Methods

  • AddNew Method Example
  • Append and CreateParameter Methods Example
  • Execute, Requery, and Clear Methods Example
  • Find Method Example
  • GetRows Method Example

Properties

  • AbsolutePage, PageCount, and PageSize Properties Example
  • AbsolutePosition and CursorLocation Properties Example
  • ActiveCommand Property Example
  • ActiveConnection, CommandText, CommandTimeout, CommandType, Size, and Direction Properties Example
  • ActualSize and DefinedSize Properties Example
  • CacheSize Property Example
  • Filter and RecordCount Properties Example

See Also

ADO Code Examples in Microsoft Visual Basic | ADO Code Examples in Microsoft Visual Basic Scripting Edition | ADO Code Examples in Microsoft Visual C++ | ADO Code Examples in Microsoft Visual J++

© 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.