|
|
 |
| Авторизация |
|
|
|
| Поиск по указателям |
|
|
|
|
|
|
|
 |
|
|
|
| Connell J. — Beginning Visual Basic 6 Database Programming |
|
|
|
| Предметный указатель |
Cursors, types of, Forward-only 567
Cursors, types of, Keyset-driven 565 566 567
Cursors, types of, Scrollable 565 566
Cursors, types of, Static 567
Cursors, types of, updateabk/nonupdateable 566
CursorType property 566—567
DAO (Data Access Objects) 33
DAO (Data Access Objects), advantages 34
DAO (Data Access Objects), history 513
DAO (Data Access Objects), Jet interface 409
DAO (Data Access Objects), limitations 514
DAO (Data Access Objects), object hierarchy 412
DAO (Data Access Objects), using to create a database 409
DAO (Data Access Objects), when to use 33 388 411
DAO data control 84—87 134—137 151 see "DAO
DAO data control, accessing databases 135
DAO data control, database-connection options 151
DAO data control, DatabaseName property 136
DAO data control, properties 148 151
DAO data control, RecordCount property 154
DAO data control, RecordSource property 137
DAO data control, when to use 134
DAO object model 412—413
DAO object model, ADO object model, compared 562
DATA see also "Databases"
Data bound controls see "Bound controls"
data controls see "ADO" "DAO"
Data Form Wizard 39
Data Link property box 522—525
Data Mining 399 713 714
Data mining, data re-aggregation 718
Data mining, entropy 716 747 752
Data mining, ID3 Algorithm 715
Data modeling 393
Data repeater 637—648
Data Source Name see "DSN"
Data warehousing 399
Data, aggregation 399
Data, binding 579—581
Data, denormalizing 399
Data, encapsulation 287
Data, entry, forms 225—232 281—285
Data, entry, validating 261 326
Data, mining 399 713 714
Data, mining, data re-aggregation 718
Data, mining, entropy 716 747 752
Data, mining, ID3 Algorithm 715
Data, modeling 393
Data, normalization 24 392—399
Data, redundancy 392
Data, warehousing 399
data-aware controls see "Bound controls"
Database collection 413
Database engines, ISAM 411
Database engines, Jet 28 388
DatabaseName property 168 169
databases see also "Recordsets"
Databases, Access (Microsoft) 24—25
Databases, analysis 387
Databases, analyzing data types in 553—555
Databases, analyzing fields in 548—553
Databases, as data stores 29
Databases, components 11
Databases, constructing 387
Databases, constructing, with DAO 409
Databases, constructing, with VisData 400
Databases, database engines 27 28
databases, designing 387 393
databases, fields 145 158 685
Databases, flat-file 14
Databases, interfaces, ODBC 47
Databases, ISAM (Indexed Sequential Access Method) 515
Databases, mechanics of 144
databases, normalization 24 392—399
Databases, ODBC (Open Database Connectivity) 516—518
databases, relational 9 14—16
Databases, relational, advantages 15
Databases, relational, components 15
Databases, relational, joining tables in 367—369
DataChanged property 95 96
DataCombo control (ADO) 90 105 106
DataCombo control (ADO), BoundColumn property 114
DataCombo control (ADO), using with ADO data control 106
DataFields property 143
DataGrid control (ADO) 89 106
DataList control (ADO) 89 106
DataRepeater control (ADO) 90
DataSource property 143
DataSourceBehavior property 591
Date interchange format (dif) 766
Dates, converting 477
DateTimePicker (ADO) 90
DBase databases, accessing 514
DBEngine 412 415 458
DBEngine, Errors collection 412
DBEngine, Workspaces collection 412
Debugging 189 555—559
Debugging, error-identification, ADO 555—559
Debugging, time-saving tips 189
Delete anomaly 395
Delete method 171
DELETE statements (SQL) 359
denormalizing data 399
Dif (date interchange format) 766
disconnected recordsets 798
Disconnected recordsets, ADO 798
Disconnected recordsets, creating 800
DISTINCT keyword (SQL) 359
DLLs (dynamic link libraries) 27 28 85 see "Type
DLLs (Dynamic Link Libraries), as references 209
DLLs (Dynamic Link Libraries), filename extensions 86 106
DLLs (Dynamic Link Libraries), how to use 86
DLLs (Dynamic Link Libraries), ISAM drivers 515 516
DoEvents 191
dot notation 131
DSN (Data Source Name), connection string code 543
DSN (Data Source Name), creating 537—543
DSN (Data Source Name), testing 543—545
DSN-less connections 537
Dynamic cursors (ADO) 567
dynamic linking 86
Dynamic SQL (structured query language) 345
dynasets 146
early binding 789 see
Edit method 171
Edit method, limitations 374
EditMode property 170 184
EditMode property, built-in constants 184
EditMode property, checking during unloading 221
Encapsulating data 286—287
Encapsulating data, hiding data using 587
Encapsulation (OOP) 275
engines, database 27
Engines, database, ISAM 411
Engines, database, Jet 27 28
entropy 716 747 752
Enumerated constants 175
Enumerated constants, action arguments 263—264
Enumerated constants, features 597
EOF property 170
EOFAction property 149 150 169
error messages see also "Errors"
Error messages, database connection failures 524
Error messages, invalid data 265
Error messages, invalid procedure call/argument 191
Error messages, invalid property value 230
Error messages, moving off recordset 178
Error messages, no current record 178
Error messages, unusable names 197
Errors see also "Error messages"
| Errors collection 412 458 555—559
Errors, accidental file overwrites 320
Errors, avoiding 172
Errors, BOF and EOF related 148 150
Errors, compile errors 322
Errors, data editing errors 184
Errors, data entry errors 104 105
Errors, global variables errors 244
Errors, handling errors 96
Errors, handling errors, data entry 104 105
Errors, handling errors, SQL query-related 383
Errors, Identifying errors 555—559
Errors, incorrect property values 144
Errors, run-time errors 157 227
Errors, SQL errors 349 350
Errors, type-mismatch es 197
Errors, unloading during editing 220
Events 84
Events, Activate 152
Events, declaring/raising 598 599
Events, executing 134 157
Events, Form_Load 96
Events, Form_MouseMove() 132
Events, Form_Unload events 223
Events, initialization sequence 229
Events, overview 131 132 133 134
Events, Public vs. Private 181
Events, Query Unload 220 221
Events, raising events 599
Events, Reposition 152
Events, Reposition, adding field highlights 227 228
Events, Reposition, firing 158
Events, Reposition, testing 227
Events, Reposition, updating current records in 261
Events, Resize event 64
Events, Unload event 223
Excel 789
Excel, ActiveX automation server 788
Excel, as an automation server 793
Excel, calling from VB 791
Excel, exporting 767
Excel, importing a csv file into 776
Excel, invisible instances of 793
Excel, object 794 796
Excel, object variable 788
Excel, sending ADO recordsets 790
Excel, sending data via ActiveX automation 767 787
Excel, type library 789
Excel, using objects to send ADO data 787
Excel, Workbooks collection 788
Exclusive property 169
execute method 531 545—547
Execute method, function 545
Execute method, testing 546 547
Fields 11 15 16 24
Fields, accessing 547
Fields, altered records 145
Fields, attributes 18
Fields, data types 18
Fields, duplicate fields 21 24
Fields, eliminating, inconsistent dependency 392
Fields, eliminating, redundancy 392
Fields, empty 145
Fields, field types 312 313
Fields, hidden fields 685
Fields, key fields 22
Fields, length 158
Fields, linking 15
Fields, locking 234 235
Fields, NULL values 30 358
Fields, required fields 264
Fields, searching 312 313
Fields, selecting fields, Data Form Wizard, using 50 51
Fields, selecting fields, RecordSource property (ADO) 111
Fields, sorting fields, ASCII order 76 79
Fields, sorting fields, Data Form Wizard, using 52
Fields, sorting fields, SQL queries 76
Fields, table columns 52
Fields, unnormalized 392
Files, BOF/EOF pointers 148
Files, comma delimited files 766
Files, comma delimited files, embedded commas 775
Files, comma delimited files, exporting the data 769
Files, comma separated values (csv) 766
Files, comma separated values (csv), embedded commas 775
Files, comma separated values (csv), exporting the data 769
Files, data files, ADO 525 527
Files, data stores 29
Files, data-storage 16
Files, date interchange format (dif) 766
Files, DLLs (dynamic link libraries) 27 28
Files, ISAM 411
FindFirst method 171
FindFirst method, locating records using 237
FindLast method 171
FindNext method 171
FindPrevious method 171
Flat-file databases 14
Focus, forms (form objects) with 229
Focus, highlighting controls with 226
Focus, l-Beam cursor as indicator 229
Focus, overview 225
Focus, setting prematurely 228
foreign keys 23 24
form templates 330 332—336
Form templates, creating parent/child forms 330 332—336
Forms (form objects), accessing 129
Forms (form objects), active 130
Forms (form objects), BorderStyle property 223
Forms (form objects), Caption property 131
Forms (form objects), GUIs (graphical user interfaces) 138
Forms (form objects), intrinsic features 129
Forms (form objects), modal/non-modal 256
Forms (form objects), parent/child 330—336
Forms (form objects), properties 130 131
Forms (form objects), resizing 129
Forms (form objects), resizing, preventing 247
Forms (form objects), Show method 256
Forms (form objects), standard features 129
Forms, as templates 168
Forms, creating via HTML 681
Forms, generating 42
Forms, initializing 102
Forms, profiles 53
Forms, purpose of 27
Forms, type of 48 49
FreeFile function 773
FROM clause (SQL) 345 346
Functions, aggregate, using in SQL queries 361 362
Functions, aggregate, WHERE clause with 365
Functions, API 239—241
Functions, Asc() 78
Functions, Chr() 78
functions, FreeFile 773
functions, MsgBox 221
Functions, Public vs. Private 181
Functions, statistical, SQL 365 366
General Declarations section, connecting class modules with forms 283
General Declarations section, Option Explicit statements 175
global modules 319
Global variables 243—249
Global variables, advantages 249
Global variables, limitations of 244
Global variables, when to use 243—245
graphical user interfaces see "GUIs"
Grid (Datasheet) layout forms 49
Grid (Datasheet) layout forms, creating 58—60
Grid (Datasheet) layout forms, Show Data Control option 60
Grids, controls for 100 120—122
Grids, navigating 119
|
|
|
| Реклама |
|
|
|
|
|
О проекте