Home » Developer & Programmer » Forms » pre-form
pre-form [message #281563] Sun, 18 November 2007 06:55 Go to next message
roni_a180
Messages: 45
Registered: October 2007
Member
hi

i want to create a dynamic combo box. the following code working in sql statement. but not working in forms level

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_branch in global parameter and v_user is global parameter

but the following part is working

select map_userid,map_userid from SECU_VERIFY_MAPPEDUSER where map_verify_eventid =0125 and MAP_USER_BRID = '||v_branch);

can u help me anybody
Re: pre-form [message #281564 is a reply to message #281563] Sun, 18 November 2007 07:03 Go to previous message
mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

Try this

select map_userid,map_userid from SECU_VERIFY_MAPPEDUSER where map_verify_eventid =0125 and MAP_USER_BRID = '||''''||v_branch||''''||' and setupuserid = '||''''||v_user||'''';
Previous Topic: How to get Forms to Run on Client / Server
Next Topic: Form6I flicker on Dialog Box - Switching Sessions
Goto Forum:
  


Current Time: Sun Aug 20 12:13:26 CDT 2017

Total time taken to generate the page: 0.04745 seconds