I just ran into something strange over the weekend and I’m trying to figure out what caused it.
A few years ago I wrote an application that performed in SQL lookup and imported data into Notes. This has been working fine ever since - until just recently. So I was investigating and I found that I was initializing query.SQL = “”, and then I was doing a series of query.SQL = query.SQL + " " + statements.
It seems that all of a sudden a blank query.SQL is returning Ø (the empty set character if I remember my set theory). All of the SQL that was build by the code started with that character. The server was recently upgraded from 6.5.x to 7.0.3FP1. I don’t know if that coincided with the application breaking or not, but both things occurred within the past month.
So I fixed my code and it is working correctly now, but I was just curious if anyone else had noticed anything like this. I have done a lot of ODBC applications over the years for a number of customers, and I’m concerned that a number of them may break when their servers are upgraded (assuming that is what caused the problem).