The use of triggers in VFP is sometimes limited by the nature of how they cannot be coded to change the base record or else the trigger fires itself. This means that features like timestamps and revision number incrementing need to be handled in other ways.

My question is whether this is the traditional approach of most back ends that support triggers? Do any of the major players like SQL Server, Oracle or DB2 offer any options? [For example, something like a NORECURSE clause in a specific trigger.]

TIA,

-- Randy