I have a database with a field called ‘lastchanged’ which is a TIMESTAMP value. The contents of this field are automatically updated when the record is modified. I have included this field in a Table that is displayed to the user. When a user updates a record, I reload the table, and I can see that the contents of the record have been changed, but the timestamp value does not change. However, if I go into the database (mysql on the command line) the value of this field has been correctly modified. Also, if I stop and restart my program, then when I load the table the correct timestamp value is displayed.
The definition of the field is:
lastchanged timestamp not null default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
and it seems to be working just fine - but the table doesn’t want to reload the new values - can someone tell me how to force that? As I said, the other fields in the record that get modified by the user DO get re-displayed properly.
Thanks,
nbc