it is definitely possible.
how have you defined the data type in the CREATE statement ?
how did the data was inserted in the table initially ?
have you enabled the "use datatypes" option ?
dump the contents of the table with the "datatypes" disabled, so you see
raw data. are they really floating point values ?
remember, you can use the "show only" check box, to see the SQL that the
resolver will produce, without actually running it.
if you cannot figure it out, send me the db.
> -Original Message-
> From: Zibetti Paolo [mailto:[EMAIL PROTECTED]
> 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
> 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 records:0" and modifications are not written to the database.
> Is it possible that SQLiteExplorer is trying to update the
> record on the database using the date fields in a "where"
> clause but fails because of rounding errors in the floating
> point rapresentation of dates ?
> How can I work around this problem ?
>
> Thank you
> Bye
>
>
>
>
