|
|
 |
| Авторизация |
|
|
|
| Поиск по указателям |
|
|
|
|
|
|
|
 |
|
|
|
| Connell J. — Beginning Visual Basic 6 Database Programming |
|
|
|
| Предметный указатель |
SQL (Structured Query Language), SELECT statements, GROUP BY clause 366 367
SQL (Structured Query Language), SELECT statements, HAVING clause 367
SQL (Structured Query Language), SELECT statements, INNER JOIN approach 368 369
SQL (Structured Query Language), SELECT statements, IS NOT NULL clause 364
SQL (Structured Query Language), SELECT statements, joining tables 367 368
SQL (Structured Query Language), SELECT statements, ORDER BY clause 360 361
SQL (Structured Query Language), SELECT statements, OUTER JOIN approach 369 371
SQL (Structured Query Language), SELECT statements, statistical functions 365
SQL (Structured Query Language), SELECT statements, UPDATE statement 375
SQL (Structured Query Language), sending commands 545
SQL (Structured Query Language), servers, connecting to 47
SQL (Structured Query Language), shallow data 714
SQL (Structured Query Language), sorting data 113
SQL (Structured Query Language), statistical functions 365 366
SQL (Structured Query Language), updating recordsets 371—375
SQL 7.0 database, programming-related warning 134
SQL 7.0 database, using as a desktop 388
SQL Query Tester 347—354
Startup object, customizing 55 284
State machine programming model 179—180 207
State property 531
Stateless connections 687
Static cursors (ADO) 567
static linking 85 86
static properties 155
static variables 461
STATIC variables, declaring 200
Statistical functions (SQL) 365—366
Status Bar control 450 461
STDEV (Standard Deviation), SQL 365—366
STDEVP (Standard Deviation of Population), SQL 365—366
String properties 131
string variables 190
Strings, conditional 355
Strings, connection strings 568
Strings, matching 355
Strings, passing 185—188 247
Strings, safeguarding passing of 251
subroutines see also "Methods"
Subroutines, adding to forms 181
Subroutines, automatic record locking/unlocking 194
Subroutines, code modules in 180
Subroutines, comparison with functions 182
Subroutines, Dim statements in 152
Subroutines, Public vs. Private 181
Subroutines, templates for 182
Supports property 603
Synchronizing data 23
tab control 449
Tables 15 16 24
tables, adding data to 141 147
Tables, changing data in 103
tables, columns 52
Tables, Delete method for 171
Tables, home tables 23
Tables, joining 368
Tables, joining, JOIN approach 368
Tables, joining, table.field approach 368
Tables, layout formats 49
tables, linking 21
Tables, multi-table relationships 31—32
tables, multiple tables 112
Tables, recordset object type 146
Tables, relationships, design considerations 21
Tables, relationships, key-based 21 23
Tables, relationships, many-to-many 20
Tables, relationships, many-to-one 21
tables, relationships, one-to-many 20 21
tables, relationships, one-to-one 20 21
Tables, relationships, parent/child 98
Tables, relationships, referential integrity 423
Tables, relationships, structuring 21
tables, rows 52
tables, searching 18—24
tables, splitting 395
Tables, table.field approach 367
Tables, viewing 58
Tablndex property 229—234
Tabs, Alphabetic 130—131
Tabs, automatic tabbing 236—237
Tabs, Categorized 112 130
Tabs, data entry forms 229—232
Tabs, ordering 231—232
TabStop property 232—234
Tag property 193—194 280
Templates see also "Class modules"
Templates, Class Builder, using 287
Templates, creating data entry forms from 323
Templates, forms 168 330—336
Templates, Let/Get properties 247
Templates, storing 317—318
Templates, subroutine templates 182
temporary objects 145—146
Terminate event 284
terminating see "Closing"
Text box control (DAO) 88—89
Text box control (DAO), binding to data control 91—94
Text box control (DAO), how it works 96—97
text boxes 88—89
Text boxes, adding scrollbars to 161
Text boxes, adding to forms 138—143
Text boxes, control arrays 139—140
Text boxes, labeling 142
Text boxes, locking and unlocking 180
Text boxes, multiple 138
Text boxes, Tablndex property 230—234
Text boxes, TabStop property 232—234
Text variables 313
Toolbox, adding an ADO data control 85 105 521
Toolbox, adding controls to 98
Toolbox, built-in controls 84 86
Toolbox, Components dialog box 90
Toolbox, Icons 86 104 106 627
ToolTip text property 193
Transactions, ADO (ActiveX Data Objects) 569—573
Transactions, ADO (ActiveX Data Objects), atomicity 569
Transactions, ADO (ActiveX Data Objects), consistency 569
Transactions, ADO (ActiveX Data Objects), features 569
Transactions, ADO (ActiveX Data Objects), isolation 569
Transactions, ADO (ActiveX Data Objects), updating records using 572
Tree view control 425 442 451
Tree view control, Add method 431
Tree view control, node objects 468
Trees 431
type libraries 789 see
Type libraries, application 789
Type libraries, DAO (Data Access Object) 389
Type libraries, DAO (Data Access Object), adding to projects 209
Type libraries, DAO (Data Access Object), Classes list box 210
Type libraries, DAO (Data Access Object), searching for components 210
Type libraries, Excel 789
Type libraries, identifying components 209
TypeOf methods 196
UDA (Universal Data Access) 514 518
UDA (Universal Data Access), ADO, using 518
UDA (Universal Data Access), Advantages of UDA 519
| UDA (Universal Data Access), Components of UDA 519
Unload event, using 223
Unloading forms 218—223
UnloadMode 220
Unlocking, bound controls 613
Unlocking, records 192—194
Updatable property 351
Update anomaly 395
Update method 171
Update method, limitations 374
Update Project button (Class Builder) 281
UPDATE statements (SQL) 375 376
UpdateRecord method 170
updating, records 200
Updating, recordsets 114 117 169 371—375
URL (Uniform Resource Locator) 654
URL (Uniform Resource Locator), host 655
URL (Uniform Resource Locator), protocol 655
User controls, adding properties, ADO 615
user interfaces 27
User interfaces, BoundClass module 589
User interfaces, Cancel button 170
User interfaces, canceling operations 254
User interfaces, command buttons 611
User interfaces, data entry 229—238
User interfaces, data entry forms 281—325
User interfaces, designing 127
User interfaces, enhancing forms 168
User interfaces, enhancing forms, adding records 200 201
User interfaces, enhancing forms, data manpulation 200
User interfaces, enhancing forms, deleting records 204 205
User interfaces, enhancing forms, editing records 202
User interfaces, enhancing forms, instructions for 173—178
User interfaces, enhancing forms, run-time display 206—208
User interfaces, enhancing forms, saving records 202—204
User interfaces, enhancing forms, undoing record changes 206
User interfaces, professional appearance 142
User interfaces, safeguards 172 179—180
User interfaces, safeguards, accidental deletions 205
User interfaces, safeguards, accidental edits 192
User interfaces, safeguards, avoiding SQL syntax errors 349—350
User interfaces, safeguards, invalid data entries 265
User interfaces, safeguards, naming database locations 245
User interfaces, safeguards, premature form closing 219
User interfaces, safeguards, preventing form resizing 247
User interfaces, safeguards, preventing unwanted field changes 234—235
User interfaces, safeguards, QueryUnload event 219—220
User interfaces, safeguards, recordset navigation errors 177 184
User interfaces, safeguards, SQL query generators 383
User interfaces, safeguards, unwanted form resizing 223—224
User interfaces, safeguards, validating data entry 326
User interfaces, separating code from 238
User interfaces, simplifying 177
User interfaces, user controls 615
User interfaces, visual cues, background color changes 194
User interfaces, visual cues, background colors 234
User interfaces, visual cues, current field highlights 227—228
User interfaces, visual cues, enabled/disabled controls 207
User interfaces, visual cues, highlighting current controls 225—226
User interfaces, visual cues, hourglass mouse pointer 250 294
User interfaces, visual cues, importance of 179
User interfaces, visual feedback, progress bars 158
User interfaces, Windows' effect on 128
UserControl properties, ADO 615—618
Validate event 261—265
ValidateRecord event 633
VAR (variance) function (SQL) 365—366
Variables, adding to code 152
variables, declaring 200
Variables, form/module level 182 494
Variables, formatting 313
Variables, formatting, jet requirements for 313
Variables, global, advantages 249
Variables, global, when to use 243—245
variables, local 181
variables, naming conventions 189
Variables, object references 209
variables, object variables 788 see
variables, private 301—305
variables, scope 152 460
Variables, scope, importance of limiting 244
variables, static 461
Variables, storing properties as 131
Variables, strongly typed 789
Variables, text 313
Variables, weakly typed 788
VARP (Variance of the Population) function, SQL 365 366
VB 6.0 IDE, add-ins and Wizards 43
VBScript 664 806
Version property (connection object) 531
virtual directories 662
VisData 24 390 400
VisData, accessing 400
VisData, creating a database with 400
Visual Basic, calling Excel 791
Visual Basic, early editions 152
Visual Basic, history 579
Visual Basic, language, limitations of 389
Visual Basic, programming approaches, object-oriented programming 275
Visual Basic, programming approaches, reusable components 272
Visual Basic, prototyping using 127—128
Visual Basic, sample databases, Biblio.MDB 25
Visual Basic, sample databases, Nwind.MDB 25
Visual Basic, template directory 317—318
Visual Basic, template directory, modules subdirectory 319
Visual Basic, version 5.0, code facilitating features 156
Visual Basic, version 5.0, code syntax improvements 153
Visual Basic, version 6.0, new controls 89—90
Web browsers 653 656
Web browsers, host 655
Web browsers, protocol 655
Web browsers, web browsers, tags 655
WHERE clauses (SQL) 355
WHERE clauses (SQL), aggregate functions with 365
WHERE clauses (SQL), BETWEEN operator 357
WHERE clauses (SQL), comparison operators 355
WHERE clauses (SQL), IN operator 357
WHERE clauses (SQL), LIKE operator 356
WHERE clauses (SQL), nested conditions 358
WHERE clauses (SQL), NOT IN operator 358
Wildcard(*) symbol 346 353 356
Windows (Microsoft), features 132
Windows (Microsoft), messages 132
Windows (Microsoft), queues 132
Windows Application Programming Interface see "API"
Windows, handles to (hWnd) 240 253
Wizards, adding to Visual Basic 43—44
Wizards, Application Wizard 42
wizards, Data Form Wizard 39
Wizards, Data Form Wizard, ADO control problems 75
Wizards, Data Form Wizard, code limitations 75
Wizards, Import Text (MS Access) 779
Wizards, Profiles, saving 53
Workspaces collection 412 458
Wrapping lines, Multiline property 161
write-only properties 247
|
|
|
| Реклама |
|
|
|
|
|
О проекте