How to set Oracle date to null with ODBC?
Posted on 2002-07-05
Does anyone know how to set an Oracle date field to null using ODBC?
My code statement is the following:
rs.Fields("BillingDate") = IIf(IsNull(Me.txtBillingDate), Null, Trim(Me.txtBillingDate))
I get an error everytime it gets executed. The Errors collection returns that there was a data type mismatch. I have read articles that say that you can't assign an Oracle date the null value using ODBC. However, I have some older code examples where I was able to do this. Not sure why it isn't working now.
I don't want to have to use SQLPassThrough queries (Insert, Update statements) because of the time involved.