I am currently having trouble developing a before update trigger to set a
timestamp field in a record based

on values in other fields.

The question I need answered is

What is stored in new.Field if no change has been made to Field?

Is it null or is it the same as Old.Field?



My logic seems to break down when I assume that new.Field=old.Field
indicates that no change has been made to the

Field, and the possibility of Null in either new.Field or Old.Field seems to
complicate it more.



I am using the current release 1.5.3 of firebird.



Thanks

Graeme Edwards





[Non-text portions of this message have been removed]