Index_R

Team-Fly

---

Index

R

RAISERROR statements, 119, 226, 229-32

RDO data controls, 54

RecordCount property, 198-99

Record objects, 3-4, 14

Records. See rows and rowsets

Recordset objects. See also rows and rowsets

AddNew method, 132, 149, 150

in ADO 2.5 object model, 14

and ADO marshaling, 243-49

alternatives to using, 240-41, 255-58

Close method, 142

combining, 327-28

and Command objects, 128, 129

as COM objects, 118

constructing, 122-25

creating in memory, 131-34

CursorLocation property (See CursorLocation property)

and cursors, 118, 142-43

CursorType property (See CursorType property)

vs. delimited strings, 240-41

deprecated, 237-38

disconnected, passing, 249-55

disconnecting, 205-6

efficiency in, 126

and events, 65, 194-95

examing properties after opening, 139

and Field objects, 122-24

Filter property, 177, 187, 329

firehose, 142

improving ADO insertion performance, 329-30

MarshalOptions property, 177-79, 248

Open method, 126-29, 134, 135, 193, 194, 216, 291

overview, 117-18

populating and offloading, 190-200

properties and methods, 125-48

read-only vs. read-write, 206

releasing result sets, 142

remoting to clients, 247-49

saving, 133, 187-88

in Shape provider sample application, 307-11

Source property, 96, 119-20, 127, 128, 135-36

Supports method, 137, 140-41, 250

testing, 148-49

undoing changes, 187-88

Unique Table property, 147, 173, 175, 180

updating, 155-64

using UNION to combine, 322-23

when not to use, 80

when to use, 119-20

working with, 125-55

and XML Stream objects, 292, 294-302

Refresh method, 76, 83, 87, 88, 89-90, 214, 232

Remote connections, 25

Requery method vs. Resync method, 147

Response.Write method, 291, 293

Result sets

complex, 226-32

multiple, 222-26, 241

overview, 118-19

from stored procedures, 217-26

string-based, 255-56

Resync Command property, 173

Resync method, 145, 146, 147-48

Return status, and stored procedures, 100, 218, 229, 237

Rows-affected values, 218, 219-20

Rows and rowsets, 42, 79, 80, 144-46, 148-55, 191-93, 217, 220-26, 258

Rows property, 256

Rules, business, 159, 175

---

Team-Fly