File Handling and System IO task.

I have commented these questions on Rachael's blog, but just in case someone else reads this first and knows the answers ...

Hi Rachael.
Just a quick question about the "File Handling and System IO" task.
For Activity 8 we are asked to place five button controls on the interface (btnOpenFile, btnSaveFileAs, btnOpenLog, btnSaveLog and btnDeleteFile) but we are only given code to include for the first three. Is there some code missing from the assessment sheet or are those extra two buttons not required?
We are however given code for a button called btnClearTextbox which we have not yet added to the interface. Is this a new button or the code for one of the other buttons which we can just rename?
Hope this makes sense and that you are having a nice break.
Deb.

You learn something new everyday!

"Jackaroos (male workers) and Jillaroos (female workers) are station employees who undertake a range of activities on cattle and sheep stations."

Sadly, I knew all of the words in the Slang Words array apart from Jillaroo!!

Session 16

* For the first half of todays session we continued with the Chapter 11 project.
* Then we went over the relationships between the various classes in the project.

* A parent/child relationship exists between Student and OnCampusStudent.
* Student is the parent (or the base class) and OnCampusStudent is the child.
* OnCampusStudent inherits from Student.

* StudentCostsFile has an association only with Student and OnCampusStudent.

* In the Student class, the variables are declared with the keyword Protected.
* This means they can be seen by its subclasses.

* The chapter also talks about three tiers within the project:
1. The Presentation Tier: The interface.
2. The Persistence Tier: The data that you keep.
3. The Business Tier: Where all the main processing gets done.

Session 15

Today we worked through the Chapter 11 project - the Landelline College Registration Costs form. The whole thing was reasonably easy to do - however that doesn't mean I understood it! The two problems I had were 1. losing my completed interface when I went out for coffee, and 2. missing out the entire Else clause from the If statement on page 839 - very clever!

Session 14

Rachael gave us this session to work on the activity from yesterday seeing as a lot of people hadn't started it yet.

Session 13 Activity

Just finished the Database design and programming activity and am worried that I have done something wrong as it seemed pretty straight forward and only took half an hour to complete. And even then I created the form from scratch rather than saving a copy of the one we did in class, even if I did then pretty much replicate it. What have I missed??

Session 12

* Today we added some select clauses that contained filters (WHERE, LIKE) to our array, e.g.
"SELECT * FROM ApprovedTravelRequests WHERE Location = 'Richmond, VA'"
* The above query would return all records from the table where the Location was Richmond, VA.
* We can also run a "fuzzy" query that only looks for certain letters within the words:
1. "SELECT * FROM ApprovedTravelRequests WHERE Location LIKE 'R%'"
2. "SELECT * FROM ApprovedTravelRequests WHERE Location LIKE '%R'"
3. "SELECT * FROM ApprovedTravelRequests WHERE Location LIKE '%R%'"
* Example 1 would return all records where the location STARTS with an R, example 2 would return all records where the location ENDS with an R, example 3 would return all records where the location CONTAINS an R ANYWHERE in the name.
* The Percentage sign % is called a WILD CARD CHARACTER.
* We can also run queries using the relational operators >, <, >=, <=, <>, =, for example:
"SELECT * FROM ApprovedTravelRequests WHERE [Travel Cost] >= 1000"
* When using a numeric value there is no need to put it inside ''.
* We can also run queries using the logical operators AND, OR, for example:
"SELECT * FROM ApprovedTravelRequests WHERE [First Name] = 'Janet' And [Last Name] = 'Dunford'"
"SELECT * FROM ApprovedTravelRequests WHERE [First Name] = 'Janet' Or [Last Name] = 'Tirrell'"