Home » Developer & Programmer » Forms » pre - form trigger
pre - form trigger [message #287217] Tue, 11 December 2007 07:59 Go to next message
roni_a180
Messages: 45
Registered: October 2007
Member
i write this following code in pre-form trigger
but it is not work


DECLARE
   v_rec         recordgroup;
   vstatus       NUMBER;
   v_user        VARCHAR2(35);
   v_branch      NUMBER;
   QT            CHAR(1)      := '''';
   v_showalert   NUMBER;
BEGIN
   :SYSTEM.Message_Level    := 5;
   v_user                   := 'a';                        -- :global.username;
   -- select map_userid,map_userid from SECU_VERIFY_MAPPEDUSER 
   -- where map_verify_eventid =0125 and MAP_USER_BRID 
   -- = '||''''||v_branch||''''||' and setupuserid = '||''''||v_user||'''';

   -- v_rec := create_group_from_query('v_rec','select map_userid,map_userid 
   -- from SECU_VERIFY_MAPPEDUSER where map_verify_eventid =0125 and MAP_USER_BRID 
   -- = '||''''||v_branch||''''||'and setupuserid = '||''''||v_user||'''');
   v_rec                    :=
      CREATE_GROUP_FROM_QUERY
         ('v_rec'
        ,    'select map_userid from SECU_VERIFY_MAPPEDUSER '
          || 'where MAP_VERIFY_EVENTID=0125 and  map_user_brid in ' 
          || '(select webbranchid from WEBUSERINFO where userid in '
          || '(select id from userinfo  where  username ='
          || ''''
          || v_user
          || ''''
          || '))'
         );

   IF NOT ID_NULL(v_rec)
   THEN
      vstatus    := POPULATE_GROUP(v_rec);
      POPULATE_LIST('TRANSACTION.VERIFY', v_rec);
   END IF;
END;

[Updated on: Tue, 11 December 2007 08:44] by Moderator

Report message to a moderator

Re: pre - form trigger [message #287232 is a reply to message #287217] Tue, 11 December 2007 08:46 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
What are the symptoms? Errors? If so, share the error message with the group.

I've also added code tags and formatted your code a little bit so we can all read it properly. Do so yourself next time. For more tips I refer to the topic in the yellow bar (forum guide).

MHE
Re: pre - form trigger [message #288916 is a reply to message #287217] Wed, 19 December 2007 01:02 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Try running this in the 'when-new-form-instance' trigger.

David

[Updated on: Wed, 19 December 2007 01:04]

Report message to a moderator

Re: pre - form trigger [message #288917 is a reply to message #288916] Wed, 19 December 2007 01:04 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
I agree, David.

MHE
Previous Topic: Problem with FORMS 6i
Next Topic: A text_io problem: ORA-302000
Goto Forum:
  


Current Time: Tue Dec 06 00:26:07 CST 2016

Total time taken to generate the page: 0.10548 seconds