| To: | cdbi-talk [...] groups.kasei.com |
| From: | jason [...] multiply.org |
| Subject: | feature request for after_update trigger |
| Date: | Wed, 12 May 2004 20:43:55 +0100 (BST) |
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?