Not sure whether this is the right group, or whether I should use the
general Firebird group, but as I am using the type 4 JDBC driver...

I have a table which includes a timestamp field.

I start by reading the value using
SELECT timestamp_field FROM table

I have tried to update it using
UPDATE table SET .... WHERE timestamp_field=?
combined with setTimestamp(1,value_read_in_select)

The update count is zero and nothing gets changed...

I also tried changing this using an sql statement in IBconsole and it did
not work then either (but the records were set from java using new
Timestamp(System.currentTimeMillis()) as value.
--
Joachim Van der Auwera
CAB software, Nijlen
joachim@...