A couple weeks have gone by now, so just a quick summary, and yes I am still trawling through the photos I’ve taken over the past little while to upload and I’ll be in front of the computer this weekend – doing assignment work – and so, WILL be uploading them.
So I’ve moved desks now at work, and all the developers (all 3 of us) are really cosy now in our really really warm room. I’ll grab a photo soon to put up here.
Long weekend – didn’t do too much there. It was filled up with friday – playing games, saturday – went to uni for some group work to make sure we were all on the same page before we go off and do our individual parts – hopefully having a final document which meshes really nicely – followed by games, sunday – lovely wedding, although was very VERY long. It was a great day for a wedding and we have some really nice photos, monday – Easter Show.
Simple of the girls
Father of the bride checking the Eels game (favourite team)
So for the first time, I turned up to the easter show EARLY. I’ve normally turned up in the final few days of the show after all the competitions and stock is gone and so its been a bit bland. This year, it was great! I guess I’ve missed out on a whole lot every other year since I finally had time to see quite a few things that I never knew about like the Horticultural pavilion and was able to see the woodchopping (womens) and also judging of a few of the animals – making a special mention to the Llamas.
Thought this one was kind of funny:
Womens woodchopping final:
A couple from the fireworks that night:
The rest of the week has really just revolved around a little Kai Taylor Sloane, my newest nephew! He is just adorable – I was a bit too young to appreciate my other niece and nephew when they were born. So I spent thursday afternoon NOT going to uni, and headed out to grab myself a video camera for my sister – Sony DCRSR45 which is a 30Gb HardDisk recorder. Its a great size and it saves on tapes and DVDs, but it will require a lot of HD space to store all the videos. I haven’t yet used it, but I’m sure I will soon.
Since then, its been the weekend, and mine has been spent at work, doing uni work. I was supposed to write some reports up yesterday, but found my databases subject a lot more interesting and so I started that. I’ve found out now that its not so hard and quite fun. So yesterday and today I’ve spent doing this assignment, and I would say I’m nearly done writing my procedures but still need to make a start on the documentation. One thing that has stumped me, has been my inability to run an update query with a variable inside the update statement. Now I was thinking it was very straight forward, and its something I might need to sleep on since I’m still not able to sort it out!:
i_average := 0;
if a_average.count > 0 then
for i_averageID in a_average.first..a_average.last
loop
i_average := i_average + a_average(i_averageID);
end loop;
i_average := i_average/a_average.count;
DBMS_OUTPUT.PUT_LINE(i_average);
a_average.trim(a_average.count);
end if;
update local_RM16 set volume = i_average;
But when I change i_average to 10, it will update everything to 10 – the query is not the proper query but simplified so I could make more sense of it.
EDIT: so it seems like the update statement is REALLY wrong. I did think about the type of update it was and I knew I would have to fix it later on, but didnt realise it would create me such problems so early on. It was stupidly overwritting the data and so it appeared as though nothing was happening when in fact it was doing just fine. All is well at the moment and assignment is nearly done!
Written by Milton Lai