Student Menu. © Lesson 4. Printable layout. Links won't function in print.

Notes Section

Main Text

 

Module 1.0

 

Command Object.

 Allows for selecting or manipulating data from the database by excuting a command.

 

1. Execute Method - The Command Object's execute method has three optional parameters: 

objCommand.Execute RecordsAffected, Parameters, Options

2. CommandText Property -  Specifies what commands to execute.

3. ActiveConnection Property - Specifies what data store to use and can be a Connection Object or a connection string.

4. Selecting Data - A select command will return the data in a recordset.

 

 

Module 1.1

 

Structured Query Language (SQL).

A universal database programming language. Please search the Web for numerous SQL references and tutorials. SQL has four main key words.

 

1. SELECT - Returns a recordset object with data.

2. INSERT - Adds records to data store.

3. UPDATE - Updates parts of existing data within a record.

 

4. DELETE - Removes records from data store.

 

Module 1.2

 

Stored Procedures and Parameters.

A query which has been assigned a name and stored in a database.

Advantages include:

1. Speed because stored procedures are kept in a precompiled form in the database.

2. The stored procedure shorthand makes code more readable.

3. Stored procedures are reusable.

The Parameters Collections of the Command Object:

A parameter can pass a value to a stored procedure or receive an output parameter from a stored procedure. The CreateParameter method has five parameters.

Set objRS = objComm.CreateParameter (Name, Type, Direction, Size, Value)

 

Module 1.3

 

Record Object and Stream Object.

1. The Record Object represents non-database structures having records and fields.

2. The Stream Object represents binary data or plain text contained within a record.

 

Module 1.4

 

Exercise 4.

1.     Finish reading Chapter Fourteen, Advanced Data Handling Techniques, in the course textbook. Please read, outline and paraphrase the entire chapter. Work the Try It Out projects for data access with your own code if possible.

2.   Please define all the new vocabulary terms from the paragraphs in the textbook, from the textbook's glossary and from online resources.

3.   Discuss the correct answers to this week’s quiz (shown below) on the Week 4 Student Discussion Board.

4.   Try out the class project links which will not be graded.

 

Module 1.5

 

Quiz 4.

 

  1. Which is a property of the Command Object?
  2. SQL is?
  3. What is a stored procedure?
  4. Which is a method of the Record Object?
  5. Which are properties of the Stream Object?