Re: Trigger question.

} } Spetc wrote: } > } > Suppose you have a table with a date last modified column (datetime year } > to second.) } > } > This column would be stamped with the current date and time whenever a row } > is inserted or modified in the table. } > } > This would ideally be done via inserts and update triggers. } > } > Do anyone know how to use a trigger to intercept the insert or update and } > set this value prior to the insert / update operation? } } Hi, } } The problem here is that a triggered action cannot act on the } table that triggered it. AFAIK, you have two options: My impression was that the trigger could not act on the COLUMNS which were updated, but that you could set another value within the table if it had not been updated by the trigger causing event. I no longer have my SPL manual so I can no longer verify this. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@boi.hp.com Currently on loan to PLD/PE _____________________________________________________________________________ If anything can go wrong, fix it. To hell with Murphy. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________