ADO: ActiveX Data Objects

By Jason T. Roff
Price: $44.95 USD
£31.95 GBP

Cover | Table of Contents | Colophon

---

Index

[ A ], [ B ], [ C ], [ D ], [ E ], [ F ], [ G ], [ H ], [ I ], [ J ], [ K ], [ L ], [ M ], [ N ], [ O ], [ P ], [ Q ], [ R ], [ S ], [ T ], [ U ], [ V ], [ W ], [ X ], [ Y ]

A[ Top ]
absolute URL, 55
AbsolutePage property, Recordset object, 403
AbsolutePosition property, Recordset object, 122, 404
access permissions, Data Link Properties dialog box, 527
Active Data Connector (ADC), 10
Active Server Pages (ASP), 16
Active Server Pages (see ASP)
ActiveCommand property, Recordset object, 405
ActiveConnection property
      Command object, 295
      Record object, 377
      Recordset object, 102, 104, 405
      trappable errors, 501
ActiveConnection property, Recordset object, 102, 104
ActiveX clients, 14
ActiveX Data Objects (see ADO)
ActiveX objects, 14
ActiveX servers, 14
ActualSize property, Field object, 150, 345
ADC (Active Data Connector), 10
ADCPROP_ASYNCTHREADPRIORITY_ENUM enumeration, 536
ADCPROP_AUTORECALC_ENUM enumeration, 537
ADCPROP_UPDATECRITERIA_ENUM enumeration, 537
ADCPROP_UPDATERESYNC_ENUM enumeration, 538
AddErrorToList, Errors Collection code example, 513
AddNew method
      ADO Data Control example, 533
      Recordset object, 128-130, 406
AddToErrorList method, Errors Collection code example, 509
ADO (ActiveX Data Objects)
      COM, relationship to, 14
      creating
            JScript, 47
            VBScript, 44
            Visual Basic, 32
            Visual C++, 37
            Visual J++, 41
      DAO object model, compared to, 9
      ODBC and, 9
      referencing
            JScript, 47
            VBScript, 44
            Visual Basic, 32
            Visual C++, 36
            Visual J++, 41
      UDA, relationship to, 4
      when to use, 15-18
ADO Data Control
      Data Link Properties dialog box
            Advanced tab, 525-527
            All tab, 527
            Connection String property dialog box, 518
            Provider tab, 520-525
      example
            adding new records, 533
            closing code, 532
            control settings, 530
            deleting records, 533
            properties, setting, 529
      Property Pages, 516-518
ADO Error(s) form, Errors Collection code example, 510
ADO Event Model
      canceling operations, 212
      Complete events, 183
      ConnectionEvent family
            categories, 184
            Connection events, 185-191
            Execution events, 191-195
            Information events, 198
            Transaction events, 195-198
      RecordsetEvent family
            categories, 184, 199
            Field Change events, 207
            Movement events, 201-207
            Record Change events, 209-211
            Record set Change events, 211
            Retrieval events, 200
      Standalone events, 183
      turning off events, 213
      Will events, 183
      Will/Connect pairs, 183
ADODB
      classes, 32
      prefixes, 33
adojava.inc file, 47
ADO.NET
      DataSet, 277
      disconnected data, 278
      managed providers, 278
      strongly typed language, 279
      XML integration, 279
adovbs.inc file, 44
ADSDSOObject (Microsoft OLE DB provider for Microsoft Active Directory Service), 70
Advanced tab, Data Link Properties dialog box, 525-527
AffectEnum enumeration, 539
      Recordset object, 111
ALL keyword, SQL, 463, 473
All tab, Data Link Properties dialog box, 527
ALTER TABLE clause, SQL, 478
ANSI SQL (see SQL)
ANY function, data shaping, 227
APPEND command, data shaping, 218-222
Append method
      Fields collection, 351
      Fields collection object, 145
      Parameters collection, 363
      Recordset object, 145
AppendChunk method
      Field object, 151, 345
      Parameter object, 358
      Recordset object, 169
Application EXE project, creating, 34
applications
      redistributing, 32
      when to integrate ADO technology, 15
architecture, ADO
      Command object, 22-24
      Connection object, 21
      DAO, compared to, 20
      ease of use, 20
      framework, 19
      RDO, compared to, 20
      Record object, 26
      Recordset object, 24-26
      Stream object, 27
arguments
      trappable errors, 502
array datatype, 146
AS keyword, SQL, 463
ASC keyword, SQL, 469
ASP (Active Server Pages), 12, 16
      .asp file extension, 45, 48
      VBScript, relationship to, 43
.asp file extension, 45, 48
ASP.NET, Microsoft .NET Framework, 276
asterisk (*), SQL, 465
asynchronous command execution, 177-180
Attributes property
      Connection object, 82, 316
      Field object, 155-157, 346
      Parameter object, 359
      Property object, 370
      Properties collection, 482
authentication service, 525
Authentication tab, ADO Data Control Property Pages, 517
Authors table, Biblio.mdb, 92
Automation
      COM and, 13
automation objects, 11
Automation Variant datatype, 147
AVG function, data shaping, 227
AVG function, SQL, 464

B[ Top ]
batch optimistic record locking, 138-141
batch update mode, Recordset object, 26
batch updates, 152-155
Beginning of File (BOF) property, Recordset object, 115
BeginTrans method, Connection object, 78-79, 316
BeginTransComplete event
      ADO Event Model, 195-198
      Connection object, 317
BETWEEN...AND... clause, SQL, 467
BiblioDSN, 58
Biblio.mdb database, 34, 38, 42, 45, 48
binary value datatype, 146, 147
binding
      DataControl object, 271
      VBScript, 45, 47
BOF (Beginning of File) property, 115
      Recordset object, 407
Bookmark property
      Record object, 123-127
      Recordset object, 408
BookmarkEnum enumeration, 540
Boolean value datatype, 146
business components, OLE DB, 7

C[ Top ]
C# (Unified Programming Language), Microsoft .NET Framework, 276
CacheSize property, Recordset object, 107, 408
caching, client-side, 10
CALC function, data shaping, 227
Cancel method
      Command object, 180-182, 296
      Connection object, 318
      DataControl object, 268
      Record object, 378
      Recordset object, 409
      Stream object, 448
Cancel property, Properties collection code example, 496
CancelBatch method
      warnings, 505
      Recordset object, 409
canceling operation, ADO Event Model, 212
CancelUpdate method
      DataControl object, 268
      Fields collection, 352
      Recordset object, 130-133, 410
Case statement
      code example, 509
ChangeFieldComplete event, ADO Event Model, 207
ChangeRecordComplete event, ADO Event Model, 209-211
ChangeRecordsetComplete event, ADO Event Model, 211
chapters, hierarchical recordsets, 216
CharSet property, Stream object, 448
CheckQueryType method, 88
Class1.java file, 42
Clear method, Errorscollection, 338
ClearContents method, data shaping code example, 231
clients, ActiveX, 14
client-side caching, 10
Clone method, Recordset object, 114, 410
Close button, Errors Collection code example, 508
Close method
      Connection object, 318
      Record object, 378
      Recordset object, 411
      Stream object, 449
closing connections, 54
cmdClose_Click event
      cursor code example, 99
      Properties collection code example, 484
cmdCommand_Click event, Properties collection code example, 484-485
cmdConnection_Click event, Properties collection code example, 484
cmdCursorType_Click event, cursor code example, 99
cmdDelete_Click event, ADO Data Control example, 533
cmdField_Click event, Properties collection code example, 486
cmdOK command, Properties collection code example, 499
cmdRecordset_Click event, Properties collection code example, 485
columns
      characteristics, 216
COM (Component Object Model), 4, 9
      ADO, relationship to, 14
      Automation, 13
      binary specification, 13
Command Information dialog box, control settings, 496
Command object, 22-24
      ActiveConnection property, 164, 295
      asynchronous command execution, 177-180
      Cancel method, 180-182, 296
      CommandStream property, 296
      CommandText property, 297
      CommandTimeout property, 297
      CommandType property, 298
            stored procedures, 161
            table names, 161
            textual definitions, 159
            unknown, 162
      CommandTypeEnum enumeration, 159
      Connection object, relationship to, 22, 52
      CreateParameter Method, 298
      Dialect property, 299
      Execute method, 163-165, 300
      ExecuteOptionEnum enumeration, 163
      Name property, 301
      NamedParameters property, 301
      parameters
            passing, 167-170
            properties, 170
            specifying, 171
      Parameters collection, 302
            code example, 172-177
            CreateParameter method, 171
            Parameter object properties, 170
            ParameterDirectionEnum enumeration, 171
            Refresh method, 168
      Prepared property, 302
      Properties collection, 28, 303, 481
      Record object, opening with, 237-239
      Recordset object, relationship to, 24
      State property, 303
      trappable errors, 501
      usage, 290-295
CommandStream property, Command object, 296
CommandText property
      Command object, 297
      Properties collection code example, 495
CommandText text box, Properties collection code example, 497
CommandTimeout property
      Command object, 297
      Connection object, 76, 318
CommandType property
      Command object, 298
      stored procedures, 161
      specifying for recordsets, 518
      table names, 161
      textual definitions, 159
      unknown, 162
CommandTypeEnum enumeration, 540
      Command object, 159
      Recordset object, 103
CommitTrans method, Connection object, 78-79, 316
CommitTransComplete event
      ADO Event Model, 195-198
      Connection object, 319
Common Language Runtime, Microsoft .NET Framework, 275
com.ms.wfc.data package, 539
CompareBookmark property, Record object, 124
CompareBookmarks method, Recordset object, 412
CompareEnum enumeration, 541
comparison operators, SQL, 466
Complete event, ADO Event Model, 183
COMPUTE command, data shaping, 223-226
Connect property, DataControl object, 268
ConnectComplete event
      ADO Event Model, 185-191
      Connection object, 320
Connection
      trappable errors, 501
Connection Information dialog box, control settings, 489
Connection object, 21
Connection String property dialog box, 518
Connection String text box, Properties collection code example, 490
connection strings
      arguments, 55
      ConnectionString property, 56
      DSN-less versus DSN-based, 521
      opening connection objects, code example, 56
      specifying, 517
Connection text box, Properties collection, code example, 491
ConnectionEvent family, ADO Event Model
      categories, 184
      Connection events, 185-191
      Execution events, 191-195
      Information events, 198
      Transaction events, 195-198
connections
      access permission settings, 527
      closing, 54
      ConnectionTimeout property, 63, 66
      CursorLocation property, 63, 68
      DefaultDatabase property, 62, 64
      impersonation settings, 526
      Mode property, 62
      opening
            explicit, 52
            implicit, 51
      protection level settings, 526
      specifying source of, 516
      State property, 69
      testing, 521
      Version property, 69
ConnectionString property
      Connection object, 165, 320
      Properties collection, code example, 491
ConnectionTimeout property
      Connection object, 63, 66, 321
      Data Link Properties dialog box, 526
ConnectModeEnum enumeration, 541
ConnectOptionEnum enumeration, 542
ConnectPromptEnum enumeration, 543
CONSTRAINT clause, SQL, 479
ConvertToString method, DataFactory object, 265
CopyRecord method, Record object, 247, 378
CopyRecordOptionsEnum enumeration, 543
CopyTo method, Stream object, 449
COUNT function, data shaping, 227
COUNT function, SQL, 465
Count property
      Errors collection, 338
      Fields collection, 353
      Fields collection object, 144
      Parameters collection, 364
      Properties collection, 366, 481
.cpp file file, 38
CREATE INDEX statement, SQL, 479
CREATE TABLE statement, SQL, 478
CreateInstance function, Visual C++, 37
CreateObject function
      JScript, 48
      VBScript, 45
CreateObject method, DataSpace object, 263
CreateParameter Method, Command object, 171, 298
CreateRecordset method
      data shaping code example, 231
      DataControl object, 268
      DataFactory object, 265
Criteria argument, Find method, 113
currency datatype, 146
CursorLocation property
      Connection object, 63, 68, 321
      Properties collection code example, 491
      Recordset object, 105, 108, 412
CursorLocationEnum enumeration, 544
CursorOptionEnum enumeration, 100, 545
cursors
      code example, 96-101
      CursorOptionEnum, 100
      CursorType property, 93
      CursorTypeExample, control settings, 97-99
      dynamic, 93
      forward-only, 96
      keyset, 94
      specifying type, 167
      static, 95
      types of, 25
      viewing records with, 92
CursorType property
      Properties collection code example, 494
      Recordset object, 102, 413
CursorTypeEnum enumeration, 546

D[ Top ]
Data Access Objects (DAO), 4
      ADO, compared to, 20
data consumer component, OLE DB, 7
data conversion
      trappable errors, 501, 504
Data Link File (.UDL), 516, 527
Data Link Properties dialog box
      Advanced tab, 525-527
      All tab, 527
      Connection String property dialog box, 518
      Provider tab, 520-525
data provider component, OLE DB, 7
data providers, 70-72
      Data Link Properties dialog box
            Jet, 520
            ODBC, 521
            OLE DB, 524
            Oracle, 522
            SQL Server, 521
data retrieval
      trappable errors, 501
data service provider component, OLE DB, 7
data shaping
      ANY function, 227
      APPEND command, 218-222
      AVG function, 227
      CALC function, 227
      code example, 227-235
      column characteristics, 216
      COMPUTE command, 223-226
      COUNT function, 227
      MAX function, 227
      Microsoft Data Shaping Service, 217
      MIN function, 227
      STDEV function, 227
      SUM function, 227
      VBA functions, 227
Data Source Name, 516, 521 (see also DSN)
Data Space object, RDS, 262-264
data updating, types of, 26
Database Management System (DBMS), 4
database modification, 477
DataControl object, RDS, 267-272
DataFactory object, RDS, 264-267
DataField property, 530
DataFormat property, Field object, 346
DataMember property, Recordset object, 414
data-provider errors (see Errors collection), 505
data-provider names, Connection objects, 21
DataSource property, 530
      Recordset object, 414
DataTypeEnum enumeration, 547-549
      Field object, 145-147
DataTypeEnum value, 481
datatypes, 145-150, 151
date datatype, 146
date-time datatype, 146
dBase, 71
dBase databases, 4
DBMS (Database Management System), 4
DCOM protocol, 262
default data provider, 71
Default Stream field, Stream object, 252
DefaultDatabase property, Connection object, 62, 64, 322
DefinedSize property, Field object, 150, 347
DELETE clause, SQL, 477
Delete method
      Fields collection, 353
      Fields collection object, 145
      Parameters collection, 364
      Record object, 248
      Recordset object, 414
DeleteRecord method, Record object, 379
DESC keyword, SQL, 469
Description property, Error object, 335
Dialect property, Command object, 299
Direction property, Parameter object, 359
Disconnect event
      ADO Event Model, 185-191
      Connection object, 322
DisplayProperties method, Properties collection code example, 485, 486
DISTINCT keyword, SQL, 463
DISTINCTROW predicate, SQL, 464, 472
double-precision floating-point data type, 146
drivers, ODBC-compliant, 71
DROP statement, SQL, 480
DSN (Data Source Name), 516, 521
      installing, 58-61
      opening connections with, 60
dynamic cursors, 25, 93

E[ Top ]
EditMode property, Recordset object, 132, 415
EditModeEnum enumeration, 549
      Recordset object, 132
End of File (EOF) property
      Recordset object, 115, 407
EndOfRecordset event
      ADO Event Model, 201-207
      Recordset object, 416
EOF (see End of File property)
EOS property, Stream object, 450
Error object, 29
      Description property, 335
      HelpContext property, 335
      HelpFile Property, 335
      NativeError property, 336
      Number property, 336
      Source property, 336
      SQLState property, 337
      usage, 333-335
errors
      trappable, 500-505
      Visual Basic, 500
Errors Collection, 29
      Clear method, 338
      Connection object, 323
      Count property, 338
      Error object properties, 505
      Examples
            AddErrorToList function, 513
            AddToErrorList method, 509
            ADO Error(s) form, 506, 510
            Close button, 508
            control settings, ADO Error(s) form, 511
            control settings, Errors Collection form, 508
            frmDisplayADOError form, 512
            frmErrorsCollectionExample form, 507
            GenerateError method, 509
            IsAnADORelatedError method, 510, 513
            ItemData property, 508
            LastDLLError property, 514
            Ok button, 508
            PopulateErrors method, 508
            TVBAError type, 512
      Item property, 338
      Refresh method, 339
      usage, 337
ErrorValueEnum enumeration, 550-554
EventReasonEnum enumeration, 211, 554
EventStatusEnum enumeration, 187, 189, 555
Execute method
      Command object, 163-165, 300
      Connection object, 73-76, 166, 323
ExecuteComplete event
      ADO Event Model, 191-195
      Connection object, 325
ExecuteOption property, DataControl object, 268
ExecuteOptionEnum enumeration, 556
      Command object, 163
execution, canceling, 502

F[ Top ]
FetchComplete event
      ADO Event Model, 200
      Recordset objec, 416
FetchOptions property, DataControl object, 268
FetchProgress event
      ADO Event Model, 191, 200
      Recordset object, 417
Field Information dialog box, control settings, 498
Field object, 26
      ActualSize property, 345
      AppendChunk method, 151, 345
      Attributes property, 155-157, 346
      DataFormat property, 346
      DataTypeEnum enumeration, 145-147
      DefinedSize property, 150, 347
      FieldAttributeEnum enumeration, 155
      GetChunk method, 151, 347
      Name property, 143, 348
      NumericScale property, 150, 348
      OriginalValue property, 153, 348
      Precision property, 149, 349
      PrintFieldDataType function, 149
      Properties collection, 28, 349, 481
      Status property, 349
      Type property, 147, 350
      UnderlyingValue property, 153, 350
      usage, 339-345
      Value property, 144, 350
FieldAttributeEnum enumeration, 557
      Field object, 155
FieldChangeComplete event, Recordset object, 417
FieldEnum enumeration, 251, 558
fields
      trappable errors, 501
Fields collection, 26
      Append method, 351
      CancelUpdate method, 352
      Count property, 353
      Delete method, 353
      Item property, 353
      Record object, 249-252, 380
      Recordset object, 418
      Refresh method, 354
      Resync method, 354
      Update method, 354
      usage, 351
Fields collection object
      Append method, 145
      Count property, 144
      Delete method, 145
      Field object, 143
      Item method, 144
FieldStatusEnum enumeration, 558
File DSN, 521
filenames, Connection object, 21
files
      trappable errors, 502, 504
Filter property, Recordset object, 109, 419
FilterColumn property, DataControl object, 268
FilterCriterion property, DataControl object, 269
FilterGroupEnum enumeration, 560
      Recordset object, 110
FilterValue property, DataControl object, 269
Find method, Recordset object, 113, 420
fixed precision numeric datatype, 147
floating-point datatype, 146
Flush method, Stream object, 450
Form_Load event
      data shaping code example, 229
      Properties collection code example, 488, 490, 494
Form_Load procedure, Properties collection code example, 497
Form_Unload event, data shaping code example, 229
forward-only cursor, 25, 96
frmCommand form, Properties collection code example, 485, 495
frmConnection form, Properties collection code example, 484, 488
frmDisplayADOError form, Errors Collection code example, 512
frmErrorsCollectionExample form, 507
frmField form, Properties collection code example, 486, 497
frmPropertiesExample form, Properties collection code example, 488
frmRecordset form, Properties collection code example, 485, 491

G[ Top ]
GenerateError method, Errors Collection code example, 509
GetAttributes method, Properties collection code example, 487
GetChildren method, Record object, 245, 380
GetChunk method, Field object, 151, 347
GetPropertyType method, Properties collection code example, 487
GetRows method, Recordset object, 134, 420
GetRowsOptionEnum enumeration, 561
GetString method, Recordset object, 135, 421
globally unique identifier (GUID), 146
grandchild aggregates, 217
GROUP BY clause, SQL, 468
GUID (globally unique identifier), 146

H[ Top ]
Handler property, DataControl object, 269
HAVING clause, SQL, 468
HelpContext property, Error object, 335
HelpFile Property, Error object, 335
hierarchical recordsets, 216
hierarchies
      navigating, 245
HTTP, 262
HTTPS, 262

I[ Top ]
IE data-access technology, 11
IIS (Internet Information Server), 16
      VBScript, 44
immediate update mode, Recordset object, 26
impersonation level, Data Link Properties dialog box, 526
#import keyword, Visual C++, 36
import statement
      Visual C++, 36
      Visual J++, 41
IN keyword, SQL, 467
Index property, Recordset object, 422
InfoMessage event
      ADO Event Model, 198
      Connection object, 325
INNER JOIN clause, SQL, 471
INSERT...INTO clause, SQL, 475
instantiation
      Visual Basic objects, 33
integer datatype, 146
internal constants
      trappable errors, 504
Internet Explorer
      auto-download features, 11
Internet Information Server (IIS), 16
Internet Publishing, OLE DB provider, 27
InternetTimeout property
      DataControl object, 269
      DataSpace object, 263
IsAnADORelatedError method, Errors Collection code example, 510, 513
IsolationLevel property, Connection object, 82, 83, 326
IsolationLevelEnum enumeration, 562
Item method, Properties collection, 481
Item property
      Errors collection, 338
      Fields collection, 353
      Fields collection object, 144
      Parameters collection, 364
      Properties collection, 366
ItemData property, Errors Collection code example, 508

J[ Top ]
Java, 9
JavaScript, 9, 15
Jet Biblio database (see Bibilo.mdb database)
Jet Database Engine, 4
Jet providers, Data Link Properties dialog box, 520
joining tables, SQL, 470
JScript
      code example, ActiveX Data Objects, 48-50
      creating ActiveX Data Objects, 47
      referencing ActiveX Data Objects, 47

K[ Top ]
keyset cursors, 25, 94

L[ Top ]
language-independent development, 9
large datatypes, 151
LastDLLError property, Errors Collection code example, 514
late binding, 47
LEFT JOIN clause, SQL, 471
LineSeparator property, Stream object, 450
LineSeparatorEnum enumeration, 562
LoadFromFile method, Stream object, 451
locking scheme, specifying, 167
LockType property
      Properties collection code example, 495
      Recordset object, 102, 423
LockTypeEnum enumeration, 135, 563
logical And operator, 155
long binary datatype, 146
long String datatype, 146

M[ Top ]
Machine DSN, 521
MAPI, 16
MarshalOptions property, Recordset object, 423
MarshalOptionsEnum enumeration, 564
MAX function, data shaping, 227
MAX function, SQL, 465
MaxRecords property, Recordset object, 107, 424
MDAC (Microsoft Data Access Components), 3
      dependencies, 12
      redistributable package, 32
.MDB file extension, 4
Microsoft Access, 71, 151
Microsoft Access 1.1, 4
Microsoft ActiveX Data Objects 2.1 Library, 228
Microsoft ActiveX Data Objects Library
      ADODB classes, 32
      referencing, 32
Microsoft Data Access Components (see MDAC)
Microsoft Data Shaping Service, 217
      for OLE DB (MSDataShape), 70
Microsoft Excel, 4, 71
Microsoft FoxPro, 71
Microsoft Jet Engine SQL (see SQL)
Microsoft .NET Framework
      ADO.NET
            DataSet, 277
            disconnected data, 278
            managed providers, 278
            strongly typed language, 279
            XML integration, 279
      ASP.NET, 276
      C# (Unified Programming Language), 276
      Common Language Runtime, 275
Microsoft OLE DB, 70
Microsoft SQL Server, 71
Microsoft Windows Common Controls 6.0, 228
Microsoft Word, 13
MicrosoftJetOLEDB.4.0 (OLE DB provider for Microsoft Jet), 70
MIN function
      data shaping, 227
      SQL, 465
Mode property
      Connection object, 62, 326
      Record object, 380
      Stream object, 451
Move method
      Record object, 125-127
      Recordset object, 424
MoveComplete event
      ADO Event Model, 201-207
      Recordset object, 425
MoveFirst method
      DataControl object, 269
      Recordset object, 116-118, 426
MoveLast method
      DataControl object, 269
      Recordset object, 116-118, 426
MoveNext method
      DataControl object, 269
      Recordset object, 116-118, 426
MovePrevious method
      DataControl object, 269
      Recordset object, 116-118, 426
MoveRecord method, Record object, 248, 381
MoveRecordOptionsEnum enumeration, 564
MS Hierarchical Flex Grid, 227
MSADO15.DLL file, 38
MSDAIPP.DSO (Microsoft OLE DB provider for Internet Publishing), 70
MSDAORA (Microsoft OLE DB provider for Oracle), 70
MSDASQL.1 (Microsoft OLE DB provider for ODBC), 70
MSDataShape (Microsoft Data Shaping Service for OLE DB), 70
MSIDXS (Microsoft OLE DB provider for Microsoft Indexing Service), 70
MSPersist (Microsoft OLE DB Persistence Provider), 70
MSRemote (Microsoft OLE DB Remoting Provider), 70

N[ Top ]
Name property
      Command object, 301
      Field object, 143, 348
      Parameter object, 360
      Property object, 371
      Properties collection, 481
NamedParameters property, Command object, 301
NativeError property, Error object, 336
nested SQL statements, 472
nested transactions, 81
New keyword, instantiating Recordset object with, 102
NextRecordset method, Recordset object, 115, 427
non-NULL values, SQL, 465
NOT keyword, SQL, 467
NOT NULL keyword, SQL, 478
NULL values, SQL, 465
null-terminated Unicode character-string datatype, 147
Number property, Error object, 336
numeric datatype, 146
NumericScale property
      Field object, 150, 348
      Parameter object, 360

O[ Top ]
Object Linking and Embedding Databases (see OLE DB)
objects
      ActiveX, 14
      removing from memory, 33, 37, 41, 45, 48
      trappable errors, 502
ObjectStateEnum enumeration, 565
      Recordset object, 106
ODBC (Open Database Connectivity), 3
      Data Source Administrator, 516
      specifying Microsoft OLE DB provider for, 71
ODBC providers, Data Link Properties dialog box, 521
ODBCDirect, 6
OK button, Errors Collection code example, 508
OLE Automation (see Automation)
OLE DB (Object Linking and Embedding Databases), 3
      data providers, 70-72
      Visual C++, 37
      components, 7
      features, 7
      providers
            Data Link Properties dialog box, 524
            for Internet Publishing, 249
            for Microsoft Jet (MicrosoftJetOLEDB.4.0), 70
      standardization, 8
On Error statement, Visual Basic, 500
onError event, DataControl object, 269
onReadyStateChange event, DataControl object, 269
Open Database Connectivity (see ODBC)
Open method
      Connection object, 327
      Record object, 237, 382
      Recordset object, 102-104, 428
      Stream object, 452
open table-type statement
      Command object type, 23
opening connections
      explicit, 52
      implicit, 51
OpenSchema method
      code example, 85-91
      Connection object, 328
      syntax, 86
OpenTable method, DAO, 23
optimistic record locking, 137
Options parameter, Recordset object, 103
Oracle, 4
Oracle databases, 71
Oracle providers, Data Link Properties dialog box, 522
ORDER BY clause, SQL, 464, 469
OriginalValue property, Field object, 153, 348
outer joins, SQL, 471

P[ Top ]
PageCount property, Recordset object, 127, 429
PageSize property, Recordset object, 127, 430
Paradox, 71
Parameter object
      AppendChunk method, 358
      Attributes property, 359
      Direction property, 359
      Name property, 360
      NumericScale property, 360
      Precision property, 361
      Properties collection, 361
      Size property, 361
      Type property, 362
      usage, 355-358
      Value property, 362
ParameterAttributesEnum enumeration, 565
ParameterDirectionEnum enumeration, 566
parameterized query
      Command object type, 23
parameters
      passing, 167-170
      properties, 170
      specifying, 171
      trappable errors, 502
PARAMETERS clause, SQL, 474
Parameters collection
      Append method, 363
      code example, 172-177
      Command object, 302
      Command object, relationship to, 23
      Count property, 364
      CreateParameter method, 171
      Delete method, 364
      Item property, 364
      Parameter object properties, 170
      ParameterDirectionEnum enumeration, 171
      Refresh method, 168, 365
      usage, 362
ParentCatalog
      trappable errors, 501
ParentURL property, Record object, 383
password (PWD), 71
passwords
      blank, 521
      Connection objects, 21
PERCENT keyword, SQL, 470
permissions
      trappable errors, 504
      specifying, 64
PersistFormatEnum enumeration, 566
pessimistic record locking, 136
pointer datatype, 146
PopulatCustomersList method, data shaping code example, 232
PopulateErrors method, Errors Collection code example, 508
PopulateOrderDetailInformation method, data shaping code example, 234
Position property, Stream object, 453
PositionEnum enumeration,Record object, 123
Precision property
      Field object, 349
      Parameter object, 361
Precision property, Field object, 149
Prepared property, Command object, 302
PrintFieldDataType function, Field object, 149
PrintRecordState subroutine, Recordset object, 106
PrintStatus method, 186-187
PROCEDURE clause, SQL, 474
Properties collection, 28
Property object
      Attributes property, 370
      Name property, 371
      Type property, 371
      usage, 366-370
      Value property, 371
PropertyAttributesEnum value, 482
protection level, Data Link Properties dialog box, 526
Provider property, Connection object, 329
Provider tab, Data Link Properties dialog box, 520-525
providers
      trappable errors, 501
PWD (password), 71

Q[ Top ]
Query method, DataFactory object, 265
query, parameterized, 23

R[ Top ]
RDBMS (Relational Database Management Systems), 4
RDO (Remote Data Objects), 5
      ADO, compared to, 20
RDS (Remote Data Service), 4, 10, 54
      Attributes property, 83
      code example, 272
      CursorLocation property, 69
      DataControl object, 267-272
      DataFactory object, 264-267
      DataSpace object, 262-264
      DefaultDatabase property, 64
      middle tier functionality, 261
      Recordset object, 95
Read method, Stream object, 453
read-only record locking, 136
ReadText method, Stream object, 454
ReadyState property, DataControl object, 269
record locking
      batch optimistic, 138-141
      LockTypeEnum enumeration, 135
      optimistic, 137
      pessimistic, 136
      read-only, 136
Record object, 26
      ActiveConnection property, 377
      Cancel method, 378
      Close method, 378
      Command object, opening with, 237-239
      CopyRecord method, 247, 378
      Delete method, 248
      DeleteRecord method, 379
      Fields collection, 249-252, 380
      GetChildren method, 245, 380
      Mode property, 380
      MoveRecord method, 248, 381
      navigating hierarhical data sources with, 236
      Open method, 237, 382
      ParentURL property, 383
      Properties collection, 249, 383
      Recordset object, opening with, 240
      RecordType property, 383
      Source argument, 237
      Source property, 384
      SQL statements, opening with, 239
      State property, 384
      Stream object, opening with, 253
      Stream object, relationshp to, 27
      table names, opening with, 240
      URL, opening with, 242-245
      usage, 371-377
record pointers
      AbsolutePosition property, 122
      Beginning of File property, 115
      Bookmark property, 123-127
      CompareBookmark property, 124
      End of File property, 115
      Move Example, 118-122
      Move method, 125-127
      MoveFirst method, 116-118
      MoveLast method, 116-118
      MoveNext method, 116-118, ??-118
      MovePrevious method, 116-118
      PageCount property, 127
      PageSize property, 127
      PositionEnum enumeration, 123
      Record Count property, 122
      trappable errors, 502
RecordChangeComplete event, Recordset object, 431
RecordCount property
      Record object, 122
      Recordset object, 432
RecordCreateOptionsEnum enumeration, 568
RecordOpenOptionsEnum enumeration, 569
Recordset Information dialog box, control settings, 492
Recordset object, 24-26
      record locking
            batch optimistic, 138-141
            optimistic, 137
            pessimistic, 136
            read-only, 136
      opening with, 240
Recordset property, DataControl object, 270
RecordsetChangeComplete Event, Recordset object, 431
RecordsetEvent family, ADO Event Model
      categories, 184, 199
      Field Change events, 207
      Movement events, 201-207
      Record Change events, 209-211
      Recordset Change events, 211
      Retrieval events, 200
recordsets
      chapter, 216
      grandchild aggregates, 217
      hierarchical, 216
      parents and children, 216
      reshaping, 217
RecordSource tab, ADO Data Control Property Pages, 517
RecordStatusEnum enumeration, 569
RecordType property, Record object, 383
RecordTypeEnum enumeration, 571
RecordURL field, Field objects, 251
redistribution, of applications, 32
Refresh method
      Command object, 168
DataControl object, 270
      Errors collection, 339
      Fields collection, 354
      Parameters collection, 365
      Properties collection, 366, 481
Relational Database Management Systems (RDBMS), 4
Remote Data Objects (RDO), 5
Remote Data Service (see RDS)
Remote Procedure Call (RPC), 526
Requery method, Recordset object, 433
Reset method, DataControl object, 270
reshaping, 217
Resync method
      Fields collection, 354
      Recordset object, 111-113, 433
      warnings, 505
ResyncEnum enumeration, 571
RIGHT JOIN clause, SQL, 471
RollbackTrans method, Connection object, 80, 316
RollbackTransComplete event
      ADO Event Model, 195-198
      Connection object, 330
RPC (Remote Procedure Call), 526

S[ Top ]
Save method, Recordset object, 104, 434
SaveOptionsEnum enumeration, 572
SaveToFile method, Stream object, 454
SchemaEnum enumeration, 572-580
scripting languages, 9
search engines, 10
SearchDirection argument, Find method, 113
SearchDirectionEnum enumeration, 580
Seek method, Recordset object, 435
SeekEnum enumeration, 581
SELECT ALL statement, SQL, 463
Select Data Link File dialog box, 527
SELECT DISTINCT statement, SQL, 463
SELECT statement
      data shaping code example, 232
      SQL, 462
Server property, DataControl object, 270
servers
      ActiveX, 14
      trappable errors, 501
server-side automation objects, 10
SetEOS method, Stream object, 455
shaping
      ANY function, 227
      APPEND command, 218-222
      AVG function, 227
      CALC function, 227
      code example, 227-235
      COMPUTE command, 223-226
      COUNT function, 227
      MAX function, 227
      MIN function, 227
      STDEV function, 227
      SUM function, 227
      VBA functions, 227
sharing restrictions
      trappable errors, 501
single precision floating-point datatype, 147
Size property
      Parameter object, 361
      Stream object, 455
sizes, field, 150
SkipLine method, Stream object, 455
SkipRows argument, Find method, 113
Sort property, Recordset object, 111, 436
SortColumn property, DataControl object, 270
SortDirection property, DataControl object, 270
Source argument, Record object, 237
Source property
      Error object, 336
      Properties collection code example, 495
      Record object, 384
      Recordset object, 102, 436
SourceRecordset property, DataControl object, 270
sources, establishing connections to, 516
SpaceOrderDetailColumns method, data shaping code example, 230
SQL property, DataControl object, 270
SQL Server, 4, 15
SQL Server 7.0, 522
SQL Server providers, Data Link Properties dialog box, 521
SQL statements
      Command object type, 22
      executing with Command objects, 159
      Record object, opening with, 239
SQL (Structured Query Language)
      ALL keyword, 463, 473
      ALTER TABLE clause, 478
      AS keyword, 463
      ASC keyword, 469
      asterisk (*) in SQL SELECT statement, 465
      AVG function, 464
      BETWEEN...AND... clause, 467
      comparison operators, 466
      CONSTRAINT clause, 479
      COUNT function, 465
      CREATE INDEX statement, 479
      CREATE TABLE statement, 478
      DELETE clause, 477
      DESC keyword, 469
      differences betwen specifications, 461
      DISTINCT keyword, 463
      DISTINCTROW predicate, 464, 472
      DROP statement, 480
      GROUP BY clause, 468
      HAVING clause, 468
      IN keyword, 467
      INNER JOIN clause, 471
      INSERT INTO clause, 475
      LEFT JOIN clause, 471
      MAX function, 465
      MIN function, 465
      NOT keyword, 467
      NOT NULL keyword, 478
      NULL values, 465
      ORDER BY clause, 464, 469
      PARAMETERS clause, 474
      PERCENT keyword, 470
      PROCEDURE clause, 474
      RIGHT JOIN clause, 471
      SELECT ALL statement, 463
      SELECT DISTINCT statement, 463
      SELECT statement, 462
      STDEV function, 465
      STDEVP function, 465
      SUM function, SQL, 466
      TABLE keyword, 473
      TOP predicate, 464, 469
      UNION keyword, 473
      UPDATE clause, 476
      VAR function, 466
      VARP function, 466
      WHERE clause, 466
      WITH OWNERACCESS OPTION, 475
SQLNorthwindDSN, 58
SQLOLEDB (Microsoft OLE DB provider for SQL Server), 70
SQLState property, Error object, 337
Standalone events, ADO Event Model, 183
standard deviation of a population (see STDEVP function, SQL), 466
standard deviation of a sample (see STDEV function, SQL), 465
Start argument, Find method, 113
State property
      Command object, 303
      Connection object, 69, 330
      Record object, 384
      Recordset object, 105, 437
      Stream object, 456
static cursor, 26, 95
static HTML pages, 44
Status property
      Field object, 349
      Recordset object, 437
StayInSync property, Recordset object, 438
STDEV function
      data shaping, 227
      SQL, 465
STDEVP function
      SQL, 465
storage volumes
      trappable errors, 504
stored procedure
      Command object, 161
      Command object type, 23
Stream object, 27
      binary data, 257
      Cancel method, 448
      CharSet property, 448
      Close method, 449
      CopyTo method, 449
      Default Stream field, 252
      EOS property, 450
      Flush method, 450
      LineSeparator property, 450
      LoadFromFile method, 451
      Mode property, 451
      Open method, 452
      opening in memory, 253
      persistence, 258
      Position property, 453
      Read method, 453
      ReadText method, 454
      Record object, opening with, 253
      retrieval methods, 252
      SaveToFile method, 454
      SetEOS method, 455
      Size property, 455
      SkipLine method, 455
      State property, 456
      textual data, 254-257
      Type property, 456
      URL, opening with, 253
      usage, 443-448
      Write method, 456
      WriteText method, 457
StreamOpenOptionsEnum enumeration, 581
StreamReadEnum enumeration, 582
StreamTypeEnum enumeration, 582
StreamWriteEnum enumeration, 583
string command
      Command object type, 23
string datatype, 146, 147
StringFormatEnum enumeration, 583
structure datatype, 147
SubmitChanges method
      DataControl object, 270
      DataFactory object, 265
subqueries, SQL, 472
SUM function
      data shaping, 227
      SQL, 466
Supports method, Recordset object, 123, 438

T[ Top ]
TABLE keyword, SQL, 473
table names
      Command object, 161
      Record object, opening with, 240
textual definitions, Command object, 159
timeout, specifying for ADO, 66
.tlh (Type Library Header) file extension, 36
.tli (Type Library Implementation) file extension, 36
TOP predicate, SQL, 464, 469
transaction management
      Attributes property, 82
      BeginTrans method, 78-79
      CommitTrans method, 78-79
      nested transactions, 81
      new transactions, automatically creating, 82
      RollbackTrans method, 80
transaction managementIsolationLevel property, 82, 83
trappable errors, 500-505
turning off events, ADO Event Model, 213
TVBAError type, Errors Collection code example, 512
Type Library Header (.tlh) file, 36
Type Library Implementation (.tli) file, 36
Type property
      Field object, 147, 350
      Parameter object, 362
      Properties collection, 481
      Property object, 371
      Stream object, 456

U[ Top ]
UDA (Universal Data Access), 3
.UDL file extension (Data Link File), 527
UID (username), 71
UnderlyingValue property, Field object, 153, 350
Unicode character-string datatype, 147
UNION keyword, SQL, 473
Universal Data Access (UDA), 3
unknown, Command object, 162
unsigned-integer datatype, 147
unspecified datatype, 146
UPDATE clause, SQL, 476
Update method
      Fields collection, 354
      Recordset object, 128, 130-133, 154, 439
UpdateBatch method
      Recordset object, 155, 439
      warnings, 505
updates, types of, 26
URL ActiveConnection
      Record object, opening with, 242-245
URL property, DataControl object, 270
URL (Universal Resource Locator)
      trappable errors, 501, 504
user-defined variable datatype, 147
username (UID), 71
      Connection objects, 21

V[ Top ]
Value property
      Field object, 144, 350
      Parameter object, 362
      Properties collection, 481
      Property object, 371
VAR function, SQL, 466
variable-declaration statements
      VBScript, 45
variables
      VBScript, defining, 44
variance of a population (see VARP function, SQL), 466
variance of a sample (see VAR function, SQL), 466
Variant datatype, VBScript, 44
VARP function, SQL, 466
VBA functions, data shaping, 227
VBA (Visual Basic for Applications), 14
VBScript, 9, 15
      code example, ActiveX Data Objects, 45-47
      creating ActiveX Data Objects, 44
      referencing ActiveX Data Objects, 44
Version property, Connection object, 69, 331
virtual record pointer, Recordset object, 25
Visual Basic, 9, 15
      add-ins, 13
      code example, AcitveX Data Objects, 33-36
      creating ActiveX Data Objects, 32
      OLE DB, inaccessibility of, 8
      On Error statement, 500
      referencing ActiveX Data Objects, 32
Visual Basic for Applications (see VBA)
Visual C++, 9, 15
      code example, AcitveX Data Objects, 38-40
      creating ActiveX Data Objects, 37
      referencing ActiveX Data Objects, 36
Visual J++, 15
      code example, Active Data Objects, 41-??
      creating ActiveX Data Objects, 41
      referencing ActiveX Data Objects, 41

W[ Top ]
warnings
      Errors collection, 505
WFC (Windows Foundation Classes)
      Visual J++ applications, 41
WHERE clause, SQL, 466
WideCharToMultiByte function, Visual C++, 40
Will event, ADO Event Model, 183
WillChangeField event
      ADO Event Model, 207
      Recordset object, 440
WillChangeRecord event
      ADO Data Control example, 534
      ADO Event Model, 209-211
      Recordset object, 441
WillChangeRecordset event
      ADO Event Model, 211
      Recordset object, 442
WillConnect event
      ADO Event Model, 185-191
      Connection object, 331
Will/Connect pairs, ADO Event Model, 183
WillExecute event
      ADO Event Model, 191-195
      Connection object, 332
WillMove event
      ADO Event Model, 201-207
      Recordset object, 442
Win32 Console Application, creating, 38
Windows 2000 operating system, 44
Windows Foundation Classes (see WFC)
Windows NT
      integrated-security option, 522
WITH OWNERACCESS OPTION, SQL, 475
Write method, Stream object, 456
WriteText method, Stream object, 457

X[ Top ]
XactAttributeEnum, Attributes property, 82
XactAttributeEnum enumeration, 584

Y[ Top ]
Yahoo!, 10

Return to ADO: ActiveX Data Objects