I am trying to set a field to NULL, but am not having much joy. Using VB6
and ADO 2.6.
The adoRs.Open selects a row to update, using ForwardOnly cursor and
How do I set an int (SQL Defined) field to NULL.
I need to use this type of synatx for the update not an adoCommand Object:-
adoRs("MyIntValue").Value = adodb.datatypeenum.adEmpty
The line of code above, works but sets the value to zero, so any queries
doing "SELECT * FROM Table1 WHERE MyIntValue IS NULL" will fail.
I have tried VBs .Value = Empty , but this generates the following error:-
Error 3219 - Operation is not allowed in this context
Thanks in advance!