Hello,
I recently set a date field and a time field in my database to "Required:Yes" as I dont want to accept records without these values.
However when I try to insert using a prepared statement I am getting a Null Constraint Violation - even though there is a valid date/time.
Of course if I turn off the Required:Yes then the data goes in successfully (further proof that I am not trying to insert null.)
I can post a code snippet if required.
Cheers
Al
Yes, please provide an MCVE and confirm that you are using UCanAccess 4.0.1. I just did a simple test and it worked fine for me.
Log in to post a comment.
Hello,
I recently set a date field and a time field in my database to "Required:Yes" as I dont want to accept records without these values.
However when I try to insert using a prepared statement I am getting a Null Constraint Violation - even though there is a valid date/time.
Of course if I turn off the Required:Yes then the data goes in successfully (further proof that I am not trying to insert null.)
I can post a code snippet if required.
Cheers
Al
Yes, please provide an MCVE and confirm that you are using UCanAccess 4.0.1. I just did a simple test and it worked fine for me.