|
|
 |
| Àâòîðèçàöèÿ |
|
|
|
| Ïîèñê ïî óêàçàòåëÿì |
|
|
|
|
|
|
|
 |
|
|
|
| Amundsen M., Smith C. — Teach Yourself Database Programming With Visual Basic 4 in 21 Days |
|
|
|
| Ïðåäìåòíûé óêàçàòåëü |
Keywords, CommitTrans 593
Keywords, DML (Data Management Language) 524—525
Keywords, online help topic files 707—708
Keywords, RollBack 593
Keywords, SQL (Structured Query Language), AS 282
Keywords, SQL (Structured Query Language), ASC 508
Keywords, SQL (Structured Query Language), CONSTRAINTS 509—520
Keywords, SQL (Structured Query Language), DESC 508
Keywords, SQL (Structured Query Language), IN 279
Keywords, SQL (Structured Query Language), LIKE 279—280
Label controls, bound label controls 112—113
Label controls, DataField property 113
Label controls, DataSource property 113
Labels, graphs 396—397
Labels, legends 396—397
Labels, titles 396—397
LEFT JOIN clause (SQL) 292—293
Legends (graphs) 396—397
Level I compliance (SQL) 273
Libraries, bound controls, BtnBarEnable routine 374
Libraries, bound controls, BtnBarInit routine 372—374
Libraries, bound controls, BtnBarProcess routine 375—379
Libraries, bound controls, RecDelete routine 369
Libraries, bound controls, RecEnable routine 368
Libraries, bound controls, RecInit routine 363—364
Libraries, bound controls, RecLocate routine 364—365
Libraries, bound controls, RecRead routine 366
Libraries, bound controls, RecWrite routine 367—368
Libraries, bound controls, RSOpen routine 361—363
Libraries, error handler libraries 469—471
Libraries, graphs 398—402
Libraries, graphs, arguments for ShowGraph routine 406—409
Libraries, graphs, ShowGraph routine 403—404
Libraries, graphs, testing libraries 404—406
Libraries, ODBC 611—612
Library functions (input validation) 146—156
Library functions (input validation), CheckSize 152—153
Library functions (input validation), InRange 150—152
Library functions (input validation), IsConditional 154—156
Library functions (input validation), IsValid 153—154
Library functions (input validation), KeyNumbers 147—148
Library functions (input validation), KeyUpper 148—149
Library functions (input validation), KeyUpperNumber 149
LIKE function (SQL) 279—280
Limiting result sets, WHERE clause (SQL) 277—280
Line command, Format menu 199
Line command, Insert menu 198
Line graphs 391
Linking, online help to applications 713
Linking, tables, WHERE clause (SQL) 280—291
Links...command, Database menu 200
Links...command, Edit menu 196
List boxes, Form_Load event (listing 6.5) 140
ListField properties (data-bound list control) 418
Listings, 10.1. Coding the cmdDBEngine_Click event 305
Listings, 10.10. Coding the cmdExecute_Click event 325
Listings, 10.11. Coding the cmdMakeUDP_Click event 326—327
Listings, 10.12. Adding the TableDef button 329
Listings, 10.13. Coding the cmdCreateTable_Click event 331
Listings, 10.14. Coding the cmdModTable_Click event 332—333
Listings, 10.15. Coding the cmdAttach_Click event 334—335
Listings, 10.16. Coding the cmdFields_Click event 336—337
Listings, 10.17. Coding the cmdIndex_Click event 338—339
Listings, 10.18. Coding the cmdQuery_Click event 340—341
Listings, 10.19. Coding the cmdRelation_Click event 342—343
Listings, 10.2. Coding the cmdRepair_Click event 307
Listings, 10.3. Coding the cmdCompact_Click event 308—309
Listings, 10.4. Coding the cmdWorkspace_Click event 313
Listings, 10.5. Coding the cmdNewWrkSp_Click event 314—315
Listings, 10.6. Coding the cmdCreateDB_Click event 316
Listings, 10.7. Coding the cmdOpenDB_Click event 317—318
Listings, 10.8. Coding the cmdDBProps_Click event 320—321
Listings, 10.9. Coding the cmdRecordset_ Click event 323—324
Listings, 11.1. Coding the form- level variables 352
Listings, 11.10. Coding the RecLocate function 364
Listings, 11.11. Coding the RecRead function 366
Listings, 11.12. Coding the RecWrite function 367
Listings, 11.13. Coding the RecEnable function 368
Listings, 11.14. Coding the RecDelete function 369
Listings, 11.15. Coding the RecError routine 369—371
Listings, 11.16. Coding the BtnBarInit routine 372—373
Listings, 11.17. Coding the BtnBar Enable routine 374
Listings, 11.18. Coding the BtnBarProcess routine 375—378
Listings, 11.19. Coding the form- level variables 382
Listings, 11.2. Opening the database and a Dynaset 352
Listings, 11.20. Coding the StartProc routine 383
Listings, 11.21. Coding the Form_Load routine 383
Listings, 11.3. Coding the cmdMove events 353
Listings, 11.4. Coding the cmdSeek_Click event 354—355
Listings, 11.5. Coding the cmdFind_Click event 356—357
Listings, 11.6. Modifying the cmdFind_Click event 358
Listings, 11.7. Coding the global variables 361
Listings, 11.8. Coding the RSOpen function 362
Listings, 11.9. Coding the RecInit function 363—364
Listings, 12.1. Adding code to the cmdSales_Click event 392—393
Listings, 12.10. Adding code to the mnuViewBar_Click event 402
Listings, 12.11. Adding code to the mnuViewLine_Click event 402
Listings, 12.12. Adding code to the mnuViewArea_Click event 402
Listings, 12.13. Creating the ShowGraph function 403—404
Listings, 12.14. Adding code to the cmdRepSales_Click event 405
Listings, 12.15. Adding optional parameters to the ShowGraph function 406—408
Listings, 12.16. Adding the code to the mnGraphsRegion Sales_Click event 410
Listings, 12.17. Adding the code for the mnuGraphsMonth Sales_Click event 412
Listings, 12.18. Adding code to the mnuGraphsCust Sales_Click event 413
Listings, 12.2. Adding code to the CmdAutoSales_ Click event 394
Listings, 12.3. Adding code to the cmdQuickSales_Click event 395
Listings, 12.4. Adding code to the cmdTides_Click event 396
Listings, 12.5. Adding code to the cmsWrite_Click event 398
Listings, 12.6. Adding code to the Form_Resize event 400
Listings, 12.7. Adding code to the mnuFileSave_Click event 400—401
Listings, 12.8. Adding code to the mnuFileCopy_Click event 401
Listings, 12.9. Adding code to the mnuViewPie_Click event 402
Listings, 13.1. Code to monitor addition of new records to a data-bound grid 433
Listings, 13.2. Code to monitor for attempted data updates 434
Listings, 13.3. Code to track for record deletes 435
Listings, 13.4. Code to request confirmation on column updates 436
Listings, 13.5. Code to update the Subform with the Reposition event 442
Listings, 14.1. Writing a simple error handler 450
Listings, 14.10. Trapping media errors 467—468
Listings, 14.11. Coding the errHandler function 470
Listings, 14.12. Coding the errWriteLogFile routine 472
Listings, 14.13. Adding errWriteLogFile to the errHandler function 473
Listings, 14.14. Declaring global variables for the error handler 474
Listings, 14.15. Adding variables for the Module Trace option 475
Listings, 14.16. Coding the errProcStack routine 476—477
Listings, 14.17. Adding errProcStack to Command1_Click 477
Listings, 14.18. Adding errProcStack to NewSub 478
Listings, 14.19. Modifying errHandler to call errProcStack 478—479
Listings, 14.2. Creating cascading errors 452
Listings, 14.3. Calling a subroutine to create cascading error 452—453
Listings, 14.4. Using the Resume keyword 454
Listings, 14.5. Using the Resume Next keywords 456
Listings, 14.6. Using the Resume label keywords 457—458
Listings, 14.7. Using the End keyword 458—459
Listings, 14.8. Adding code to the cmdControl_Click event 460—461
Listings, 14.9. Adding code to the Form_Load event 466
Listings, 15.1. Modifying an SQL-VB script 498
Listings, 15.10. Adding a UNIQUE CONSTRAINT 512
Listings, 15.11. Defining a multicolumn UNIQUE CONSTRAINT 512—513
Listings, 15.12. Adding a PRIMARY KEY CONSTRAINT to the EmpsTable 514
Listings, 15.13. Adding the FOREIGN KEY...REFERENCES CONTRAINT 515
Listings, 15.14. Creating a foreign key relationship on unmatched field names 516—517
Listings, 15.15. Creating a multicolumn FOREIGN KEY CONSTRAINT 518
Listings, 15.16. Using ALTER TABLE to ADD and DROP constraints 519—520
Listings, 15.2. Creating the SQLVB02.SQV script 502
Listings, 15.3. Adding the PRIMARY KEY CONSTRAINT 502
Listings, 15.4. Using the ADD COLUMN clause 503
Listings, 15.5. Using the DROP COLUMN clause 504
Listings, 15.6. Using the DROP TABLE clause 505
Listings, 15.7. Testing the relationship SQL keywords 507
| Listings, 15.8. Testing the PRIMARY KEY CONSTRAINT 510
Listings, 15.9. Using CREATE INDEX to define the PRIMARY KEY 511
Listings, 16.1. Testing the INSERT INTO keyword 526
Listings, 16.10. Using GROUP BY and HAVING to summarize data 543
Listings, 16.11. Using the DELETE statement 545—546
Listings, 16.12. Using a complex WHERE clause with a DELETE statement 547
Listings, 16.13. Using JOIN to perform a multitable DELETE 548—550
Listings, 16.2. Handling Counter and blank fields in INSERT statements 527—528
Listings, 16.3 Using the INSERT INTO...FROM statement 529—530
Listings, 16.4. Adding the IN clause 531—533
Listings, 16.5. Sample code for record-oriented updates 535
Listings, 16.6. Using the UPDATE...SET statement 536
Listings, 16.7. Adding the WHERE clause to the UPDATE statement 538
Listings, 16.8. Testing Make Table queries 540
Listings, 16.9. Using the WHERE clause to limit Make Table queries 541—542
Listings, 17.1. Creating the Employees table 560
Listings, 17.10. Creating the DeptEqpSupIr table 574
Listings, 17.2. Creating the Skills table 561
Listings, 17.3. Creating the SkillMaster and EmpSkills tables 564
Listings, 17.4. Creating the Departments table 566
Listings, 17.5. Creating the new Employees table 567
Listings, 17.6. Creating the new EmpSkills table 567
Listings, 17.7. Creating the Training table 570
Listings, 17.8. Creating the Equipment and the Supplier tables 572
Listings, 17.9. Creating the EquipSupplier and DeptSupplier tables 573
Listings, 19.1. The ODBC API declarations 611—612
Listings, 19.10. Coding the ODBCStart function 619—620
Listings, 19.11. Coding the ODBCLoadCtl function 621—624
Listings, 19.12. Coding the ODBCGetFld function 628
Listings, 19.13. Coding the ODBCRowDel function 629
Listings, 19.14. Coding the ODBCRowAdd function 630—631
Listings, 19.15. Coding the ODBCRowUpdate function 631—632
Listings, 19.16. Coding the form- level variables 635—643
Listings, 19.17. Coding the Form_Load event 635
Listings, 19.18. Coding the Form_Unload event 636
Listings, 19.19. Coding the cmdExit_Click event 636
Listings, 19.2. The ODBC constant declarations 612
Listings, 19.20. Coding the lstODBC_Click event 637
Listings, 19.21. Coding the grdODBC_RowColChange event 637
Listings, 19.22. Coding the cmdODBC_Click event 637—638
Listings, 19.23. Coding the FixForm routine 639—640
Listings, 19.3. Adding the local variables to LIBODBC.BAS 613
Listings, 19.4. Coding the ODBCEnvironment function 613
Listings, 19.5. Coding the ODBCConnect function 614—615
Listings, 19.6. Coding the ODBCDisconnect function 615—616
Listings, 19.7. Coding the ODBCFreeHandle function 616
Listings, 19.8. Coding the ODBCErrorMsg function 617—618
Listings, 19.9. Coding the ODBCDataSet function 619
Listings, 20.1. Setting up the User Maintenance form 654—655
Listings, 20.10. Initializing form values 663
Listings, 20.11. Code for the OK button 664
Listings, 20.12. Code for the Cancel button 664
Listings, 20.13. Adding the usrLogin function to LIBUSER.BAS 664—665
Listings, 20.14. Coding the usrValid routine 666—667
Listings, 20.15. Adding the LogOut routine 667—668
Listings, 20.16. Modifying the Main routine to add the new User Login form 668
Listings, 20.17. Centering the User Access Rights form 675
Listings, 20.18. Setting up access levels and command buttons 675—676
Listings, 20.19. Populating the two data-bound grids with accLoadLists 676
Listings, 20.2. Disabling entry in the Text1_KeyPress event 656
Listings, 20.20. Creating the accAddObject routine 677—678
Listings, 20.21. Deleting an object with accDelObject 678
Listings, 20.22. Deleting all existing rights objects with accDelAll 679
Listings, 20.23. The accAddAll routine 680—681
Listings, 20.24. The accSetLevel routine 681
Listings, 20.25. Centering the new form 684
Listings, 20.26. Initializing radio buttons with the lblLevel control 684—685
Listings, 20.27. Coding the radio buttons in the Click event 685
Listings, 20.28. The mnuAccessSet User_Click event 686
Listings, 20.29. Adding the accGetSet function to LIBUSER.BAS 688—689
Listings, 20.3. Setting up the Print command 656
Listings, 20.30. Checking access rights for a secured object with accRights 689
Listings, 20.31. The usrRightsCheck Sub procedure 690
Listings, 20.32. Before the change in the Main procedure 691
Listings, 20.33. After modifying the Main procedure 691
Listings, 20.34. Adding the logInitFile routine to LIBUSER 693
Listings, 20.35. Recording the audit trail with the logWriteFile routine 694—695
Listings, 20.36. Tracking changes in each field with the kigChanged routine 696
Listings, 20.37. The modified Main routine for login/logout auditing 697
Listings, 20.4. Launching the Printer setup dialog 657
Listings, 20.5. Programming the Exit and OK buttons 657
Listings, 20.6. Global declarations for the LIBUSER.BAS project 657—658
Listings, 20.7. Opening the data set with the usrInit function 658
Listings, 20.8. Calling the User Maintenance form 659
Listings, 20.9. Centering a form 663
Listings, 4.1. Creating a Database object and a Dynaset object 73
Listings, 4.10. Declaration code for the TBSEEK01.VBP project 86
Listings, 4.11. Coding the Form_Load routine of TBSEEK01.VBP 86
Listings, 4.12. Coding the LoadList routine of TBSEEK01.VBP 86—87
Listings, 4.13. Coding the Seek routine for TBSEEK01.VBP 88
Listings, 4.14. Comparing Snapshots and Dynasets 90—92
Listings, 4.15. Listing Database objects 94—95
Listings, 4.2. Declaring database and data table variables 74
Listings, 4.3. Opening the database and creating the Dynaset 75
Listings, 4.4. Counting the records in a Dynaset 75—76
Listings, 4.5. Adding a new Dynaset object and string variable 76—77
Listings, 4.6. Using the Filter property to create a Dynaset 77—78
Listings, 4.7. Displaying the record count of the fdtered Dynaset 78
Listings, 4.8. Cloning a new Dynaset 79—80
Listings, 4.9. Coding the Command1_Click event for BKMARK01.VBP 81
Listings, 6.1. Limiting data entry in the Keypress event 134
Listings, 6.10. The KeyNumbers field level validation function 148
Listings, 6.11. The KeyUpper field level function to force uppercase letters 148
Listings, 6.12. The KeyUpperN umber function to force uppercase letters and pass control codes 149
Listings, 6.13. The InRange function to handle validation of numeric ranges 150
Listings, 6.14. Calling the InRange function from the cmdOK_Click event 151
Listings, 6.15. The CheckSize function to check field length 152
Listings, 6.16. The updated cmdOK_Click event that calls the CheckSize function 152—153
Listings, 6.17. Code for the IsValid function to check for required fields left blank or set to null 153
Listings, 6.18. The modified cmdOK_Click event to call the IsValid function 154
Listings, 6.19. The IsConditional function to check for required entry if a conditional field is completed 154—155
Listings, 6.2. The KeyPress event with control characters 134
Listings, 6.20. The modified cmdOK_Click event that calls the IsConditional function 155
Listings, 6.21. Adding data records 171
Listings, 6.22. Unloading the CompanyMaster form 171
Listings, 6.23. Finding data records 172
Listings, 6.24. Restoring the data controls 172
Listings, 6.25. Writing a record 172
Listings, 6.26. Deleting a record 172—173
Listings, 6.27. Updating the company logo 173
Listings, 6.28. Performing validation checks 174—175
Listings, 6.29. Calling validation routines when the Update button is pressed 176
Listings, 6.3. The KeyPress event to force letters to uppercase 135
Listings, 6.4. A single KeyPress event to check for valid entry and force uppercase 136
Listings, 6.5. The form load event to load a list box 140
Listings, 6.6. The form level validation routine to check for values in a range 142
Listings, 6.7. The form level validation routine to check the length of fields and a valid range of values 142—143
Listings, 6.8. The form level validation routine to check for required fields 144
Listings, 6.9. The form level conditional validation routine 145—146
Listings, A.1. A sample SQL script 738
Listings, A.10. Coding the SQLdbOpen routine 755
Listings, A.11. Coding the SQLdbClose routine 756
Listings, A.12. Coding the SQLdbMake routine 756—757
Listings, A.13. Coding the SQLDoCommand routine 758
Listings, A.14. Coding the ShowTable routine 759
Listings, A.15. Coding the LoadNotePadFile routine 760
Listings, A.16. Coding the ErrMsg routine 760
Listings, A.17. Coding the InitApp routine 761
Listings, A.2. Adding code to the Form_Load event 744
Listings, A.3. Adding code to the Form_Resize event 745
Listings, A.4. Adding the global variables 749
Listings, A.5. Coding the SQLMain routine 750
Listings, A.6. Coding the SQLFileOpen routine 750—751
Listings, A.7. Coding the SQLFileClose routine 751
Listings, A.8. Coding the SQLFileProcess routine 752—753
Listings, A.9. Coding the GetToken routine 755
Loading, graph control 389
Loading, SQL-VB Interpreter 495—496
LoadList() routine, TBSEEK01.VBP (listing 4.12) 86—87
LoadNotePadFile procedure (SQL-VB project) 759—760
|
|
|
| Ðåêëàìà |
|
|
|
|
|
Î ïðîåêòå