![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Spent yesterday evening nomming teriyaki courtesy of the Wendling, shopping for snacks for future visitors, hoping I had an excuse not to go to Lambert House, and then going to Lambert House. The director had a random query to come up with a list of invitees for a particular activity, and the volunteer coordinator needed me to update income ranges. Yes, we have to collect data on how much youth, if on their own, or their parents earn.
Fun fact: you can do all kinds of gnarly multi-table operations (“joins”) inside one query against a real SQL engine. Microsoft Access’s subset (Ptui!) of SQL is more restrictive, but it appears to support named subqueries, which in many cases will get you where you want to go. I miss real SQL date handling, though.
The director has finally agreed with me that maybe getting off Access 2010 would be a good thing, and not even for the above reasons. It went out of support six years ago*, and the UI library that it comes with has bugs that'll never be fixed. Those bugs are what the director is responding to. I have a long list of my own reasons.
The director drove me home for the second time this week. Much appreciated, because that would have been two chilly waits for a bus otherwise.
*Ten years of support for a particular product isn't bad by industry standards.
Fun fact: you can do all kinds of gnarly multi-table operations (“joins”) inside one query against a real SQL engine. Microsoft Access’s subset (Ptui!) of SQL is more restrictive, but it appears to support named subqueries, which in many cases will get you where you want to go. I miss real SQL date handling, though.
The director has finally agreed with me that maybe getting off Access 2010 would be a good thing, and not even for the above reasons. It went out of support six years ago*, and the UI library that it comes with has bugs that'll never be fixed. Those bugs are what the director is responding to. I have a long list of my own reasons.
The director drove me home for the second time this week. Much appreciated, because that would have been two chilly waits for a bus otherwise.
*Ten years of support for a particular product isn't bad by industry standards.
