> Hello firebird-support,
>
> I have 2 databases. The 1st database has a table that contains
> timestamp data type. This table doesn't have trigger or something
> else. It's just a table. Every update to this table, the field) that
> type is timestap) always update with the current date and time
> automatically.
> But the 2nd database (which has a table that contains timestamp
> data type too, but different structure) doesn't update the field
> with the current date and time automatically everytime update occurs.
> What's wrong with this table?
>
> --
> Best regards,
> Andi

if it's not what Adam says, then I would suspect that the queries of the
second database is supplying a value for the field in question, while the
qeries on the first database is not. Both table fields may have a default
NOW set but only the first db is getting that value since the field is
omitted from the query.
Alan