The update returns "no records updated" . I suppose that the
RowsAffected was zero. We are using a TIBQuery with a TIBUpdateSQL.

The date value in the db and the value retreived by the
TIBQuery/TClientDataset must be different. The strange thing it that
it's working fine in W2k, XP but not for XP with Virtual PC

Pascal

> I use a timestamp as the key for one table. And trim the seconds to the
> nearest second. Because the conversion from time back to the fractional
> representation can give a different result.
> Is it possible you are not matching the converted dates, so that the
> records can't be found?
> Whats the error exactly - I've 5 years worth of data built using it ;)
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services