I would appreciate others opinions on whether to put a date object in a SQLite date field or just use a string date in a VARCHAR field and convert it when you need to use it as a date.
Seems it would save an awful lot of nil exception handling when reading the records into textedit fields…
I use the Xojo date object as a property in a class, so I have to do nil object checking before attempting to use it for populating my listbox with data. Some fields in my DB may or may not have date data so therefore checking that the date object is not nil is always good programming practice.
Been there done that. I hate Nil Object Exceptions!!