Subject | Indirect value |
---|---|
Author | Hans |
Post date | 2009-02-07T17:46:30Z |
Hi, my question
Is it possible, say in a after update trigger to retrieve
the value of a column 'Name' indirectly somewhat
alike
Suppose Old.Name contains 'Hans'
-----
declare variable ColName Varchar(8);
declare variable ColValue Varchar(255);
begin
ColName = 'Name';
ColValue = ['Old.' || ColName] ;
-----
The value of ColValue at this point = 'Hans'
Best Regards
Hans
Is it possible, say in a after update trigger to retrieve
the value of a column 'Name' indirectly somewhat
alike
Suppose Old.Name contains 'Hans'
-----
declare variable ColName Varchar(8);
declare variable ColValue Varchar(255);
begin
ColName = 'Name';
ColValue = ['Old.' || ColName] ;
-----
The value of ColValue at this point = 'Hans'
Best Regards
Hans