Forms 4.5 - flag record as updated
From: Karen Webster <kevkar_at_iafrica.com>
Date: Tue, 3 Aug 1999 06:01:17 +0200
Message-ID: <7o5pfr$5hl$1_at_nnrp01.ops.uunet.co.za>
Hi,
Date: Tue, 3 Aug 1999 06:01:17 +0200
Message-ID: <7o5pfr$5hl$1_at_nnrp01.ops.uunet.co.za>
Hi,
[Quoted] I have a master detail form and I'm trying to populate an indicator column on the detail block (multiple record display) when someone updates that record - if that person is assigned a specific role ie dr_project_team.
I tried using something like
if (dbms.role_enabled ......)
then
select 'P'
into :ds.ind_proj
from dual;
in a pre-update trigger but found that all the detail records were populated
with 'P', not just the one which had been changed by the user?
Any ideas? Received on Tue Aug 03 1999 - 06:01:17 CEST