OraFAQ Forum: Forms » Query condition

Home » Developer & Programmer » Forms » Query condition

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

Query condition [message #234694]

Wed, 02 May 2007 22:54

niva2004
Messages: 15
Registered: October 2006
Location: Cochin

Junior Member

Hi...
I am using developer2000 forms.My problem is that we press F7 key(Enter query mode) and give a condition for query like >5000
in the emp_no field and press F8.After this query we perform some updations and commit.Is it possible to again query the block based on the previous condition,(ie,emp_no >5000).
Regards
Nisha

Report message to a moderator

Re: Query condition [message #234791 is a reply to message #234694]

Thu, 03 May 2007 03:18

sameer_am2002
Messages: 129
Registered: September 2002

Senior Member

It is so simple. store your query condition in a global variable
through a system variable substr(:system.last_query , (instr(:system.last_query , 'WHERE')+6 ) in your post-select trigger and use this global variable again.

Report message to a moderator

Re: Query condition [message #235034 is a reply to message #234791]

Thu, 03 May 2007 16:21

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

Senior Member
Account Moderator

I'm not sure would double F7 do any good ... you know, press F7, enter query condition, press F8, do the calculation (as you already did), commit.

Now press F7 F7 and see will ">5000" appear or not. It *might*, but I'm not sure of it (and can't test it at the moment).

Report message to a moderator

Re: Query condition [message #236190 is a reply to message #234791]

Wed, 09 May 2007 04:38

niva2004
Messages: 15
Registered: October 2006
Location: Cochin

Junior Member

Thanks sameer....It works nicely

Report message to a moderator

Previous Topic:	FRM-40509 ORA-02292:
Next Topic:	how can pass a parameter to function at run time in oracle 10g developer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 21:30:38 CST 2025