>>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.
>>
>
>Does NVL() work in this case? I don't know if the ODBC driver for Access will interpret that properly or not.
It might... it's just that SET NULL works for me and I don't fancy NVL()-ing 50 columns just for test purposes ;-)
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up