Last reply... I figured out the cause. I had a Regex to validate but there was
a second validation I forgot about with a DateTime object check causing the
issue - so blank was defaulting. I removed it and no issue.
Thanks!
Scott ValleryEcclesiastes 4:9-10
On Tuesday, February 5, 2019, 12:05:43 PM EST, Simon Slavin
<slav...@bigfraud.org> wrote:
On 5 Feb 2019, at 4:58pm, Shawn Wagner <shawnw.mob...@gmail.com> wrote:
> Reread the rules at the start of 3.1. TIME doesn't have any of the
> substrings used to indicate a particular other affinity, so it's treated as
> NUMERIC.
You're right. I somehow remembered the default as TEXT, not NUMERIC. I was
wrong. Thanks for the correction.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
