Insert empty value in Date field

Mar 11, 2013 at 12:26 PM
Edited Mar 11, 2013 at 12:30 PM
Hi, first of all thank you for this great project. We were up and running in minutes.
We have a need to insert empty value into the NON-nullable Date field. So, we need something like: DateField = CTOD('').
Is there a way to do that using the provider or we simply have to run custom sql command to update all entries after our insert procedure?

Thank you,
Mar 12, 2013 at 5:52 PM
Sorry, but there isn't a way to insert an empty date value as part of the insert statement.