Re: Forms 4.5 - flag record as updated
Date: Tue, 03 Aug 1999 13:57:41 +0100
Message-ID: <37A6E745.15DE2132_at_preci-spark.co.uk>
Karen,
Forms help states that the pre-update trigger 'Fires during the Post and Commit Transactions process, before a row is updated. It fires once for each record that is marked for update.'
For all of your detail records to have a 'P' in them means that somehow each record within the block has been updated or at least Forms thinks it has.
Maybe you need to look at any post-query processing that you do?
I.e. if your post-query sets an indicator or populates a non database
item then the record would be marked as changed and not query causing
the pre-update trigger to fire for each reocrd..
If this is the case then simply enter this line after your post-query
processing:
set_record_property(get_block_property('block_name',current_record'),'block_name',
status, query_status);
Well it's an idea at least ;)
Regards,
Darren
Karen Webster wrote:
> 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 :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 - 14:57:41 CEST