Yet again, how useless am I? I’m actually typing this entry on my phone, maybe if I use my phone I might manage to keep up-to-date more.
I’m currently off work with a stinking cold that shows no sign of disappearing soon. I’ve finished one assignment for College whilst I’ve been off, and I was trying to get on with my Advanced Databases one but I’ve had problems today.
I thought I’d managed to install Oracle 9i and Oracle Forms 6i and got them to talk to each other. So I set up a user, and started creating tables and constraints in SQL*/Plus. Then when I tried to connect using the user I set up using Forms Builder, I get an error message about invalid username and password. So then I log in to SQL*/Plus using scott/tiger run the scripts to set up the Db and constraints, then I log out of SQL*/Plus log in as scott/tiger in Forms Builder and discover that I can’t see the tables I just created only the example, default tables. I went backwards and forwards a few times (think 2 hours) but got nowhere, so I’ve uninstalled both of them and reinstalled Forms 6i. On the grounds that they’re obviously not seeing the same database.
Now I’m going to try just using SQL*/Plus 8, which Forms installed but first I need to reconfigure the listeners etc so that I can actually log in.
I spent all day yesterday completing an Assignment for my course using Access 2003, what a pain it is to use! I’ve used most of the other common elements of Microsoft Office on a fairly regular basis, but until I started this module I’d had no reason to try Access.
The Help files are awful, they tell you next to nothing about how to do stuff its all “Function X has failed to work because Gizmo Y is not Z, please make Y have Z before trying to use X” (ok that may be a bit of an exaggeration but you know what I mean). Generating Reports was a pain, there doesn’t seem to be a way of saving the Report in the format its generated in, every time you open what appears to be a saved Report it regenerates the contents on the fly wiping anything you’d tried to save.
Trying to make anything but the simplest of Reports is a nightmare, the formatting (lines etc) are awful working out whether the data you’re going to show is Left Aligned, Centered or Right Aligned isn’t obvious. Text Boxes and Labels which are LINKED aren’t aligned properly! It reminded me of all of the bad things about early versions of Windows and other systems like the Amiga, where simple things were hard to do, for god’s sake how hard is it to draw a horizontal line?
Anyway rant over, today I’ve got another asignment to do, this ones in C++ and I’m using Visual C++.net 2003 version which is an example of how to do something reasonably right (it’s a damn site more intuitive to use than Access).
Time to go, as I need to get cracking, its due in on Tuesday so it might be worth actually starting it.