|
|
 |
| Авторизация |
|
|
|
| Поиск по указателям |
|
|
|
|
|
|
|
 |
|
|
|
| Connell J. — Beginning Visual Basic 6 Database Programming |
|
|
|
| Предметный указатель |
Properties, BookMark 170
Properties, BorderStyie 223
Properties, BoundColumn 112 114
Properties, BoundColumn property 118
properties, Cancel 223
Properties, caption 131 155 162
Properties, Connect 151 169
Properties, connection object (ADO) 531
Properties, Connection String (ADO) 107 110
properties, Count 195
Properties, custom-built (ADO) 600—603
Properties, customized properties 248
Properties, DAO (Data Access Object) 135 148 151
Properties, data controls 92 169
Properties, DatabaseName 168 169
Properties, DataChanged 95 96
Properties, DataFields 138 143
properties, DataSource 138 143
Properties, DataSourceBehavior 591
Properties, EditMode 170 184 221
Properties, Enabled 188 190 249
Properties, EOF 170
Properties, EOFAction 150 169
Properties, Exclusive 169
Properties, FindFieldMatch 314
Properties, ForeColor 142
properties, hidden 212
Properties, hWnd 240 253
Properties, Let RecordSource 329
Properties, Let/Get templates 247
Properties, ListField 112
Properties, Locked 192 235
Properties, MarshalOptions 801
Properties, Mask (masked edit control) 105
Properties, MousePointer 250 294
Properties, Multiline 161
Properties, PercentPosition 158 162 170
Properties, Property Let/Get 287
Properties, Public vs. Private 181
Properties, Readonly 169
Properties, RecordCount 149 154
Properties, Recordset 169—170
Properties, RecordsetType 169
Properties, RecordSource 145 168
Properties, Tablndex 229 230
properties, TabStop 232
Properties, ToolTip Text 193
Properties, UnloadMode 220
Properties, Updatable 351
Properties, UserControl 615
Property Pages, ADO Data Control 619—623
Prototyping 56 127 128
Provider property 531
Public scope 181
Queries see also "SQL"
Queries, databases, discussed 145
Queries, Query Builder 760
Queries, Query Tester program 352—354
Queries, tables, discussed 31
QueryUnload event 220
Queues, Windows operating system 132
raising events 598—599
RDO (Remote Data Objects) 518
RDO (Remote Data Objects), ODBC support 518
read-only controls 88
Read-only cursors (ADO) 565
Read-only recordsets 169
Read/write cursors (ADO) 565
Read/write rights 169
readonly property 169
Record counts 286
RecordCount property 149 154 170
RecordCount property, ADO recordsets 566
RecordCount property, initializing 155
Records 11 15 16 24 see
Records, accessing 28 32
records, adding 200
Records, background color cues 194
Records, BookMark property for 200
records, counting 149
Records, current record operations deleting 171
Records, current record operations deleting, displaying 84 175 637
Records, current record operations deleting, editing 171
Records, current record operations deleting, identifying position of 170
Records, current record operations deleting, moving pointer for 176
Records, current record operations deleting, refreshing 170
Records, grouping records 366
Records, handling multiple records 106 112
Records, indexing 13
Records, linking using key fields 21
records, locating 237—238
Records, locking/unlocking 192—194
Records, manipulating 87
Records, marshaling 800—801
Records, master/detail 49
Records, non-unique records 359
Records, ordering records 360
records, orphaned 23 205
Records, parent/child 65
Records, pointers 170
Records, position of 528
Records, ranges 357
Records, retrieving records 84
Records, searching for records, limiting query returns 354
Records, searching for records, multi-table relationships for 31—32
Records, searching for records, pattern matching 255
Records, sorting records, ASCII order 76 79 114
Records, sorting records, indexes for 76
Records, source fields 51
Records, table rows 52
Records, updating records 572
Records, viewing multiple records 58
Recordset property 169
Recordsets 40 see "Databases"
Recordsets, acccessing 148
Recordsets, accessing fields 547
Recordsets, adding data to 114 117
Recordsets, connecting ADO Data Control to 525 527
Recordsets, CopyFromRecordset method 796
Recordsets, data ranges 357
Recordsets, determining state 182
Recordsets, disconnected 798
Recordsets, EditMode 597
Recordsets, Empty recordsets 145
Recordsets, exporting to other programs 765
Recordsets, formatting 313
Recordsets, locating records 237 238
Recordsets, managing 564 566
Recordsets, MarshalOptions property 801
Recordsets, methods 176 800
Recordsets, modifying data 384
Recordsets, navigating, ADO controls for 57—58
Recordsets, navigating, command buttons for 177 179
Recordsets, navigating, options for 158
Recordsets, navigating, scrollbars for 60
Recordsets, navigating, text box controls 94
Recordsets, navigating, VCR buttons for 150 152
Recordsets, object types, dynasets 146 291
Recordsets, object types, snapshots 146
Recordsets, object types, tables 146
Recordsets, object variables 811
Recordsets, objects 417 796 801
Recordsets, opening recordsets 418 568
Recordsets, persistent recordsets 811
Recordsets, properties 168—170 801 809
Recordsets, querying recordsets 145
Recordsets, record position 152
Recordsets, referencing recordsets 563
Recordsets, Refresh method 170
Recordsets, remote 799 802 803 809
| Recordsets, searching recordsets 354
Recordsets, sorting recordsets 360 361
Recordsets, updating recordsets 371—375
RecordSource property 94 145 168—170 280
RecordSource property, ADO data control 111
RecordSource property, data controls 87 137
RecordSource property, masked edit control example 105
RecordSource property, parent/child form example 99
RecordSource property, simple text box example 92
RecordSource property, text box control 97
References dialog box 208
References, ADO libraries 520
References, DAO libraries 389
References, DAO libraries, adding to projects 209
References, dimensioning object variables 560
References, fully-qualified 155
references, object references 209
References, type libraries 389
References, type libraries, identifying available 208
Referential integrity 423
Refresh button, Data Form Wizard 53
Refresh method 169—170
Refresh method, opening/reopening databases 250
Refreshing controls 170
Registry, Windows 635
Relational databases 9 14—16 see
Relational databases, advantages 15
Relational databases, components 15
Relationships, defined 20
Relationships, key-based 21 23
relationships, many-to-many 20
Relationships, many-to-one 21
Relationships, multi-table 31—32
relationships, one-to-many 20—21 61
relationships, one-to-one 20—21
Relationships, parent/child 98
relationships, referential integrity 423
Relationships, structure of 21
Remote Data Objects (RDO) 518
Remote Data Objects (RDO), ODBC support 518
Remote recordsets 799 802—803 809
Remote recordsets, updating the database from 801
Repeating groups 393
required fields 264
Resize event 64
Response object, ASP 667
result sets 563 564
retrieving data see "Searching"
RollBackTrans method 531
Rows 16 52
RowSource property 112
Run-time errors, incorrect focus-setting 227
Run-time errors, initialization failures 157
Run-time errors, no current record 178
Run-time errors, NULL value errors 250
Run-time errors, records with apostrophes 258
Saving data, data values 170
Saving data, files 320
Saving data, records 202—204
Saving data, Wizard Profiles 53
Scope, Public vs. Private 181
scope, variables 152
Screen flicker, reducing 249
screen object 195
Screen objects, accessing 211
Scripting languages 664
Scripting languages, ASP 664
scripting languages, JavaScript 664
Scripting languages, JScript 664
Scripting languages, VBScript 664
Scrollable cursors (ADO) 565 566
scrollbars 119 161
ScrollBars property 161
Scrollbars, adding to text boxes 161
Scrollbars, navigating tables using 119
Scrolling 565
Search Text box (Object Browser) 209 210
Searching, data field types 312—313
Searching, multiple table s 31—32
Searching, Object Browser 210—211
searching, records 238 253
Searching, recordsets 171 354
Searching, sound-alike names, pattern matching for 238
Searching, sound-alike names, Soundex routine for 237
searching, tables 18—24
Select Case statements 176 185
Select screens (Data Form Wizard) 66 71 72
SELECT statements, SQL 353—362
SELECT statements, SQL, aggregate functions 362
SELECT statements, SQL, arithmetic operators 363
SELECT statements, SQL, DISTINCT keyword 359
SELECT statements, SQL, FROM clause 346
SELECT statements, SQL, GROUP BY clause 366 367
SELECT statements, SQL, HAVING clause 367
SELECT statements, SQL, IS NOT NULL clause 364
SELECT statements, SQL, joining tables 367—368
SELECT statements, SQL, joining tables, INNER JOIN 368—369
SELECT statements, SQL, joining tables, OUTER JOIN 369 371
SELECT statements, SQL, keywords list 345
SELECT statements, SQL, ORDER BY clause 360—361
SELECT statements, SQL, SELECT clause 345—346
SELECT statements, SQL, statistical functions 365
Servers, server side scripting 656
Servers, using VBScript 664
Servers, your PC as 656
Set keyword 283
SetFocus method, correct event for 228
SetFocus method, features 229
SetFocus method, premature execution 228
Show method 256
SNAPSHOTS 146
Sorting, data 76
sorting, records 113—114
sorting, recordsets 360—363
Sorting, strings 759
source code 85
SQL (Structured Query Language) 28 32
SQL (Structured Query Language), aggregate functions 361—365
SQL (Structured Query Language), aliasing column headers 362—363
SQL (Structured Query Language), avoiding syntax errors 349
SQL (Structured Query Language), avoiding syntax errors, error handler for 350
SQL (Structured Query Language), Boolean operators 358
SQL (Structured Query Language), building with Access 376—379
SQL (Structured Query Language), comparison operators 355
SQL (Structured Query Language), DELETE statements 359
SQL (Structured Query Language), DISTINCT keyword 359
SQL (Structured Query Language), dynamic queries 345 380—381
SQL (Structured Query Language), dynamic queries, building generator for 380—383
SQL (Structured Query Language), dynamic queries, features 344—345
SQL (Structured Query Language), filtering results 354
SQL (Structured Query Language), filtering results, BETWEEN operator 357
SQL (Structured Query Language), filtering results, IN operator 357
SQL (Structured Query Language), filtering results, LIKE operator 356
SQL (Structured Query Language), filtering results, nested conditions 358
SQL (Structured Query Language), filtering results, NOT IN operator 358
SQL (Structured Query Language), filtering results, WHERE clauses 355
SQL (Structured Query Language), general format 346
SQL (Structured Query Language), grouping identical records 366
SQL (Structured Query Language), joining tables, INNER JOIN approach 368—369
SQL (Structured Query Language), joining tables, OUTER JOIN approach 369 371
SQL (Structured Query Language), joining tables, table.field approach 367 368
SQL (Structured Query Language), keywords 345
SQL (Structured Query Language), modifying data using SQL 384
SQL (Structured Query Language), NULL values 358
SQL (Structured Query Language), ordering recordsets 360—361
SQL (Structured Query Language), recordsets, querying with SQL 145
SQL (Structured Query Language), SELECT statements 346—362
SQL (Structured Query Language), SELECT statements, aggregate functions 362
SQL (Structured Query Language), SELECT statements, arithmetic operators 363
SQL (Structured Query Language), SELECT statements, DISTINCT keyword 359
|
|
|
| Реклама |
|
|
|
|
|
О проекте