RE: [sqlite] Using date fields in SQLiteExplorer

2005-09-19 Thread Cariotoglou Mike
ECTED] > Sent: Monday, September 19, 2005 1:07 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Using date fields in SQLiteExplorer > > Here is another question about dates and SQLiteExplorer (v 1.7). > I'm storing dates in the native Delphi format, i.e. as > floatin

[sqlite] Using date fields in SQLiteExplorer

2005-09-19 Thread Zibetti Paolo
Here is another question about dates and SQLiteExplorer (v 1.7). I'm storing dates in the native Delphi format, i.e. as floating point numbers ("dates as text" = FALSE). Whenever I try to update a record that contains such a date, SQLiteExplorer displays the message "unexpected count of affected re