Null or Not Null
That is the question…
I am working on an old Visual Basic project. It is not my own, it’s just an existing project in which I have to make some changes. There’s an existing database connection and in one of “my” functions, I have run a query, and created a recordset (rs). In a loop, I am iterating through the records with a bit of code like this:
If Not IsNull(rs!X) Then
strX = rs!X
Else
strX = ""
End If
or, if you like
strX = IIf(IsNull(rs!X), "", rs!X)
Somehow, I get an error, “Invalid use of Null”, on the second line! So, rs!X is Null on the second line, but it wasn’t on the first line, or else the code would never have come to the second line! How is this possible?!?
A bit quiet lately
It’s been a bit quiet here, lately. On my weblog, that is.
I (we) have been very busy with work, with our search for a new house, my parents moving, and with Marijn, of course.
Anyway, just the other day, I found out that since my weblog has been moved to WordPress, all internal links on my weblog are broken. All links still point to cpbotha.net. I plan to fix them all, but please be patient with me.
WordPress
Hello world and welcome at my all new and shiny weblog.
As you can see, my weblog has been moved to WordPress.com. If you haven’t done so already, please update your link or bookmark to bvrolijk.net.
I have used the import function of WordPress to copy all of my old (Movable Type) weblog entries to this new system. I hope the conversion went all right, but if you see anything strange, please let me know.
Many thanks to Charl for hosting my weblog these past four-and-a-half years and for his help in the conversion.
Marijn Ruben
Last Tuesday, October 2nd, at about 9pm, Irene gave birth to a little boy: Marijn Ruben. We are very proud and happy to be the parents of this tiny new human being. He is a wonderful, sweet little baby.
Feel free to check out the first pictures on “his own website”!
Photos… lots and lots of them
In the past months, we have been very busy sticking all our photos into albums. No, not digitally, but the old-fashioned, analog ones, you know – on paper!
I had quite a backlog of photos, some even 10 years old. We had all these photos, on a big pile, in what is now the baby room. So when we started clearing out this room a few months ago, we decided that we needed to get rid of this pile. So we spent lots of evenings and complete days sorting out the photos and putting them in the albums. We even took a bunch of them on our last holiday!
Well, yesterday evening we finally stuck the last of our pictures (of that same holiday) into our latest album, so we’re finished… for now, of course…
A rough estimate:
- 12 photo books and albums
- 820 pages
- 2300 photos
- 9000 adhesive photo corners
Lightning
At the end of our holiday, last week, we had two nights with heavy rain and thunderstorms. Secretly, I had hoped for that to happen, because I wanted to try out my new camera (and toys)!
This is the result:
Champoussin
We arrived home from our two-week holiday in Champoussin, Switzerland, yesterday evening.
Why are holidays always too short?
Champoussin is a little village near Val-d’Illiez within the skiing area of Portes du Soleil.
We didn’t do any skiing of course, but for walking the area is very nice as well. We made some beautiful tours of three to four hours, almost every day. The weather was perfect, except for the first two days, and sometimes even a bit too warm.
The two (and-a-half) of us stayed in a luxurious 6-person appartment with two bathrooms, three toilets and three bedrooms! We had a magnificent view on the Dents du Midi, which we enjoyed from our balcony during breakfast and dinner (and in-between):
dr.
As of yesterday afternoon, about 16:15, I can put these two letters in front of my name! Almost six years of work… finally finished now.
PhD thesis has arrived
Today, a bunch of boxes were delivered at the TU Delft for me. My PhD thesis has arrived! Finally! Another giant leap in the whole PhD process. Only one big hurdle still to take: the defence on June 12th.
See my publications for a pdf version of the thesis.
Search
Categories
- Computing (64)
- Funny (38)
- Interesting (11)
- Leisure (38)
- Movies (12)
- Personal (74)
- Photography (10)
