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.