|
|
 |
| Àâòîðèçàöèÿ |
|
|
|
| Ïîèñê ïî óêàçàòåëÿì |
|
|
|
|
|
|
|
 |
|
|
|
| Amundsen M., Smith C. — Teach Yourself Database Programming With Visual Basic 4 in 21 Days |
|
|
|
| Ïðåäìåòíûé óêàçàòåëü |
Data controls, DatabaseName property 5—7 101—104
Data controls, dbAppendOnly option 106—107
Data controls, dbDenyWrite option 106—107
Data controls, dbReadOnly option 106—107
Data controls, Error event 110—112
Data controls, Exclusive property 104—105
Data controls, Name property 7—8
Data controls, Options property 105—107
Data controls, ReadOnly property 104—105
Data controls, Recordset data objects 93—94
Data controls, RecordSource property 5—7 101—104
Data controls, Refresh method 107—110
Data controls, Reposition event 110—112
Data controls, restoring (CompanyMaster data entry form) 172
Data controls, UpdateControls method 107—110
Data controls, UpdateRecord method 107—110
Data controls, Validate event 110—112
Data definition language statements (DDL) 272
Data entry forms, building 633—634
Data entry forms, coding 634—640
Data entry forms, running 640—641
Data entry forms, selecting in Visdata 237—238
Data field types 25—27
Data field types, BINARY 26 34
Data field types, BOOLEAN 26—27 34
Data field types, BOOLEAN, testing 29
Data field types, BYTE 26—27 34
Data field types, BYTE, testing 29—30
Data field types, compared to Visual Basic data types 26
Data field types, COUNTER 26—27
Data field types, COUNTER, testing 32—33
Data field types, CURRENCY 26 34
Data field types, CURRENCY, testing 31
Data field types, DATE 34
Data field types, DATE, testing 31—32
Data field types, DATETIME 26
Data field types, DOUBLE 26 34
Data field types, INTEGER 26 34
Data field types, LONG 26
Data field types, LONGBINARY 26—27 34
Data field types, MEMO 26—27
Data field types, project 27—34
Data field types, SINGLE 26 34
Data field types, TEXT 26—27 33
Data fields 18—19
Data fields, adding to data tables 332—333
Data fields, adding to data tables, Data Manager 47—50
Data fields, conditional fields, form level validation 145—146
Data fields, conditional fields, input validation 131
Data fields, COUNTER 533
Data fields, Crystal Reports Writer 182
Data fields, data normalization 558—561
Data fields, deleting from tables 332—333
Data fields, editing 47 254
Data fields, key fields 23—25
Data fields, length 501
Data fields, pointer fields 21
Data fields, qualifier fields 21
Data fields, required fields, form level validation 144—145
Data integrity, data normalization 562—563
Data integrity, deleting records 563
Data integrity, Dynaset data objects 83
Data integrity, referential integrity 25
Data integrity, referential integrity, enforcing 58
Data integrity, referential integrity, Relation data access object 341—344
Data Management Language (DML) 272 524—525
Data Management Language (DML), append queries 528—534
Data Management Language (DML), Delete Table queries 544—551
Data Management Language (DML), INSERT statement 525—528
Data Management Language (DML), Make Table queries 539—544
Data Management Language (DML), update queries 535—538
Data manager 38
Data Manager, adding fields to data tables 47—50
Data Manager, adding indexes to data tables 51—54
Data Manager, adding records to data tables 61—63
Data Manager, advantages/disadvantages 39
Data Manager, attaching external data tables 55—57
Data Manager, closing databases 41
Data Manager, compacting databases 41—43
Data Manager, compared to VisData 226
Data Manager, creating data tables 46—47
Data Manager, creating databases 45—46
Data Manager, creating queries 60—61
Data Manager, creating relationships 57—59
Data Manager, deleting data tables 55
Data Manager, deleting indexes from data tables 54
Data Manager, deleting records from data tables 64
Data Manager, editing indexes in data tables 55—63
Data Manager, encrypting/decrypting databases 43—45
Data Manager, locating records in data tables 63—64
Data Manager, opening databases 40—41
Data Manager, refreshing records in data tables 63
Data Manager, repairing databases 41—43
Data Manager, saving queries 60—61
Data Manager, updating records in data tables 63
Data normalization 556—558
Data normalization, data integrity 562—563
Data normalization, eliminating repeating groups 558—561
Data normalization, Fifth Normal Form 571
Data normalization, First Normal Form 559—561
Data normalization, Fourth Normal Form 569
Data normalization, independent relationships 568—570
Data normalization, primary keys 565—568
Data normalization, redundant data 562—565
Data normalization, related multiple relationships 570—575
Data normalization, Second Normal Form 562—565
Data normalization, Third Normal Form 566—568
Data objects 68—97 see
Data objects, Database 68 94—95
Data objects, Dynaset 71—83
Data objects, Dynaset, advantages 71
Data objects, Dynaset, cloning 73—80
Data objects, Dynaset, compared to Snapshot data objects 90—93
Data objects, Dynaset, counting records 75—76
Data objects, Dynaset, creating 71 75
Data objects, Dynaset, creating from multiple tables 73
Data objects, Dynaset, data integrity 83
Data objects, Dynaset, disadvantages 82—83
Data objects, Dynaset, indexes 82—83
Data objects, Dynaset, key sets 71—72
Data objects, Dynaset, ODBC (Open Database Connectivity) 82
Data objects, Dynaset, refreshing 72
Data objects, Dynaset, searching 80—82
Data objects, Dynaset, when to use 83
Data objects, record-oriented systems, compared to set-oriented systems 70
Data objects, Recordset 68 93—94
Data objects, Snapshot 89—93
Data objects, Snapshot, compared to Dynaset data objects 90—93
Data objects, Snapshot, storing 90
Data objects, Snapshot, when to use 93
Data objects, Table 83—89
Data objects, Table, advantages/disadvantages 83—84
Data objects, Table, Bookmarks 88—89
Data objects, Table, instant record updates 84
Data objects, Table, ODBC (Open Database Connectivity) 89
Data objects, Table, pointers 84
Data objects, Table, Seek method 84—88
Data objects, Table, when to use 89
Data record-oriented systems, compared to data set-oriented systems 68—70
Data records 19—20
Data records, adding to data tables 13—16
Data records, adding to data tables, CompanyMaster data entry form 171
Data records, adding to data tables, Data Manager 61—63
Data records, counting in Dynasets 75—76
Data records, deleting 13—16
Data records, deleting CompanyMaster data entry form 172—173
Data records, deleting data integrity 563
Data records, deleting data-bound grid control 431 435—436
Data records, deleting Delete Table queries 544—551
Data records, deleting from data tables (Data Manager) 64
| Data records, inserting data-bound grid control 431 433—437
Data records, locating CompanyMaster data entry form 172
Data records, locating Data Manager 63—64
Data records, page-level locking 581—582
Data records, page-level locking, LockEdits property 582
Data records, refreshing in data tables (Data Manager) 63
Data records, searching 349—350
Data records, searching, bookmarks 357—358
Data records, searching, Find method 356—357
Data records, searching, Move methods 350—354
Data records, searching, NoMatch method 355
Data records, searching, RecLocate routine 364—365
Data records, searching, Seek method 354—355
Data records, sorting 276—277
Data records, updating, Data Manager 63
Data records, updating, data-bound grid control 434—435
Data records, writing, CompanyMaster data entry form 172
Data set-oriented systems, compared to record-oriented systems 68—70
Data sources (ODBC), connection handles 615
Data sources (ODBC), connections 641
Data sources (ODBC), RDC (Remote Data Control) 642
Data sources (ODBC), registering 606—608
data tables 20
Data tables, adding fields to 47—50 332—333
Data tables, adding indexes to 51—54
Data tables, adding records to 61—63
Data tables, adding to databases 252—253
Data tables, attaching external 55—57 334—336
Data tables, backing up 539
Data tables, building (Visdata) 254
Data tables, columns, length 501
Data tables, compared to databases 7
Data tables, constraints, deleting 519—520
Data tables, constraints, inserting 519—520
Data tables, copying, Make Table queries 539—544
Data tables, creating 46—47
Data tables, creating CREATE TABLE statement (SQL) 501—503
Data tables, creating in databases 330—331
Data tables, creating Make Table queries 539—544
Data tables, creating relationships 57—59
Data tables, data normalization 556—558
Data tables, data normalization, data integrity 562—563
Data tables, data normalization, eliminating repeating groups 558—561
Data tables, data normalization, Fifth Normal Form 571
Data tables, data normalization, First Normal Form 559—561
Data tables, data normalization, Fourth Normal Form 569
Data tables, data normalization, independent relationships 568—570
Data tables, data normalization, primary keys 565—568
Data tables, data normalization, redundant data 562—565
Data tables, data normalization, related multiple relationships 570—575
Data tables, data normalization, Second Normal Form 562—565
Data tables, data normalization, Third Normal Form 566—568
Data tables, deleting 55 505
Data tables, deleting fields 332—333
Data tables, deleting indexes from 54
Data tables, deleting records from 64
Data tables, editing ALTER TABLE...ADD COLUMN statement 503—505
Data tables, editing ALTER TABLE...DROP COLUMN statement 503—505
Data tables, editing indexes in 55—63
Data tables, editing update queries 535—538
Data tables, indexes, sort key 508
Data tables, linking WHERE clause (SQL) 280—291
Data tables, locating records in 63—64
Data tables, locking 580—581
Data tables, multiple tables, creating Dynaset data objects from 73
Data tables, optimizing speed 556—558
Data tables, records, deleting 544—551
Data tables, records, page-level locking 581—582
Data tables, refreshing records in 63
Data tables, relationships 21—23 514—518
Data tables, relationships, one-to-many relationships 23
Data tables, relationships, one-to-one relationships 21—22
Data tables, rows, append queries 528—534
Data tables, rows, inserting 525—528
Data tables, updating records in 63
Data tables, validation tables 514
Data tables, virtual data tables 71
Data types, compared to data field types 26
Data-bound combo box control 425—430
Data-bound grid control, column-level events 436—437
Data-bound grid control, creating 430—431
Data-bound grid control, records, deleting 431 435—436
Data-bound grid control, records, inserting 431 433—437
Data-bound grid control, records, updating 434—435
Data-bound grid control, setting properties 432
Data-bound grid control, trapping events 433
Data-bound list box control 429—430
Data-bound list control 418—425
Data-form grid control (Subforms), creating 437—443
Database command (File menu) 246—247
Database data access object 319—327
Database data access object, collections 320
Database data access object, CreateProperty method 326—327
Database data access object, Execute method 325—326
Database data access object, ExecuteSQL method 325—326
Database data access object, methods 322—327
Database data access object, OpenRecordset method 323—324
Database data access object, properties 320—322
Database data objects 68 94—95
Database errors 462—467
Database Field...command (Insert menu) 197
Database fields (Crystal Reports Writer) 182
Database integrity 508—509
Database menu commands, Add Database to Report... 200
Database menu commands, Links... 200
Database menu commands, Log Off Server 200
Database menu commands, Log On Server 200
Database menu commands, Remove from Report... 200
Database menu commands, Set Alias... 200
Database menu commands, Set Location... 200
Database menu commands, Show SQL Query 200
Database menu commands, Verify Database 200
Database menu commands, Verify on Every Print 200
Database models, record-oriented compared to set- oriented 68—70
Database-level locking 579—580
DatabaseName property (data controls) 5—7 101—104
Databases, adding indexes to (Visdata) 254—255
Databases, adding new tables 252—253
Databases, attaching external data tables 334—336
Databases, closing (Data Manager) 41
Databases, compacting (Data Manager) 41—43
Databases, compared to data tables 7
Databases, creating Data Manager 45—46
Databases, creating Microsoft JET engine databases 252
Databases, creating new tables 330—331
Databases, encrypting/decrypting (Data Manager) 43—45
databases, locking 579—580
Databases, opening Data Manager 40—41
Databases, opening RSOpen routine 361—363
databases, relational databases 18
Databases, relational databases, data tables 20
Databases, relational databases, fields 18—19
Databases, relational databases, key fields 23—25
Databases, relational databases, records 19—20
Databases, repairing (Data Manager) 41—43
Databases, transactions, attaching tables to Microsoft JET databases 334—336
Databases, transactions, creating 319
DataField property, data-bound list control 424
DataField property, text box controls 10—13
DataField property, text/label controls 113
DataSource property, data-bound list control 424
DataSource property, text box controls 10—13
DataSource property, text/label controls 113
DATE data field type 34
DATE data field type, testing 31—32
Date formats, Regional Settings applet (Windows 95) 32
DATETIME data field type 26
dbAppendOnly option (data controls) 106—107
dBASE command (File menu) 240—241 248—249
dbClose command (SQL-VB) 500
|
|
|
| Ðåêëàìà |
|
|
|
|
|
Î ïðîåêòå