> It seems as though SQLite is returning an empty string instead of None. > Does the date column in the database allow null values? If not, it looks like > it is storing an empty string for the value.
It seems this is the problem. Whenever I manually add a record in the database and leave the date column as NULL, I can access the "Available Keys", but as soon as I then choose a date I get the following error: ERROR - !!! Data Type Mismatch: table=Geskiedenis; field=Datum. Expecting: <type 'unicode'>; got: <type 'datetime.date'> Not sure where to go from here. Any advice? > It's very strange because for me, SQLite returns date: 0001-01-01 value for > new blank date fields. > What is your environment, Dewald? > Can you check if setting default value for your field to datetime.date.today > helps? Whenever I add a new record in dabo all new blank fields are empty strings. Not 100% sure what you meant with environment but I take it you are asking what I use to create and edit my SQlite databases? I'm using the Firefox extension SQLite Manager. As for setting the default value to datetime.date.today it made no differance to the error. Thanks a lot for the help so far. Regards Dewald _______________________________________________ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/48fa854c-0126-4af7-a852-b591d2c2c...@gmail.com
