Passing Null value to date field

[Anon]

I am having trouble passing a null or empty value to a smalldatetime field in sql2k from visual foxpro 6. I want to pass the null value when I perform an update statement to a date field that the user either left blank or removed the date from the gui.

I have tried passing 'Null', '<NULL>', '', space(0). When passing the '' and space(0) sql2k stores 01/01/1900... Any suggestions?

Tom Swift

[bastien]

why not pass the same date back to it? just pull it out with the rest of the data and update it with the same value when the row is updated....

hth

bastien

[Anon]

The date that I want to pass is an 'empty date', a null value. When I pass the empty/null value from my form as a parameter (sql passthru statements), sql2k is storing 01/01/1900. So when my screen refreshes, instead of having an empty date on the gui, it returns 01/01/1900.. the default value. I could code the vfp end to empty the date field when date = 01/01/1900, but that would be pretty sloppy..