| when-window-activated [message #648195] |
Thu, 18 February 2016 07:26  |
 |
aguilo_fl
Messages: 4
Registered: February 2016
Location: Palma, spain
|
Junior Member |
|
|
Good morning,
Here is my issue:
Form A (master-detail)calls Form B passing a selected row. Forms B calls a PL/SQL DD.BB. package that creates a dublicate of the record selected from FORM A, modifying the name and creating a new pk. The duplicate pkg functions correctly. I created a global variable that holds the value of the PK that I just created.
WHEN-BUTTON-PRESSED in Form B calls the package that creates the new rows and exits finding the focus back to Form A.
In Form A, I have a WHEN-WINDOW-ACTIVATED event where I would like to visualize the row that I have just inserted.
Here is what I have in that trigger:
BEGIN
if :GLOBAL.GRUPCOA is not null then
Go_block('GRUQST');
clear_block(no_validate);
:GRUQST.COA := :GLOBAL.GRUPCOA;
execute_query('no_validate');
end if;
END;
This gives me a FRM-1086 error. "It was never stablished a recording point for F_1.." (This message was translated so is probably not accurate)
I have tried many other ways of executing the query giving the value held in the global value without any success. I have tested successfully the value in it.
EXPECTED RESULT: I would like to display the record with the primary key that I am passing.
Please help.
Joan Pere
[Updated on: Fri, 19 February 2016 01:21] Report message to a moderator |
|
|
|
|
|
|
|
| Re: when-window-activated [message #648240 is a reply to message #648235] |
Fri, 19 February 2016 02:47  |
|
aguilo_fl
Messages: 4
Registered: February 2016
Location: Palma, spain
|
Junior Member |
|
|
Added the call_form in the WBP trigger and the second part of the code in the WWA trigger:
<if :global.grupcoa is not null then
set_block_property('block_name', onetime_where, 'coa = ' || :global.grupcoa);
go_block('gruqst');
execute_query;
end if;>
THe result is that I open a second instance of Form A but it doesn´t execute the query.
[Updated on: Fri, 19 February 2016 02:49] Report message to a moderator |
|
|
|
|
|
|
|
| Re: when-window-activated [message #648356 is a reply to message #648245] |
Mon, 22 February 2016 03:04 |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
|
You seem to be missing the point. All this code needs to go in a WBP trigger in form A. That's the form that contains the block that needs to be re-queried after the new record is added, so you're setting properties of a block in the same form as the trigger.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
