OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » pre-form

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

pre-form [message #281563]

Sun, 18 November 2007 06:55

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

Report message to a moderator

Re: pre-form [message #281564 is a reply to message #281563]

Sun, 18 November 2007 07:03

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||'''';

Report message to a moderator

Previous Topic:	Client_text_io
Next Topic:	form probem ora-06502

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 02:19:31 CST 2025