AbsolutePosition property, 149, 204
Access. See MicrosoftAccess
ActiveConnection property
Command object, 76, 83, 135, 214
Recordset object, 206, 244, 250
Active Server Pages. See ASP (Active Server Pages)
ActiveX Control Interface Wizard, 275
ActiveX Data Control, 3, 237
ActiveX Data Objects. See ADO (ActiveX Data Objects)
ActiveX Data Objects 2.x Library, 17-18
ActiveX Recordset Library (ADOR), 1, 18
ActualSize property, 207
adCmdStoredProc setting, 82, 114, 136, 214, 233
adCmdTable setting, 114, 136
adCmdText setting, 82, 136, 233
adCmdUnknown setting, 114, 136
AddNew method, 132, 149, 150
adExecuteNoRecords option, 82, 83, 107, 221
Ad hoc queries, 81, 101, 111-12
ADO 2.5 object model, 13-16
ADO (ActiveX Data Objects)
deploying, 6-8
distribution of, 1-2
getting help, 8-9
installing, 5-6
instantiating objects, 17-20
and MDAC, 1-2, 3, 5, 6, 334-35
new features, 3-5
and OLE DB, 11-13
overview, 11-16
role of URLs, 4
and SQL Server 2000, 355-61
versions of, 1-3, 237, 355, 360-61
where to put help files, 335
ADO Data Control (ADC), 12, 31-33, 54
ADODB qualifier, 19
ADODC. See ADO Data Control (ADC)
adParamInput option, 92
adParamInputOutput option, 88, 92, 100
adParamOutput option, 88, 92, 100, 101
ADTG (Advanced Data Tablegram) format, 131
AdUseClient CursorLocation setting, 43, 199, 206, 244
AdUseServer CursorLocation setting, 42, 173. See also server-side cursors
Advanced Data Tablegram (ADTG) format, 131
Ampersand. See concatenation operator (&)
AppendChunk method, 209, 212-13
Append method, 95
ASP (Active Server Pages)
client/server applications vs. Web-based applications, 288
collecting parameters from Web pages, 287-88
error handling, 283-84, 293, 329-30
exception pages, 283
managing Recordsets using XML Stream objects, 294-302
returning data from Web pages using XML, 288-94
running queries based on input parameters, 285-86, 288
and session pooling, 61
and UDL files, 29
and VBScript, 283-84, 290
and Visual InterDev, 19-20
writing code in Visual Basic IDE, 294
Asynchronous operations, 62-63, 106, 107, 193-95
Attributes property, 123-24
Team-Fly |