feature request for after_update trigger

[prev] [thread] [next] [Date index for 2004/05/12]

Hi All.

I have a feature request regarding an after_update trigger.

Currently, it receives the object in question (post update), the list of discardecd columns and the number of affected rows.  It looks like this:
$VAR1 = [
          bless( {
                   'dependency_id' => '2',
                   '__Changed' => {
                                    'input_value' => 1
                                  },
                   'input_value' => 'asdf'
                 }, 'PackageName' ),
          'discard_columns',
          [
            'input_value'
          ]
        ];
It would be nice if you could get something like this instead:
$VAR1 = [
          bless( {
                   'dependency_id' => '2',
                   '__Changed' => {
                                    'input_value' => 1
                                  },
                   'input_value' => 'asdf'
                 }, 'PackageName' ),
          'discard_columns',
          [
            'input_value' => 'old_value_here'
          ]
        ];

In oracle, you have :old and :new automatic variables in certain triggers. I recently tried to do something with an after_update trigger, but I can no longer retrieve the pre-update value of the field I want to act on. Changing discard_columns to changed_columns as a list of field names and old and new values would be most helpful.

Thoughts?