|RE: [firebird-support] Date stamp entry
> Hello - newbie question ...if it's a field you will be inserting at some point then you need a trigger
> How to : generate automatic datestamp entry on each new record in
> firebird ?
to set NEW.FIELD1 = 'NOW'; or CURRENT_TIMESTAMP. Do this on the before
insert trigger of the table.
If the field is not going to be inserted you can just set it's default value
to 'NOW' or CURRENT_TIMESTAMP and this will be the same as the trigger
method but no code required.