|
|
 |
| Àâòîðèçàöèÿ |
|
|
|
| Ïîèñê ïî óêàçàòåëÿì |
|
|
|
|
|
|
|
 |
|
|
|
| Amundsen M., Smith C. — Teach Yourself Database Programming With Visual Basic 4 in 21 Days |
|
|
|
| Ïðåäìåòíûé óêàçàòåëü |
Locating records, CompanyMaster data entry form 172
Locating records, Data Manager 63—64
LockEdits property 582
Locking, database-level locking 579—580
Locking, page-level locking 581—582
Locking, page-level locking, examples 582—587
Locking, page-level locking, guidelines 587
Locking, page-level locking, LockEdits property 582
Locking, table-level locking 580—581
LodFileTypes procedure (Crystal Reports control) 209
Log Off Server command (Database menu) 200
Log On Server command (Database menu) 200
Log/Lin graphs 391
logging errors 471—474
Logical comparisons (SQL) 278
Login Time-Out Value command (Preferences menu) 268
LONG data field type 26
LONGBINARY data field type 26—27 34
Main Menu (Visdata) 231—232
Main() routine 660
Make EXE File command (File menu) 228 763
Make Table queries 539—544
Make Visdata a VB Add-In command (File menu) 229 251
Marking footnotes in help files 705
MaskedEdit controls, input validation 136—138
Masking input 136—138
MAX (SQL aggregate function) 282
MDIForm command (Insert menu) 740
MEMO data field type 26—27
Menus, help commands (adding to menus) 719—721
METHODS 303
Methods, AddNew, writing to data sets 367
Methods, Clone 73
Methods, CompactDatabase 648
Methods, CompactDatabase, DBEngine data access object 306 308—310
methods, CreateDatabase 648
Methods, CreateDatabase, Workspace data access object 316—318
Methods, CreateDynaset 73
Methods, CreateField 330
Methods, CreateIndex 330
Methods, CreateProperty 330
Methods, CreateProperty, Database data access object 326—327
Methods, CreateWorkspace (DBEngine data access object) 307 314—315
Methods, data controls 107—110
Methods, Database data access object 323—324
Methods, Database data access object methods 322—327
Methods, DBEngine data access object methods 306—311
Methods, DBEngine.Idle 585
Methods, DELETE/INSERT 631
Methods, Edit, writing to data sets 367
Methods, End, exiting error handlers 458—459
Methods, Execute (Database data access object) 325—326
Methods, ExecuteSQL (Database data access object) 325—326
Methods, Find, searching records 356—357
Methods, Idle (DBEngine data access object) 307 311
Methods, Move, searching records 350—354
Methods, MoveLast 404
Methods, NoMatch, searching records 355
Methods, OpenDatabase (Workspace data access object) 316—318
Methods, OpenRecordset 330
Methods, Path 74
Methods, Refresh 72
Methods, RefreshLink 330
Methods, RegisterDatabase (DBEngine data access object) 306 310—311
Methods, RepairDatabase (DBEngine data access object) 306—308
Methods, Resume label, exiting error handlers 457—458
Methods, Resume Next, exiting error handlers 455—457
Methods, Resume, exiting error handlers 453—455
Methods, Seek, searching records 354—355
Methods, Seek, Table data objects 84—88
Methods, TableDef data access object methods 330—336
Methods, UpdateControls (data controls) 107—110
Methods, UpdateRecord (data controls) 107—110
Methods, Workspace data access object methods 315—319
Microsoft Access databases (Data Manager) 38
Microsoft Access databases (Data Manager), adding fields to data tables 47—50
Microsoft Access databases (Data Manager), adding indexes to data tables 51—54
Microsoft Access databases (Data Manager), adding records to data tables 61—63
Microsoft Access databases (Data Manager), advantages/disadvantages 39
Microsoft Access databases (Data Manager), attaching external data tables 55—57
Microsoft Access databases (Data Manager), closing databases 41
Microsoft Access databases (Data Manager), compacting databases 41—43
Microsoft Access databases (Data Manager), creating data tables 46—47
Microsoft Access databases (Data Manager), creating databases 45—46
Microsoft Access databases (Data Manager), creating queries 60—61
Microsoft Access databases (Data Manager), creating relationships 57—59
Microsoft Access databases (Data Manager), databases 43—45
Microsoft Access databases (Data Manager), deleting data tables 55
Microsoft Access databases (Data Manager), deleting indexes from data tables 54
Microsoft Access databases (Data Manager), deleting records from data tables 64
Microsoft Access databases (Data Manager), editing indexes in data tables 55—63
Microsoft Access databases (Data Manager), locating records in data tables 63—64
Microsoft Access databases (Data Manager), opening databases 40—41
Microsoft Access databases (Data Manager), refreshing records in data tables 63
Microsoft Access databases (Data Manager), repairing databases 41—43
Microsoft Access databases (Data Manager), saving queries 60—61
Microsoft Access databases (Data Manager), updating records in data tables 63
Microsoft Access SYSTEM security file 646
Microsoft Access SYSTEM security file, limitations 646—648
Microsoft Code Page Translator driver 604
Microsoft JET (Joint Engine Technology) database engine 302—345
Microsoft JET (Joint Engine Technology) database engine, attaching non-Microsoft JET tables to 334—336
Microsoft JET (Joint Engine Technology) database engine, cascading updates/deletes 587—588
Microsoft JET (Joint Engine Technology) database engine, cascading updates/deletes, building demo project 588—591
Microsoft JET (Joint Engine Technology) database engine, cascading updates/deletes, guidelines 592—593
Microsoft JET (Joint Engine Technology) database engine, cascading updates/deletes, running project 591—592
Microsoft JET (Joint Engine Technology) database engine, comparisons to ANSI SQL standards 273
Microsoft JET (Joint Engine Technology) database engine, comparisons to data controls 303
Microsoft JET (Joint Engine Technology) database engine, creating databases 247—248 252
Microsoft JET (Joint Engine Technology) database engine, data access objects 303—304
Microsoft JET (Joint Engine Technology) database engine, data access objects, Database 319—327
Microsoft JET (Joint Engine Technology) database engine, data access objects, DBEngine 304—311
Microsoft JET (Joint Engine Technology) database engine, data access objects, Field 336—337
Microsoft JET (Joint Engine Technology) database engine, data access objects, Index 338—339
Microsoft JET (Joint Engine Technology) database engine, data access objects, QueryDef 340—341
Microsoft JET (Joint Engine Technology) database engine, data access objects, Relation 341—344
Microsoft JET (Joint Engine Technology) database engine, data access objects, TableDef 328—336
Microsoft JET (Joint Engine Technology) database engine, data access objects, Workspace 312—319
Microsoft JET (Joint Engine Technology) database engine, database-level locking 579—580
Microsoft JET (Joint Engine Technology) database engine, definition 302—303
Microsoft JET (Joint Engine Technology) database engine, encryption 648
Microsoft JET (Joint Engine Technology) database engine, key sets 71
Microsoft JET (Joint Engine Technology) database engine, loading 239—240
Microsoft JET (Joint Engine Technology) database engine, Microsoft Access SYSTEM security file 646
Microsoft JET (Joint Engine Technology) database engine, Microsoft Access SYSTEM security file, limitations 646—648
Microsoft JET (Joint Engine Technology) database engine, opening databases 231—232
Microsoft JET (Joint Engine Technology) database engine, page-level locking 581—582
Microsoft JET (Joint Engine Technology) database engine, table-level locking 580—581
Microsoft JET (Joint Engine Technology) database engine, transactions 593
Microsoft JET (Joint Engine Technology) database engine, transactions, advantages 597
Microsoft JET (Joint Engine Technology) database engine, transactions, building projects 594—597
Microsoft JET (Joint Engine Technology) database engine, transactions, limitations 597
Microsoft JET (Joint Engine Technology) database engine, transactions, workspace objects 593—594
Microsoft JET (Joint Engine Technology) database engine, VisdataJET menu commands 256—261
MIN (SQL aggregate (unction) 283
Module command (Insert menu) 147 749
Module traces (error handlers) 475—479
Move methods, searching records 350—354
Move methods, searching records, MoveFirst 350
Move methods, searching records, MoveLast 350 404
Move methods, searching records, MoveNext 350
Move methods, searching records, MovePrevious 350
Multiple tables, creating Dynaset data objects from 73
Multiuser Settings command (JET menu) 260—261
Name property, data controls 7—8
Name property, Database data access object 321
naming conventions 8
Naming conventions, embedded spaces (field/index names) 52
naming conventions, variables 74
New command (File menu) 247—249 748
| New command (File menu), Cross-Tab... 193
New command (File menu), dBASE 248—249
New command (File menu), FoxPro 248—249
New command (File menu), JET 247—248
New command (File menu), Mailing Labels Report 193
New command (File menu), Paradox 248—249
New command (File menu), Report... 193
New command (File menu), Text 249
New command button, inserting into forms 13—16
New Database command (File menu) 45
New Project command (File menu) 4
nGphType parameter (ShowGraph routine) 403
NoMatch method, searching records 355
Normalized tables 556—558
Normalized tables, data integrity 562—563
Normalized tables, eliminating repeating groups 558—561
Normalized tables, Fifth Normal Form 571
Normalized tables, First Normal Form 559—561
Normalized tables, Fourth Normal Form 569
Normalized tables, independent relationships 568—570
Normalized tables, primary keys 565—568
Normalized tables, redundant data 562—565
Normalized tables, related multiple relationships 570—575
Normalized tables, Second Normal Form 562—565
Normalized tables, Third Normal Form 566—568
NumPoints property 391
NumSets property 391
Object command, Edit menu 196
Object command, Insert menu 198
Objects, relation objects, cascading updates/deletes 587
Objects, Snapshots 422
Objects, workspace objects, transactions 593—594
ODBC (Open Database Connectivity), API calls 609—611
ODBC (Open Database Connectivity), API calls, allocating environment handles 613
ODBC (Open Database Connectivity), API calls, data source connection handles 615
ODBC (Open Database Connectivity), API calls, declaring 608
ODBC (Open Database Connectivity), API calls, environment handles 616
ODBC (Open Database Connectivity), API calls, high-level routines 618—633
ODBC (Open Database Connectivity), API calls, local variables 612—613
ODBC (Open Database Connectivity), API calls, low-level API calls 611—612
ODBC (Open Database Connectivity), API calls, mid-level routines 613—618
ODBC (Open Database Connectivity), API calls, wrappers 612
ODBC (Open Database Connectivity), building ODBC libraries 611—612
ODBC (Open Database Connectivity), data entry forms, building 633—634
ODBC (Open Database Connectivity), data entry forms, coding 634—640
ODBC (Open Database Connectivity), data entry forms, running 640—641
ODBC (Open Database Connectivity), data sources, connections 641
ODBC (Open Database Connectivity), data sources, registering 606—608
ODBC (Open Database Connectivity), disconnecting ODBC link 615
ODBC (Open Database Connectivity), Dynaset data objects 82
ODBC (Open Database Connectivity), error codes 611
ODBC (Open Database Connectivity), functions, creating 615
ODBC (Open Database Connectivity), interface 603—604
ODBC (Open Database Connectivity), interface, installing 604—606
ODBC (Open Database Connectivity), interface, shutting down 610
ODBC (Open Database Connectivity), optimistic locking 587
ODBC (Open Database Connectivity), RDC (Remote Data Control) 642
ODBC (Open Database Connectivity), RDO (Remote Data Objects) 642
ODBC (Open Database Connectivity), RegisterDatabase method (DBEngine data access object) 310—311
ODBC (Open Database Connectivity), Table data objects 89
ODBC (Open Database Connectivity), tracing activity 642
ODBC command (File menu) 244—245
OK command button, coding (Crystal Reports controls) 211—212
On Error GoTo statement 449
One-to-many relationships (data tables) 23
One-to-one relationships (data tables) 21—22
online Help 702
Online help, About dialog box 721
Online help, adding help commands to menus 719—721
Online help, authoring tools 725—726
Online help, code for help file 723—725
Online help, contents pages 714—715
Online help, creating menu events 721—722
Online help, creating topic files 703—710
Online help, designing help system 726—727
Online help, jumps 714
Online help, linking to applications 713
Online help, project files 711
Online help, project files, compiling 712
Online help, project files, editing 717—721
Online help, project files, Titles section 711
Online help, project files, [Alias] section 712
Online help, project files, [Buildtags] section 712
Online help, project files, [Config] section 712
Online help, project files, [Map] section 712
Online help, project files, [Options] section 711
Online help, properties for attaching files 713—714
Online help, topic files 703
Online help, topic files, context strings 705—706
Online help, topic files, creating browse sequences 708—709
Online help, topic files, footnotes 705
Online help, topic files, keywords 707—708
Online help, topic files, pop-ups 715—717
Online help, topic files, saving 709
Online help, topic files, separating topics 704
Online help, topic files, titles 706—707
Online help, topic files, tracking 710
Online help, topic files, writing text for files 703—704
Open Database command (File menu) 40 231—232 239—245
Open Database command (File menu), dBASE 240—241
Open Database command (File menu), Excel 242—243
Open Database command (File menu), FoxPro 241
Open Database command (File menu), JET Engine MDB 239—240
Open Database command (File menu), ODBC 244—245
Open Database command (File menu), Paradox 241
Open Database command (File menu), Text Files 244
Open Database Connectivity see "ODBC"
Open Last Database command (Preferences menu) 267
Open Project command (File menu) 227
Open...command (File menu) 6 193
OpenDatabase method (Workspace data access object) 316—318
Opening databases, Data Manager 40—41
Opening databases, RSOpen routine 361—363
OpenRecordset method 330
OpenRecordset method, Database data access object 323—324
optimistic locking 582
Optimistic Locks on Update (Visdata multiuser setting) 261
Optimizing table speed 556—558
Optimizing table speed, data integrity 562—563
Optimizing table speed, Fifth Normal Form 571
Optimizing table speed, First Normal Form 559—561
Optimizing table speed, Fourth Normal Form 569
Optimizing table speed, independent relationships 568—570
Optimizing table speed, primary keys 565—568
Optimizing table speed, redundant data 562—565
Optimizing table speed, related multiple relationships 570—575
Optimizing table speed, Second Normal Form 562—565
Optimizing table speed, Third Normal Form 566—568
Options command (Tools menu) 5
Options menu commands (Environment) 9 119
Options property (data controls) 105—107
Options...command (File menu) 194
OR operator (SQL) 278
ORDER BY clause (SQL) 276—277
Page Margins command (File menu) 194
Page numbers, adding to reports 188
Page-level locking 581—582
Page-level locking, examples 582—587
Page-level locking, guidelines 587
Page-level locking, LockEdits property 582
palettes 156
Palettes, designing forms 117 119
Panel3D control, designing forms 117
Paradox command (File menu) 241 248—249
Parameters (Validate event), Action parameter 111
Parameters (Validate event), Save parameter 111
Passthroughs (SQL) 61
PasswordChar property 660
Paste command (Edit menu) 30 195
Paste Special command (Edit menu) 195
|
|
|
| Ðåêëàìà |
|
|
|
|
|
Î ïðîåêòå