Subject UPDATE with timestamp
Author Joachim Van der Auwera
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