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: Client_text_io
Next Topic: form probem ora-06502
Goto Forum:
  


Current Time: Wed Dec 07 07:04:27 CST 2016

Total time taken to generate the page: 0.15457 seconds