PRG 240 - Class #10 Lecture

Finish Ch. 5 Lecture & Discussion

• As a class, execute and analyze the code for the Ch05ObjectModel project from the Student CD-ROM.
  
  
• Introduction to SQL (Structured Query Language)
  
  
  • SELECT - allows you to specify which fields will be returned
  • FROM - allows you to specify which tables will be used to get the fields specified in SELECT
  • WHERE - optional, allows you to specify criteria
    
    
  • Examples - see p. 219, note the use of single quotes, double quotes, brackets, and the ampersand
  • Another example -
    
    rsPatient.Open "SELECT * FROM Patient", conAVB, , , adCmdtable
    
    (compare to example from above)
    
    
• Review the Query Builder from Ch. 4 by doing Ch04SQLQuery on p. 181. Create the project by following the steps. Copy and paste the code from the CD-ROM to save time.
  
  
• As a class, write SQL statements that query a database
• As a class, write SQL statements that update a database
  
  
• Use the Data Form wizard to easily create ADO objects in code. See p. 230.
  

(if time) Begin Ch. 6 Lecture & Discussion

• Background lecture on classes, objects, properties, and methods.
  
  
• As a class, do Ch06CreateObject as described on pp. 255-259. To save time, copy & paste this code.
  
  
• Do Feedback 6.1 on p. 259
• Do Feedback 6.2 on p. 262
  
  
• (if time) Step through the project using the F8 key as directed on p. 262.
  
  
• As a class, continue the Ch06CreateObject example as described on p. 267. To save time, copy & paste this code.
  
  
• (if time) Continue the Ch06CreateObject example as described on pp. 269-277. Finish this for homework if we do not have time to create this in class. While I will not be requiring you to closely study the section called Errors on p. 278, you should read the material for exposure.
  

Ch. 4 VB Auto Center working session

• Review Ch. 4 VB Auto Center specs & spend the remaining time working on that assignment.
  
  

Homework Assignment:

• Review any notes and/or activities in the above lecture that were not covered in class.
• It is recommended but not required that you study and even write out answers to the Chapter 6 Review Questions #1-11 on p. 294. There may be a quiz on Ch. 6 at our next class.
• Read Ch. 8. (We will not be covering Ch. 7 this semester.)
• Work on Ch. 4 VB Auto Center which is due on 4/23. It is optional to allow the user to sort the customers. Handling possible program errors is optional as well. Submit the project saved in a labelled folder on floppy disk. Make sure that the floppy disk is labelled with your name and "Ch 4 VB Auto Center". Also, hand in the source code stapled together with your name clearly marked in the documentation.
• If you are finished with Ch. 4 VB Auto Center, begin Ch. 5 VB Auto Center #1 only on p. 248. That is, make your VB Auto Center project work with ADO object code rather than a Data Environment. This project will be due at our last class.

Copyright © 2001 Curtis Minich. All Rights Reserved.