why I cannot update a record in a table by when-button-pressed trigger?

How are you querying the record after the form update?  It's been years since I've messed with forms but I'm thinking it might be a simple commit issue.

nothing. All the code is attached above for the button.

Sorry but I'm a bit confused.  I get the code for the button but I don't understand how you are looking at the record after the button press.

After I press the button on the form, I query the record by TOAD and I don't see the record not changed. For example

select *
from xx_downloads xd
 where xd.download_id =90987

Also, after I press the button, I see the message

message('OK, this download has been inactivated.');

popped up.

>>There is no  commit; in your code.

That's what I was getting at.

Until you commit the update you will not be able to see it from another session.

yes, you are right. it's missing a commit statement.

Now there is still one more problem. After I hit the button, I don't see the change populated on the block xx_downloads_v, and I have to requery id to see the change.

I ever put the following code at the end

...
end;
 
        message('OK, this download has been inactivated.');

go_block('xx_downloads_v');
execute_query;


But, it doesn't work. After I hit the button,  the form's data becomes different and pick up another id's record.

How to fix it?

Sorry.  I've been away from forms for way to long.

I think ithat t is caused by the default_where property of your block. It seems that there are only active downloads.

I think that it is caused ... :)

I don't follow you.What do you mean "default_where property"? I check the property of block xx_downloads_v, there is no any where clause there.  Do you mean the view for block xx_downloads_v doesn't include inactive downloads?

After I added the following code


      :parameter.G_query_find := 'TRUE';
      app_find.find('XX_DOWNLOADS_V');
      :parameter.G_query_find := 'FALSE';

rather than

go_block (xx_downloads_v);
execute_query;

it seems working. But I don;t understand. Can you explain?

I have another related question. I just added 50 points for this question from 125. I want to display active and inactive for the front end form. So far it will display as A as active and I as Inactive. How do I format the output for this purpose. The following code I wrote and I put them under post-query trigger but it doesn't work. How to fix? and which trigger I should put into?


declare
    --v_ative varchar2(30);
    --v_inative varchar2(30);

    v_attrib varchar2(30);
begin

      --v_ative = 'Active';
      --v_inative ='Inactive';

      if :xx_downloads_v.download_status= 'A' then
            v_attrib := 'Active';
      elsif :xx_downloads_v.download_status= 'I' then
        v_attrib := 'Inactive';
      end if;
      
      --SET_ITEM_PROPERTY('xx_downloads_v.download_status',visual_attribute,v_attrib);
   
end;