Populating item of one record of a multiple record display block

From: Karen Webster <kevkar_at_iafrica.com>
Date: Mon, 2 Aug 1999 19:20:24 +0200
Message-ID: <7o4ju7$2u7m$1@nnrp01.ops.uunet.co.za>

Hi,

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 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 Mon Aug 02 1999 - 12:20:24 CDT