>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
Is the discharge_date field set to allow nulls in the SQL table?
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________