How can I use the ADO Recordset's Update method to set a field to NULL? It's not a huge problem for string data types (I've been cheating and setting it to ''); but datetimes don't like that.
RS.Fields(FieldName).Value = ???
I've played with this on a field of type char(30) so I can see whatever gets used, and I've noticed that vbNull sets it to 1 and "null"/"NULL"/"<NULL>" sets it to the string "null"/"NULL"/"<NULL>" respectively. I'm using an ODBC connection to a SQL Server 7.0 database. I know that Ctl 0 (zero) will put in a null when I'm in SQL Server's Enterprise Manager, but I don't know if that'll help here (I can't find any reference to using--not detecting--the CTRL character).
Thanks in advance. =)