|
|
 |
| Àâòîðèçàöèÿ |
|
|
|
| Ïîèñê ïî óêàçàòåëÿì |
|
|
|
|
|
|
|
 |
|
|
|
| Amundsen M., Smith C. — Teach Yourself Database Programming With Visual Basic 4 in 21 Days |
|
|
|
| Ïðåäìåòíûé óêàçàòåëü |
dbDenyWrite option (data controls) 106—107
DBEngine command (File menu) 246
DBEngine data access object 304—311
DBEngine data access object, collections 305
DBEngine data access object, CompactDatabase method 308—310
DBEngine data access object, CreateWorkspace method 314—315
DBEngine data access object, Idle method 311
DBEngine data access object, methods 306—311
DBEngine data access object, properties 305—306
DBEngine data access object, RegisterDatabase method 310—311
DBEngine data access object, RepairDatabase method 307—308
DBEngine.Idle method 585
DBList/DBCombo command (Utility menu) 265—267
DbMake command (SQL-VB) 499
DbOpen command (SQL-VB) 499
DbReadOnly option (data controls) 106—107
DDL (data definition language) statements 272
Declaring, API calls 608
Declaring, global variables (SQL-VB project) 749
declaring, variables 74
Decrypt command (File menu) 44
Decrypting/encrypting databases (Data Manager) 43—45
Default background colors, designing forms 117
Delay (Visdata multiuser setting) 260
Delete command button, inserting into forms 13—16
Delete option (Visdata Table window) 234
Delete queries 630
Delete Section...command (Edit menu) 196
Delete Table queries 544—551
DELETE...FROM statement (SQL) 544—551
DELETE/INSERT method 631
Deleting, data tables, Data Manager 55
Deleting, data tables, DROP TABLE statement (SQL) 505
Deleting, fields from tables 332—333
deleting, indexes 506—508
Deleting, indexes, Data Manager 54
Deleting, operations from records 369
deleting, records 13—16
Deleting, records, CompanyMaster data entry form 172—173
Deleting, records, data integrity 563
Deleting, records, Data Manager 64
Deleting, records, data-bound grid control 431 435—436
Deleting, records, Delete Table queries 544—551
Delimit fonts, designing forms 117
DESC keyword (SQL) 508
design time 102
designing, forms 116—125
Designing, forms, aligning controls 118
Designing, forms, colors 118—125
Designing, forms, custom colors 122—123
Designing, forms, default background colors 117
Designing, forms, default fonts 117
Designing, forms, frame controls 117—118
Designing, forms, input area colors 117
Designing, forms, Panel3D control 117
Designing, forms, sizing controls 118
Designing, forms, standard colors 121—122
Designing, forms, system colors 123—125
Designing, help systems 726—727
Designing, Print Report dialog box (Crystal Reports controls) 204—208
Designing, SQL-VB project 739—740
Detail bands (Crystal Reports Writer) 182—186
DISALLOW NULL keyword (SQL) 509
Disconnecting ODBC link 615
Disk full error 462
Displaying graphs on-screen 403—404
DISTINCT clause (SQL) 285—287
DISTINCTROW clause (SQL) 285—287
DML (Data Management Language) 272 524—525
DML (Data Management Language), append queries 528—534
DML (Data Management Language), Delete Table queries 544—551
DML (Data Management Language), INSERT statement 525—528
DML (Data Management Language), Make Table queries 539—544
DML (Data Management Language), update queries 535—538
Dollar sign ($), custom help footnotes 707
DOUBLE data field type 26 34
Double slashes (//), SQL-VB comment 499 753
DrawMode property (graph control) 393
DROP COLUMN clause 503—505
DROP INDEX statement (SQL) 506—508
DROP TABLE statement (SQL) 505
Dynaset data objects 71—83
Dynaset data objects, advantages 71
Dynaset data objects, cloning 73—80
Dynaset data objects, compared to Snapshot data objects 90—93
Dynaset data objects, counting records 75—76
Dynaset data objects, creating 71 75
Dynaset data objects, creating from multiple tables 73
Dynaset data objects, data integrity 83
Dynaset data objects, disadvantages 82—83
Dynaset data objects, indexes 82—83
Dynaset data objects, keysets 71—72
Dynaset data objects, ODBC (Open Database Connectivity) 82
Dynaset data objects, refreshing 72
Dynaset data objects, searching 80—82
Dynaset data objects, searching, Find method 356—357
Dynaset data objects, when to use 83
Edit command (File menu) 748 762
Edit Group Selection Formula command (Report menu) 201
Edit menu commands, Browse Field Data... 195—196
Edit menu commands, Copy 30 195
Edit menu commands, Cut 195
Edit menu commands, Delete Section... 196
Edit menu commands, Formula... 195
Edit menu commands, Group Section... 196
Edit menu commands, Links... 196
Edit menu commands, Object 196
Edit menu commands, Paste 30 195
Edit menu commands, Paste Special 195
Edit menu commands, Select Fields 195
Edit menu commands, Send Behind Others 196
Edit menu commands, Show/Hide Sections 196
Edit menu commands, Summary Field... 195
Edit menu commands, Text Field... 195
Edit method, writing to data sets 367
Edit Record Selection Formula command (Report menu) 201
editing, fields 47 254
Editing, formula fields (Crystal Reports Writer) 191
Editing, graphs, design time 392
Editing, graphs, QuickData property 394—396
Editing, graphs, runtime 392—394
Editing, indexes in data tables (Data Manager) 55—63
Editing, project files (online help) 717—721
Editing, scripts (SQL-VB Interpreter) 497—498
Editing, tables, ALTER TABLE...ADD COLUMN statement 503—505
Editing, tables, ALTER TABLE...DROP COLUMN statement 503—505
Editing, tables, update queries 535—538
Embedded spaces (field/index names) 52
Enabled property, BtnBarEnable routine 374
Enabled property, RecEnable routine 368
Enabling bound controls 368
Enabling command buttons (BtnBarEnable routine) 374
Encrypt command (File menu) 43
Encrypting/decrypting databases (Data Manager) 43—45
Encryption (Microsoft JET) 648
End method, exiting error handlers 458—459
Enforcing referential integrity 58
Environment command (Options menu) 9 119
ErrMsg procedure (SQL-VB project) 760
Error event (data controls) 110—112
error handlers 448—449
Error handlers, cascading errors 451—453
Error handlers, creating 450—451
Error handlers, exiting 450
Error handlers, exiting, End method 458—459
Error handlers, exiting, Resume label method 457—458
Error handlers, exiting, Resume method 453—455
Error handlers, exiting, Resume Next method 455—457
Error handlers, libraries, creating 469—471
Error handlers, logging errors 471—474
| Error handlers, module traces 475—479
Error handlers, On Error Goto statement 449
Error trapping, compared to input validation 130
Error trapping, routines 655
Errors 459—460
Errors command (File menu) 245
Errors, database errors 462—467
Errors, general file errors 460—462
Errors, ODBC error codes 611
Errors, physical media errors 467—468
Errors, program code errors 468
Events, column-level events (data-bound grid control) 436—437
Events, Error event (data controls) 110—112
Events, Form_Activate event (Crystal Reports control) 209—210
Events, KeyPress event (text box controls) 133—136
Events, Reposition event (data controls) 110—112
Events, trapping events (data-bound grid control) 433
Events, Validate event (data controls) 110—112
Excel command (File menu) 242—243
Exclusive property, data controls 104—105
Exclusive property, locking databases 579
Execute method (Database data access object) 325—326
ExecuteSQL method (Database data access object) 325—326
Exit command (File menu) 194 748
Exit Visdata command (File menu) 251
Exiting error handlers 450
Exiting error handlers, End method 458—459
Exiting error handlers, Resume label method 457—458
Exiting error handlers, Resume method 453—455
Exiting error handlers, Resume Next method 455—457
External data tables, attaching to databases 334—336
F1 key command (help screen) 4
F4 key command (opening listboxes) 49
F5 key command (compiling programs) 13
Field data access object 336—337
Field data access object, properties 336—337
Field lengths, form level validation 142—143
Field level input validation 132—140
Field level input validation, filtering keyboard input 132—136
Field level input validation, masking input 136—138
Field level input validation, validation lists 139—140
Field...command (Format menu) 199
Fields (relational databases) 18—19 see
Fields (relational databases), adding to data tables 332—333
Fields (relational databases), adding to data tables, Data Manager 47—50
Fields (relational databases), conditional fields, form level validation 145—146
Fields (relational databases), conditional fields, input validation 131
Fields (relational databases), COUNTER 533
Fields (relational databases), Crystal Reports Writer 182
Fields (relational databases), data normalizadon 558—561
Fields (relational databases), deleting from tables 332—333
Fields (relational databases), deleting from tables, editing 47 254
Fields (relational databases), deleting from tables, key fields 23—25
Fields (relational databases), deleting from tables, length 501
Fields (relational databases), deleting from tables, pointer fields 21
Fields (relational databases), deleting from tables, qualifier fields 21
Fields (relational databases), deleting from tables, required fields, form level validation 144—145
File already exists error 462
File already open error 462
File menu commands, Close 193
File menu commands, Close Database 41 232 245
File menu commands, Compact Database 42 249—250
File menu commands, Decrypt 44
File menu commands, Edit 748 762
File menu commands, Encrypt 43
File menu commands, Errors 245
File menu commands, Exit 194 748
File menu commands, Exit Visdata 251
File menu commands, Make EXE File 228 763
File menu commands, Make Visdata a VB Add-In 229 251
File menu commands, New 247—249 748
File menu commands, New Database 45
File menu commands, New Project 4
File menu commands, New, Cross-Tab... 193
File menu commands, New, dBASE 248—249
File menu commands, New, FoxPro 248—249
File menu commands, New, JET 247—248
File menu commands, New, Mailing Labels Report 193
File menu commands, New, Paradox 248—249
File menu commands, New, Report... 193
File menu commands, New, Text 249
File menu commands, Open Database 40 231—232 239—245
File menu commands, Open Database, dBASE 240—241
File menu commands, Open Database, Excel 242—243
File menu commands, Open Database, FoxPro 241
File menu commands, Open Database, JET Engine MDB 239—240
File menu commands, Open Database, ODBC 244—245
File menu commands, Open Database, Paradox 241
File menu commands, Open Database, Text Files 244
File menu commands, Open Project 227
File menu commands, Open... 6 193
File menu commands, Options... 194
File menu commands, Page Margins 194
File menu commands, Print Preview 186 194
File menu commands, Print, Export 194
File menu commands, Print, Printer 194
File menu commands, Print, Report Definition 194
File menu commands, Printer Setup 194
File menu commands, Properties 245—247
File menu commands, Properties, Database 246—247
File menu commands, Properties, DBEngine 246
File menu commands, Properties, Workspace 246
File menu commands, Repair Database 42 250—251
File menu commands, Run 748 763
File menu commands, Save 193
File menu commands, Save As... 193
File menu commands, Save Project 9
File not found error 462
Filter property, Dynaset data objects 77—78 80
Filter property, Table data objects 88—89
Filtering keyboard input (input validation) 132—136
Find method, searching records 356—357
FindFirst method 356
Finding records, CompanyMaster data entry form 172
Finding records, Data Manager 63—64
FindLast method 356
FindNext method 356
FindPrevious method 356
Font...command (Format menu) 199
Fonts, default (designing forms) 117
Footer and header bands (Crystal Reports Writer) 181 187—192
Footnotes (help files) 705
FOREIGN KEY...REFERENCES clause (CONSTRAINT keyword) 514—518
foreign keys 23—25
Form level input validation 140—146
Form level input validation, conditional fields 145—146
Form level input validation, field lengths 142—143
Form level input validation, required fields 144—145
Form level input validation, value ranges 141—142
Format menu commands, Border and Colors... 199
Format menu commands, Box 199
Format menu commands, Field... 199
Format menu commands, Font... 199
Format menu commands, Graphic... 199
Format menu commands, Line 199
Format menu commands, Section... 199
Forms, BackColor property 117
Forms, BackStyle property 117
forms, centering 663
Forms, CompanyMaster data entry form 156—176
Forms, CompanyMaster data entry form, basic form definition 156—159
Forms, CompanyMaster data entry form, command buttons 169—173
Forms, CompanyMaster data entry form, Company Logo controls 168—169
Forms, CompanyMaster data entry form, input controls 159—169
Forms, CompanyMaster data entry form, input validation 174—176
Forms, CompanyMaster data entry form, screen prompts 159—169
Forms, CompanyMaster data entry form, unloading 171
Forms, creating for SQL-VB project 740—749
Forms, data entry forms, selecting in Visdata 237—238
forms, designing 116—125
|
|
|
| Ðåêëàìà |
|
|
|
|
|
Î ïðîåêòå