|
|
 |
| Авторизация |
|
|
|
| Поиск по указателям |
|
|
|
|
|
|
|
 |
|
|
|
| Connell J. — Beginning Visual Basic 6 Database Programming |
|
|
|
| Предметный указатель |
Grids, resizing 100 120
GROUP BY clause (SQL) 345 366—367
GUIs (graphical user interfaces) 51 138
Handles 253
HAVING clause (SQL) 345 367
heterogeneous joins 409
Hierarchical FlexGrid control see "MS HFlexGrid control"
HTML (Hypertext Markup Language) 653 656 654 781
HTML (HyperText Markup Language), adding script s 664
HTML (HyperText Markup Language), and ASP 654
HTML (HyperText Markup Language), ASCII file 655
HTML (HyperText Markup Language), browser independence 655
HTML (HyperText Markup Language), cookies 687
HTML (HyperText Markup Language), cookies, reading and zvriting 690
HTML (HyperText Markup Language), exporting 766 781 785
HTML (HyperText Markup Language), stateless connection s 687
HTML (HyperText Markup Language), static language 653 655
HTML (HyperText Markup Language), streams 656
HTML (Hypertext Markup Language), tags 655
HTML (HyperText Markup Language), URL (Uniform Resource Locator) 654
HTML (HyperText Markup Language), websites 654
HTTP (Hypertext Transfer Protocol) 654
HWnd property 240 253
ID3 Algorithm, data mining 715
Ilf statements 351
Image control (DAO) 89
IN operators, SQL 357
Index parameter (control arrays) 139 147
Indexed sequential access method see "ISAM"
Indexes 13 24
Indexes, advantages 19 20
indexes, creating 19
Indexes, creating, guidelines 407
Indexes, index variables 190
Indexes, overview 18—19
Indexes, primary keys 23
Indexes, using 76
Inheritance (OOP), parent/child objects 274 332—336
Initialize event, class modules 284
INNER JOIN approach, SQL 368—369
instantiating objects 273
Integer variables, naming 190
Intellisense 156—157
Internet 653
Internet, cookies 687
Internet, data access requirements 517 518
Internet, stateless connection 687
Intranet applications, using ADO 34 35
Intrinsic controls 84 86 see
IP address 661
IS NOT NULL clause, SQL 364
ISAM (Indexed Sequential Access Method) 410
ISAM (Indexed Sequential Access Method), accessing with intrinsic data control 515
ISAM (Indexed Sequential Access Method), data access 411
ISAM (Indexed Sequential Access Method), data sources 411
ISAM (Indexed Sequential Access Method), database support 515 518
ISAM (Indexed Sequential Access Method), drivers 515 516
ISAM (Indexed Sequential Access Method), file types 513
JavaScript 664
Jet database engine and ISAM 411
Jet database engine, bypassing with ODBCDirect 516
Jet database engine, DAO-support 513 515
Jet database engine, DLLs (Dynamic Link Libraries) 28
Jet database engine, flexibility of 28 410
Jet database engine, limits of 167
Jet database engine, overview 27—28
Jet database engine, programming Jet, ADO (ActiveX Data Objects) approach 33—35
Jet database engine, programming Jet, DAO (Data Access Objects) approach 33—34
Jet database engine, recommendations for use 388
Jet database engine, relation to other engines 400
Jet database engine, security 109
JOIN keyword, SQL 345
Jscript 664
Key fields, defining 22
Key fields, linking tables using 21
Keys 24
Keys, basing relationships on 21 23
keys, compound 30
Keys, features 23
keys, foreign 23
keys, primary 22
Keys, unique 21
Keyset-driven cursors 565—567
Knowledge Discovery in Databses (KDD) 714
Label control (DAO) 89
late binding 788
legacy data 748
Legacy data, accessing 514
Legacy data, databases 102
Libraries, ADO reference 520
Libraries, application type 789
Libraries, dynamic link (DLLs) 85 86 209
Libraries, statically-linked 85 86
Libraries, type libraries 789
Libraries, type libraries, adding to projects 209
Libraries, type libraries, components 209 210
Libraries, type libraries, Excel 789
LIKE operator SQL 356
List box control (DAO) 89
Locked property 192 235
Locking, bound controls 613
Locking, control sizes 596—597
Locking, fields 234—235
locking, records 192—194
Logic rules 798
Lotus spreadsheets 514
Machine states 179 180
Magic Cookies see "Handles"
Many-to-many relationships 20 see
Many-to-one relationships 21 see
Marshalling 800—801
Marshalling, MarshalOptions property 801
Mask property 105 453
Masked edit control (ADO) 89 451
Masked edit control (ADO), features 104
Masked edit control (ADO), idiosyncracies of 487
Master records 49
Master/Detail layout forms 49 61
Master/Detail layout forms, creating 61 62 63
Master/Detail layout forms, displaying 64
Master/Detail layout forms, navigating 64 65
MDB database files 513
MDB database files, analyzing using DAO 425
MDB database files, data controls for 134
merging data 66
Message boxes, syntax 221
Meta-information 724
Method Builder 295
Microsoft Access 400 see
Microsoft DAO 3.51 Object Library 209
Microsoft Excel see "Excel"
Microsoft Hierarchical FlexGrid control see "MS HFlexGrid control"
Microsoft Jet 3.51 OLE DB Provider 108 see "OLE
Microsoft Masked Edit Control 6.0 see "Masked edit control"
Modal displays 256
Modules 27
Modules, class 238 591
Modules, code modules 238
Modules, templates 319
Month view control (ADO) 90
MousePointer property 250 294
MoveFirst method 149 171
MoveLast method 162 171 176
MoveNext method 149 171 176
MovePrevious method 149 150 171 176
MS Chart layout forms 49 69—75
MS HFlexGrid control (ADO) 89 106 119
MS HFlexGrid control (ADO), DataSource property 122
MS HFlexGrid control (ADO), using 119—122
MS HFlexGrid layout forms 49
| MS HFlexGrid layout forms, creating 65—69
MsgBox function 221
MSys tables 50
Multi-table relational searches 31—32
Mvar prefix 286
naming conventions 189
Nested conditions, SQL 358
New keyword (for objects) 283 560—561
nodes 431 467
Nodes, collection 467
nodes, root 431
Nodes, tree 431
Non-relational data 514 518
Normalization 24 392—397
Normalization, denormalizing 399
NULL values 30 250 358
Object Browser 277 648
Object Browser, accessing 209
Object Browser, advantages of using 212
Object Browser, examining classes in 327
Object Browser, searching 210—211
Object Browser, window components 209—210
object variables 788 see
Object variables, declarations 283
Object variables, dimensioning 560—561
Object variables, recordsets 811
Object-Oriented Programming (OOP), overview 273—275
Object-Oriented Programming (OOP), polymorphism 274
Object-Oriented Programming (OOP), Visual Basic approach 275
Objects and collections 412 413
Objects, accessing via binding 788
Objects, App 222
Objects, as class instances 273
Objects, business 798—799
Objects, business, remote 804
Objects, command objects 562
Objects, parameter objects 563
Objects, recordsets 417 796 801
Objects, recordsets, disconnected type 799—800
Objects, recordsets, overview 145—147
Objects, recordsets, types of 146
ODBC (Open Database Connectivity) 410 516
ODBC (Open Database Connectivity) and Jet 409
ODBC (Open Database Connectivity), data sources 537—543
ODBC (Open Database Connectivity), drivers 572
ODBC (Open Database Connectivity), ODBC Direct 409 516 517
ODBC (Open Database Connectivity), ODBC interface 47
ODBC DSN connection 543—545
OLE DB, ADO, using with 520
OLE DB, controls 106
OLE DB, providers, getting schema 549 550—553
OLE DB, providers, identifying errors 555—559
OLE DB, providers, obtaining data type information 553—555
OLE DB, providers, obtaining source information 549
OLE-container control (DAO) 89
One-to-many relationships 20—21 see "Tables"
One-to-one relationships 20—21 see "Tables"
OOP see "Object-Oriented Programming"
Open Database Connectivity see "ODBC"
Open method, connection object 531
Open method, Recordset object 547
OpenSchema method 548—553
OpenSchema method, analyzing data types 553—555
Operating systems (OS), Windows 132
Oracle databases, connecting to using Data Form Wizard 47
ORDER BY clause (SQL) 345 360 361
Ordering see also "Sorting"
Ordering, recordsets 360
orphaned records 23
OUTER JOIN approach, SQL 369 371
Paradox databases, accessing 514
Paradox databases, updating files from 515
Parameter object collection 563
parent records 65 see
Parent/child forms, avoiding design problems 336
Parent/child forms, creating 98—101 330—336
Parent/child forms, example 102
parent/child relationships 98
Passwords, adding to connection strings 109
Paths, fully-qualified 169
Pattern matching, searching records using 238 255
PercentPosition property 158 162 170
Persistent Data Application with ASP 688—709
Persistent Data Application with ASP, getting information on a new surfer 704
Persistent Data Application with ASP, retrieving information about visitors 700
Persistent Data Application with ASP, writing cookies to the Client's browser 690
Persistent recordsets 811
Personal Address Book example 390
Personal Address Book example, creating the address book 444
Personal Address Book example, creating the database with DAO 418
Personal Address Book example, creating the tables 400
Personal Address Book example, normalization issues 392—397
Personal Address Book example, programming 441
Personal Address Book example, splitting tables 395
Personal Web Server (PWS) 656
Personal Web Server (PWS), setting up 657
Personal Web Server (PWS), virtual directories 662
Picture box control (DAO) 89
Place markers 170
Pointers, BOF (beginning of file) 149
Pointers, EOF (end of file) 150
Pointers, Mouse 250 294
Pointers, record pointers 171
Polymorphism 274
Posting data 686
primary keys 22 24 see
Primary keys, compound 30
Primary keys, editing 114
Primary keys, features 23
Private scope 181
Procedures Attributes dialog 327
Production Analysis Tool 715—722
Programming, DAO vs. ADO 33—35
Programming, data controls 154—155
Programming, encapsulated code 272—273
Programming, event-driven 131—134
Programming, induction methods 715
Programming, languages 579
Programming, levels of indirection 180 181 197
Programming, modular approach 180
programming, object-oriented see "OOP"
Programming, reusable components 272
Programming, user interfaces 27
Programs see also "Applications" "Databases"
Programs, data-return speed 146
Programs, designing programs 172
Programs, exporting recordsets to 765
Programs, memory conservation 222
Programs, overheads 147
Programs, resources 176
Programs, self-contained 28
Programs, speed 155 185
Programs, state machine approach 172
Programs, user interfaces 127
Progress bars, adding 160—162
Progress bars, when to use 161
ProgressBar control 160
ProgressBar property 280
Project Explorer window 284
Properties 84
Properties, AbsolutePosition 152 158 170 809
Properties, AddCaption 248
Properties, ADO Data Control 529
Properties, ADO data repeater 640 641 642
Properties, Alignment 142 162
Properties, Allow UserResizing 100
Properties, assigning values with Property Let 288
properties, BackColor 194 234 305
Properties, BOF 170
Properties, BOFAction 149 169
|
|
|
| Реклама |
|
|
|
|
|
О проекте