Home » Developer & Programmer » Forms » Query condition
Query condition [message #234694] Wed, 02 May 2007 22:54 Go to next message
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
Re: Query condition [message #234791 is a reply to message #234694] Thu, 03 May 2007 03:18 Go to previous messageGo to next message
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.
Re: Query condition [message #235034 is a reply to message #234791] Thu, 03 May 2007 16:21 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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).
Re: Query condition [message #236190 is a reply to message #234791] Wed, 09 May 2007 04:38 Go to previous message
niva2004
Messages: 15
Registered: October 2006
Location: Cochin
Junior Member
Thanks sameer....It works nicely
Previous Topic: FRM-40509 ORA-02292:
Next Topic: how can pass a parameter to function at run time in oracle 10g developer
Goto Forum:
  


Current Time: Sat Dec 03 21:56:57 CST 2016

Total time taken to generate the page: 0.09463 seconds