Hello,
I am connecting to a SQL sevrver 2005 using ADO. in VFP6 prg.
I need to set datetime field in a sql table back to NULL using rs.update.
I tried different ways but it still does not work.
I tried:
rs.Fields("discharge_date").Value=.NULL.
rs.Fields("discharge_date").Value=""
rs.Fields("discharge_date").Value={}
rs.Fields("discharge_date").Value=NULL
rs.Fields("discharge_date").Value="NULL"

None of above works. I am still not unable to remove the value of the datetime field....
Any idea?

Thanks,
Kam Lee
SUNY DMC