Microsoft Mastering : Microsoft Visual Basic 6. 0 Development Book

A
accessing
    command results, 50
    data, 49
Active Designer files described, 3
Active documents, 268, 330
    containers, 334
    creating, 331
    migrating forms to, 333
    UserDocument object, 332
ActiveX Control Interface Wizard, 124
ActiveX controls, 3, 113, 114, 268
    adding property pages, 142, 144, 146
    classes, 114
    constituent controls, 116
    constituent control properties, 126
    container application interaction, 119
    creating, 114, 116
    customizing, 122
    data-bound controls, 148-52
    data source controls, 153
    deploying. See deploying ActiveX controls
    display characteristics, 121
    events, 118, 124, 132
    exposing named constants, 132
    generating code automatically, 124
    HTML templates, 319
    interfaces, 114
    licensing, 315
    methods, 124, 129
    properties, 124, 125
    property values, 130
    signing, 318
    sizing, 121
    templates, choosing, 4
    testing, 134-36
    using, 9
ActiveX Data Objects. See ADO
ActiveX DLL, 5
ActiveX documents, 4
ActiveX EXE, 5
adding
    ActiveX controls to HTML pages, 314
    ADO Data controls to toolbox, 57
    ADO objects to projects, 42
    Class Builder to projects, 77
    code to events, 44, 173
    commands, 44, 49
    connections, 43, 44
    controls to Toolbox, 9
    data links, 48
    data to projects, 60
    events to classes, 90
    fields to recordsets, 201
    Help, 81
    items to Webclass designer, 347
    licensing to ActiveX controls, 315
    menus, 19
    methods, 77
    methods, ActiveX controls, 129
    properties, 77
    property pages to ActiveX controls, 142, 144, 146
    records, 194
    UserDocument object to projects, 332
    Visual Component Manager to Toolbar, 282
    WebBrowser control to projects, 328
ADO (ActiveX Data Objects), 39, 163, 164
    advantages, 42
    Active Server Pages, 164
    collections, 165
    creating dynamic recordsets, 201
    data source connections, 169, 171, 173-75
    disconnected recordsets, 196, 198-200
    error handling, 167
    events, 173
    object model, 165
    OLE DB data, 40
    performance, 203
    retrieving data, 176, 179, 184-85
    SQL Server security, 217
    updating data, 191, 194
ADO Data controls, 57
    binding ActiveX controls, 148
    data source controls, 153
    testing, 152
advanced client/server applications, 215
aggregates, recordset data, 53
ambient properties, 119
applications
    ActiveX controls, container application interaction, 119
    client applications. See client applications, creating
    compiling EXEs, 27
    components, using, 16
    constants, 15
    controls, using, 9
    creating, 2, 3, 8
    debugging, 22, 23, 26
    deploying. See deploying applications
    designing, 74, 75, 76
    error handling, 22, 23, 26
    event-driven programming, 2
    menus, adding, 19
    optimizing. See optimizing applications
    procedures, writing, 12
    project files, 3
    sample, State University Bookstore, 28
    samples, 6
    setting properties, 10
    variables, 15
arguments
    changing, event handling, 90
    declaring, 12
    passing, 12
ASP (Active Server Pages), ADO, 164
assigning property pages to ActiveX controls, 146
associating property pages with properties, 146
automatically generating control code, 124

B
.bas files, 3
batch processing, disconnected recordsets, 200
binding, 54
    controls to ADO Data controls, 57
    controls to recordsets, 184
    DatRepeater control, 151
    using, 150
bitmaps, Toolbox, specifying, 122
bound forms, creating, 54
breaking on errors, client application error handling, 288
building
    ActiveX controls, 116
    components, 267
    Internet applications, 327
    object models, 284
    reports, 60
by reference, passing arguments, 12
by value, passing arguments, 12

C
calling
    methods, 93
    stored procedures, 236
canceling, batch processing, 200
changing
    error handling, 26
    records, 194
choosing templates, 4
Class Builder, creating class modules, 77
class modules, 3, 76
    creating, 77, 80, 81, 82
    creating components, 73
    data-bound, 97, 101
    events, 80
    instantiating classes, 92
    using, 92
classes
    ActiveX controls, 114
    adding events to, 90
    instantiating, 76, 92
    raising errors, 92
    releasing, 92
    viewing properties, methods, events, 93
client-side cursors, 222. See also cursors
client-side recordsets, creating, 196
client applications, creating, 246
.cls files, 3
code, adding to events, 44
code editor, 6
collections
    ADO, 165
    storing objects in, 286
    working with, 16
COM components. See components
Command object, 176
    executing statements, 233
commands
    accessing results, 50
    adding, 44
    creating, 49
    grouping records, 51
    menus, adding to, 19
    organizing data, 51-53
    presenting data, 54, 57, 58, 60
    relating, 52
compiling
    components, 276
    EXEs, 27
    native code, optimizing applications, 303
components, 268
    advantages, 75
    building, 267
    class modules, creating, 73
    compiling, 276
    creating, 76, 77, 80-82, 270,
    creating object models, 283, 284, 286
    declaring friend properties, methods, 275
    design considerations, 280
    designing applications, 74
    distributing, 268
    external. See external components
    in-process vs. out-of-process, 270
    publishing, 282
    registering, 278
    setting project properties, 272, 274
    testing, 279
    using, 16
    Windows DNA, 75
    working with, 74
conditional execution, Visual Basic, 12
connecting
    data sources, ADO, 171
    multiple data sources, 175
    SQL Server security, 217
Connection object, 169
    events, 173
    executing statements, 233
connections
    accessing command results, 50
    accessing data, 49
    adding to data sources, 43, 44
    ADO, data sources, 169, 171, 173-75
    creating, 45
    creating commands, 49
    Data View window, 48
    declaring, ADO, 169
    performance, 203
    setting properties, 46
constants
    creating named constants, 88
    declaring, 15
constituent controls, 116. See also ActiveX controls
    binding, 150
    exposing events, 132
    exposing methods, 129
    properties, 126
containers, Active documents, 334
context menus. See pop-up menus, creating
control structures, Visual Basic, 12
controls. See also ActiveX controls
    ADO Data, binding to, 57
    binding, 54
    populating, 184
    setting formatting, 58
    using components, 9
creating
    Active documents, 331
    ActiveX controls, 114, 116
    applications, 2, 3, 8
    bound forms, 54
    class modules, 77, 80-82
    client-side recordsets, 196
    Command object, 176
    commands, 49
    components, 73, 76, 77, 80-82
    connection properties, 46
    connections, 45
    data-bound class modules, 97, 101
    data-bound controls, 148-51
    data-bound forms, 44
    data consumer classes, 101
    Data Environment, 45
    data source classes, 97
    data source controls, 153
    disconnected recordsets, ADO, 196
    distribution disks, 27
    distribution folders, 27
    dynamic recordsets, 201
    events, 84
    EXEs, 27
    explicit transactions, 226
    Help, 306
    IIS applications, 346
    interfaces, DHTML applications, 339
    Internet Explorer instance, 254
    invisible controls, 121
    .lpk file references, 315
    menu bars, 19
    methods, 84, 87
    named constants, 88
    object models, 283, 284, 286
    objects, 250
    pop-up menus, 19
    procedures, 12
    projects, 4
    properties, 84, 85
    properties, ActiveX controls, 125
    property page interfaces, 144
    property pages, 142
    queries, 49
    Recordset objects, 179
    reports, 60
    resource files, 298
    webitems, 347
creating client applications, 246
    availability, 247
    creating objects, 250
    declaring object variablesm 248
    error-handling, 287, 288
    Internet Explorer, 254, 256, 257, 258, 260
    using components, 253
.ctl files, 3
cursors, 218
    location, 222
    types, 218

D
DAO (Data Access Objects)
    upgrading to ADO, 42
data
    adding, 194
    field mapping, 54
    filtering, 188, 189
    formatting, 58
    grids, 54
    organizing, 51-53
    presenting data, 54, 57, 58, 60
    reports. See reports
    saving to files, 198
    searching, 188, 190
    sorting, 188
    updating, 191, 194
data-bound controls
    creating, 149-51
    testing, 152
data-bound forms, 44
data consumer classes, 101
data consumers, 40
Data Environment designer, 41
    accessing command results, 50
    accessing data, 49
    adding ADO objects to projects, 42
    adding connections, 43, 44
    creating commands, 49
    creating connections, 45
    Data View window, 48
    relating commands, 52
    setting connection properties, 46
Data Form Wizard, 42
    generating forms, 60
data integrity
    enforcing, 224-26, 229, 230
    record locking, 225
    referential integrity, 230
    SQL Server, 229, 230
    transactions, 226
data links, adding, 48
data providers, 40
    OLE DB, 42
    specifying, 169
Data Report designer, 41
    building reports, 60
data source classes, 97
data source controls, creating, 153
data sources
    adding connections, 43, 44
    creating connections, 45
    disconnecting from, 196
    performance, 203
    reconnecting, 199
    retrieving data, 176, 179, 184, 185
data sources, ADO
    connections, 169, 171, 173-75
data validation, 229
Data View window, 41
    viewing database structures, 48
databases
    accessing command results, 50
    accessing data, 49
    viewing database structures, 48
DataRepeater control, 151
debugging, 22
    ActiveX controls, testing, 135
    components, 279
    options, 26
    run-time errors, 23
    tools, 22
declaring
    arguments, 12
    connections, ADO, 169
    constants, 15
    events, 90
    events, ActiveX controls, 132
    friend properties, methods, 275
    object variables, 248
    variables, 15, 94
defaults
    fields, 229
    properties, 85
    property values, ActiveX controlsm 130
defining properties, 85
deleting records, 191, 194
deploying ActiveX controls, 313
    adding to HTML pages, 314
    Internet, 319
    licensing, 315
    options, 313
    signing, 318
deploying applications, 295, 307
    DHTML applications, 342
    distributing, 310
    IIS applications, 351
    Package and Deployment Wizard, 308
    packaging, 309
    Setup files, 311
design time
    setting formatting, 58
    setting properties, 10
designing applications, 74-76
DHTML applications, 337
    creating, 339
    deploying, 342
    interfaces, 339
    saving files, 342
    templates, choosing, 4
    writing code, 341
DHTML Page Designer, 339
disabling
    filtering, 189
    sorting, 188
disconnected recordsets, ADO, 196
    batch processing, 200
    creating, 196
    persistence, 198
    reconnecting, 199
disconnecting data sources, ADO, 171
displaying
    ActiveX controls, 121
    reports, 60
distributing
    applications, Package and Deployment Wizard, 310
    components, 268
distribution disks, creating, 27
distribution folders, creating, 27
DLLs (Dynamic Link Libraries), 268
.dob files, 3
drag-and-drop, binding controls, 54
.dsr files, 3
dynamic cursors, 218. See also cursors
dynamic recordsets, creating, 201

E
Enable property, 119
enabling ADO events, 173
enforcing data integrity, 224-26, 229, 230
enumerators
    exposing named constants, ActiveX controls, 132
    using as property values, 88
Err object, 23
error-handling, 22
    ADO, 167
    creating client applications, 287, 288
    missing references, 279
    options, 26
    raising from classes, 92
    referential integrity, 230
    run-time errors, 23
    tools, 22
establishing property page relationships, 146
event-driven programming, 2
event procedures, 12. See also procedures, writing
events
    ActiveX controls, 118, 124
    ActiveX controls, testing, 136
    adding code to, 44
    adding Help, 81
    adding to classes, 90
    ADO, 173
    class modules, 80
    Connection object, 173
    creating, 84
    custom, webitems, 348
    handling, 94
    Internet Explorer, 258
    raising, ActiveX controls, 132
    viewing, 82, 93
    WebBrowser control, 329
executables, optimizing applications, 304
Execute method, 191
executing statements, 233
EXEs, compiling, 27
explicit declaration, 15. See also declaring variables
explicit transactions, 226. See also transactions
exposing
    constituent control events, 132
    constituent control properties, 126
    methods, constituent controls, 129
    named constants, ActiveX controls, 132
external components, 245-48
    creating client applications, 246-48, 250, 253
    registering, 247

F
field mapping, 54
fields
    adding to recordsets, 201
    defaults, 229
files
    data, saving to, 198
    resource files, optimizing applications, 298
    Visual Basic, 3
filtering
    data, 188, 189
    disabling, 189
flow control, Visual Basic, 12
form data files, 3
form modules, 3
Format objects, 58
formatting data, 58
forms
    ActiveX controls, testing, 135
    controls, using on, 9
    creating bound forms, 54
    data-bound, creating, 44
    Data Form Wizard, 41
    generating, 60
    menus, adding to, 19
    migrating to Active documents, 333
    navigating, 54
    presenting data, 54
forward-only cursors, 218. See also cursors
.frm files, 3
.frx files, 3
functions
    aggregates, 53
    resource functions, optimizing applications, 298

G
general procedures, 12. See also procedures, writing
generating forms, 60
generic object variables. See variables, declaring
grids, presenting data, 54
group project files, 3
grouping
    controls, 9
    records, 51

H
handling
    events, 94
    events, testing ActiveX controls, 136
handling errors. See error-handling
Help
    adding, 81
    creating, 306
    Visual Basic, 6
HTML files, saving, 342
HTML pages
    adding ActiveX controls, 314
    templates, 319

I
IIS (Internet Information Server) applications, 345
    creating, 346
    deploying, 351
    Webclass designer, 347
    writing code, 348
implementing property pages, 144
implicit transactions, 226. See also transactions
in-process components
    registering, 278
    vs. out-of-process, 270
Initialize event, 80
initializing property values, ActiveX controls, 130
inline errors, handling, 23
inserting records, 191
Instancing property, 274
instantiating
    classes, 76, 92
    Internet Explorer, 254
    objects, 74, 94
integrated mode security, 216. See also security, SQL Server
interfaces
    ActiveX controls, 114
    ActiveX controls, testing, 135
    DHTML applications, 339
    property page, creating, 144
    Public, 85
Internet applications, 327
    Active documents, 330-34
    DHTML applications, 337, 339, 341, 342
    licensing controls, 315
    packaging controls, 319
    WebBrowser control, 328, 329
Internet Explorer. See Microsoft Internet Explorer
invisible controls, creating, 121
iteration, Visual Basic, 12

K
keyset cursors, 218. See also cursors

L
licensing ActiveX controls, 315
locating cursors, 222
locking records, 225
looping, Visual Basic, 12
.lpk files, 315

M
making controls bindable, 149
mapping
    fields to controls, 54
    properties to multiple controls, 126
memory, optimizing applications, 301
Menu Editor, 19
menus
    adding, 19
    bars, creating, 19
    pop-up menus, 19
methods
    ActiveX controls, 124, 129
    adding Help, 81
    adding, Class Builder, 77
    calling, 93
    Command object, 176
    components, 253
    creating, 84, 87
    declaring friend properties, methods, 275
    Internet Explorer, 257
    navigating recordsets, 185
    Recordset object, 179
    using, 16
    viewing, 82, 93
    WebBrowser control, 329
Microsoft Internet Explorer, 254
    ActiveX controls, testing, 135
    events, 258
    instantiating, 254
    methods, 257
    properties, 256
    releasing, 260
Microsoft Visual Basic, 1
    code editor, 6
    compiling EXEs, 27
    components, using, 16
    constants, 15
    controls, using, 9
  &nb