Populate a list [message #609011] |
Fri, 28 February 2014 00:33 |
shahzaib_4vip@hotmail.com
Messages: 410 Registered: December 2008 Location: karachi
|
Senior Member |
|
|
Dear All,
I Have 2 Block A & B
A Block contain Party_code and Party_name
B Block contain Party_Name
i need list item show in block b.item_name so i create a procedure
PROCEDURE PARTY(p_ListName in number, p_SrcBox in number) IS
v_Rg2 RecordGroup;
BEGIN
v_RG2 := Find_Group('party');
END;
And Trigger in when_new_form_instance
DECLARE
v_rg NUMBER;
v_GrpID RECORDGROUP;
BEGIN
v_GrpID := CREATE_GROUP_FROM_QUERY('party', 'SELECT party_name, TO_CHAR(party_name) party_name FROM a ORDER BY 1');
v_rg := POPULATE_GROUP(v_GrpID);
IF v_rg = 0 THEN
POPULATE_LIST('B.party_name', v_GrpID);
END IF;
END;
Its working fine
But i want to refresh Block B.party_name when i create new party_name in Block a
Regards
Shahzaib Ismail
[EDITED by LF: removed superfluous empty lines]
[Updated on: Fri, 28 February 2014 00:42] by Moderator Report message to a moderator
|
|
|
|
|
|