>>OK, you asked for it :)
>
>Well, I guess I deserved that after dumping my network info on you when I had the LOCALHOST problem.
>
>Since there's no join, have you confirmed that there's no record in the original data where a null has appeared in the Teacher field?

Well, imagine that. The scoundrels had the NERVE to change their app to accept NULLs without telling ME!

So, the question now becomes, how to get RV columns to accept NULLs? I couldn't find a way to do it for individual columns via DBSETPROP(), CURSORSETPROP() etc. but fortunately SET NULL ON seems to work globally which is good enough in my case.

Thanks for pointing out the obvious!