>How do you update a fox table with an empty date from dotnet?
>
>Can you do it with parameters, or do you have to build up the insert string?
>
>

>OleDbCommand cmd = new OleDbCommand("UPDATE myTable SET myDate = ? WHERE id = ?",myConn);
>OleDbParameter p = cmd.Parameters.Add("?myDate",OleDbType.Date);
>//p.Value = //What should this be?
>

>or
>

>OleDbCommand cmd = new OleDbCommand("UPDATE myTable SET myDate = {} WHERE id = 1",myConn);
>

>
>I would rather use parameters if there is a way.

Would this work for you? (vb.net)

p.value=DBNull.Value

franco