Somebody gave me on this forum next decision:
dim cmd as OleDBCommand
cmd =conSessionID.createcommand()
cmd.commandtext="set null off"
cmd.ExecuteNonQuery()
your next code must be here without closing this connection
After that you can add empty records... But only one NO - your table have to have something like a primary index key...
>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.