How to Null a date in Sql Fivewin/Harbour

[byron.hopp]

Does anybody know how to save a null value back to a ADO recordset in a fivewin app.

oRs:Fields("MyDateTime"):Value := null //does not work

oConn:Execute( "update MyTable set MyDateTime=null where keyno=123" )

The sql command works but because I am using it inside a column browse there is a lot of work related to re-syncing the recordset and re-displaying within the browse.

Byron ...

[nageswaragunupudi]

oRs:Fields("AnyField"):Value := AdoNull() // works for any field type, if the field is nullable.
This works in all cases.

AdoNull() is FWH function.

For DateTime fields assigning NIL or CTOD("") also may work in many cases.

[Armando]

byron.hopp

Try with NIL instead NULL value

oRs:Fields("MyDateTime"):Value := NIL

Obviously, the field must be defined for accept null value

Regards

[Rick Lipkin]

As Rao mentions .. ctod("") seems to work for both Ms Access and MS Sql Server.

Rick Lipkin