how to write a list trigger procesure

I don't understand why

When I change the status from requested to canceled, the tool bar comes up a message

frm-40200:field is protected against update

Yes

any ideas?

the too bar still saying "frm-40200:field is protected against update"

I add MESSAGE('end of when-list-changed',acknowledge); to the end of my code

....

  ELSIF (:media_request_info.status = 'REQUESTED') THEN
       MESSAGE('Are you sure you want to change the status?.');
     
   
 END IF;

MESSAGE('end of when-list-changed',acknowledge);

Are block properties - insert_allowed, update_allowed set to property_true, too ?

Yes, they set all true.

I don't see "on formslevel" trigger.
But I add on-error, on_message with
message(:system.trigger_item || ':' || error_text || message_text);pause;

When I change status from requested to canceled,

first it pop up the message "Please acknowledge", in the tool bar it shows

MEDIA_REQUEST_INFO.STATUS:Field is protected against update.Field is protected against update

When I remove message code instead putting "null;" into on-error and on-message, and change status from requested to canceled, I don't see any pup-up message and message in the tool bar.
So far the triggers for my media_request_info block are only on-error and on-message,
It seems I need key-commit, pre-insert, pre-update, pre-query, post-query... right?

I want the users can change the data for the media_request_info form and save it.

maybe I need an on-update trigger? Also, I have create LOVs and record group for status. Do I need to do that? So far, it's pop up correctly when I click on the button and open the media request info form.

please provide input/ideas, I need this very soon. Thanks

Henka:
I put your code in the beginning of when-list-changed trigger

It's still the same

first it pop up the message "Please acknowledge", in the tool bar it shows

MEDIA_REQUEST_INFO.STATUS:Field is protected against update.Field is protected against update

flow01:

I put
message(:system.trigger_item || ':' || error_text || message_text);pause;
to on_error trigger on the form level.

It's still the same as above


I see a pop-up the message "Please acknowledge"

The tool bar show "TRUE" and pop up "Please acknowledge"

Hi all,

I just find out something that may help you provide fix for me.

When I try to edit other fields such as ship_method, the tool bar comes up the following message

media_request_info.ship_method:cannot insert or update data in a view.cannot insert into or update data in a view

and pup-up a message "Please acknewledge". When I click OK, the tool bar displayed another message

fm-41045:Cannot find item:invalid ID

Yes, for block media_request_info's base table is a view.

How to fix this?

Did it show twice ?

Yes

add also
message(Get_Item_Property(:system.trigger_block,insert_allowed));
pause;
message(Get_Item_Property(:system.trigger_item,insert_allowed));
pause;

First the toolbar displayed fm-41045:Cannot find item:invalid ID and pop-up"Please acknowledge". after click OK, again fm-41045:Cannot find item:invalid ID and pop-up"Please acknowledge"


Check also for the property  "update if null"

Where is it? I don't find it

double-check the properties of item
MEDIA_REQUEST_INFO.STATUS
and of block MEDIA_REQUEST_INFO

check the item-property "Query Only"

status item-property "Query Only"=fasle

I increase point value to 150, since this Q becoming more difficult now

the view has multiple tables. form version 11.0.0

The users can change the data on the media_request_info form, not only the status field, but also they can update others fields such as ship_method...

I am trying 2) option. Here is what I put

create a new item_list : status_update as a non_database_item

--I created a new item status_update under media_request_block

don't display your old item_list (make it also non-updatable)

--I don't understand this point, I have status list item on the media_request_info block

in the post-query of the block make :status_update := :status

--I add a  post-query trigger under media_request_block and put the the following code in this trigger
--:status_update := :status



If the item-list is the only means of changing the status_update

--Which list item? status_update or status?

add an update-statement in your item_list_changed trigger


--I added the following code to the status item list_changed trigger in media_request_info


update xx_upgrade_input_details xuid
         set status = :status_update
          where inventory_item_id = :licensed_products.inventory_item_id;

I cannot created the form

Compiling POST-QUERY trigger on MEDIA_REQUEST_INFO block...
Compilation error on POST-QUERY trigger on MEDIA_REQUEST_INFO block:
PL/SQL ERROR 49 at line 1, column 19
bad bind variable 'status'
PL/SQL ERROR 103 at line 2, column 1
Encountered the symbol "END" when expecting one of the following:
 "." "(" "*" "%" "&" "=" "-" "+" ";" "<" "/" ">" "in" "mod"
    "not" "rem" "an exponent (**)" "<> or != or ~=" ">=" "<="
    <> "and" "or" "like" "between" "is null" "is not" "||"
    "indicator"
; was inserted before "END" to continue.


Any thing wrong I did above?

I am trying your option 2). But I still cannot create the form.

Compiling POST-QUERY trigger on MEDIA_REQUEST_INFO block...
Compilation error on POST-QUERY trigger on MEDIA_REQUEST_INFO block:
PL/SQL ERROR 303 at line 1, column 1
qualifier 'MEDIA_REQUEST_INFO' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored



 In the post-query under media_request_info block, I put the following statement

media_request_info.status_update := :media_request_info.status;

Should I need to define update_status?

I have


FRM-30351: Warning! No list elements defined for list item.
List STATUS_UPDATE

But I can create the form.

When I open the media_request_form, I don't see the data and the toolbar show up the error message fm-41045:Cannot find item:invalid ID

I have made something working now. I can save the changes whenever I made to the field. But, the list trigger still cannot function for what I want. When I change the list item from "in_progress" to "requested", it allows me to do that although it pops up message, but I can still save it. It shouldn't allow me to save it. In my when-list-changed trigger, I have the following code.

For example, when users change "in_progress" to something else like "requested", the message will be shown but also, the form should stop and cannot allow them to save.

To cancel a record, simply changed Requested to Cancelled. This is only allowed for records with a status of Requested. An error message will be given if attempted
for other statuses.

the status in "requested" changed to "in_progress" should be allowed

Please continue to help. Thanks

 
IF (:media_request_info.status = 'IN_PROGRESS') THEN
       MESSAGE('The request is in procgress status and you cannot change.');
       RAISE FORM_TRIGGER_FAILURE; 
 
  ELSIF (:media_request_info.status = 'CANCELED') THEN
       MESSAGE('The request has been canceled and you cannot change.');
       RAISE FORM_TRIGGER_FAILURE; 
 
  ELSIF (:media_request_info.status = 'REQUESTED') THEN
       MESSAGE('The request has been requested and you can only be changed to Canceled.');
       RAISE FORM_TRIGGER_FAILURE; 
   
 END IF;

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:

-- here you can disable save button

how to do?

I don't have a save button on the form. If I want to save a record, I just go to action->save from the toolbar.

Also, there is only one situation that the list item can be changed.
That is,
When user change list item from "requested" to "canceled", this is allowed. If "requested" to "in_procgress", this is not allowed. How to say that in the procedure?

any ideas? I need this solution ASAP.

Before I remove some items, everything seems working. After I remove inventory_item_id on the media_request_info block, the list status can change whatever I want but with the following message

frm-40815:variable GLOBAL.status does not exist

If I add back the item - inventory_item_id to the block, everything seems working. I don't understand why. I don't need inventory_item_id on the block.

Here is my when-list-changed trigger code

Under block media-request_info, I have the following triggers
on-update
key-commit
pre-text-item
on-lock
post-change

Before I remove inventory_item_id, everything seems working. But, after I remove it, it comes up that error message and the status list doesn't following what I want.
Why?
How to fix it?

IF (:global.status = 'IN_PROGRESS') THEN
       :media_request_info.status := :global.status;
       MESSAGE('The media request is in progress status and you cannot allow to change the status.');
        set_item_property ('media_request_info.status', ENABLED, PROPERTY_FALSE);
        RAISE FORM_TRIGGER_FAILURE; 
 
  ELSIF (:global.status = 'CANCELED') THEN
       :media_request_info.status := :global.status;
       MESSAGE('The request has been canceled and you cannot allow to change the status.');
       set_item_property ('media_request_info.status', ENABLED, PROPERTY_FALSE);
       RAISE FORM_TRIGGER_FAILURE; 
 
  ELSIF (:global.status = 'REQUESTED') THEN
   IF :media_request_info.status = 'IN_PROGRESS' THEN
      :media_request_info.status := :global.status;
       MESSAGE('The media has been requested and you can only allow to change to canceled status.');
    ELSE
      --media_request_status_changed; 
	MESSAGE('The media has been requested to cancel.');
    END IF;
   
 END IF;

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:

Hi, I put your code

Default_Value('REQUESTED', 'global.status'); in In a When-New-Form-Instance trigger

The list doesn't work.

After I put back the inventory_item_id to the Canvas, it works.

I don't know why?