OraFAQ Forum: Forms » how use enter query what writh in enter

Home » Developer & Programmer » Forms » how use enter query what writh in enter_query button

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

how use enter query what writh in enter_query button [message #159946]

Wed, 22 February 2006 05:56

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

hi master

i hae three text box dept block and other in emp block table such as
in dept block
deptno
dname
loc

i have three button

enter_query
execute_query
exit

if my user put 20 in dept.deptno and press then enter_query button
and press execute_query button

please give me idea what i write in enter_query button

thanking You

Aamir

Report message to a moderator

Re: how use enter query what writh in enter_query button [message #159953 is a reply to message #159946]

Wed, 22 February 2006 06:15

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Order by clause isn't correct in your case Smile

FIRST press "Enter query" button, THEN enter a desired value (20), and FINALLY press "Execute query" button.

Both buttons are part of the default toolbar in Oracle forms and, in my opinion, it is useless coding such operations manualy.

But, if you insist on this, "Enter query" button's WHEN-BUTTON-PRESSED trigger would have one statement: enter_query. "Execute query" button would be that simple too: execute_query.

Report message to a moderator

Previous Topic:	how to call an exe file from oracle forms 9i
Next Topic:	how call lov to other lov

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:49:40 CDT 2024