Home » Developer & Programmer » Forms » Execution after process (window 8, Oracle form 11g)
Execution after process [message #634578] Wed, 11 March 2015 10:13 Go to next message
Nasir.azeem
Messages: 40
Registered: September 2014
Location: Karachi
Member
Dear Experts,

I am running a procedure on a button. i want after procedure execute query which record that is proceed now. i am using after completion procedure

set_block_property('POLICY_LATESTSET',DEFAULT_WHERE,'PPF_APPROVED=''N''' || ' AND PPB_PROPOSAL='''||:POLICY_LATESTSET.PPB_PROPOSAL||'''' );

do_key('execute_query');


but it is not working. how can it possible help me please.

Regard

Nasir Azeem.
Re: Execution after process [message #634581 is a reply to message #634578] Wed, 11 March 2015 10:57 Go to previous messageGo to next message
Littlefoot
Messages: 21580
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Create a variable. Compose DEFAULT_WHERE and put it into the variable. Display variable on the screen. Use its contents in SQL*Plus, in SELECT's WHERE clause. Does it return anything? If not data, does it return an error? If so, which one?

Because, saying "it is not working" doesn't help much. What does it mean?
Re: Execution after process [message #634609 is a reply to message #634578] Thu, 12 March 2015 01:31 Go to previous message
Nasir.azeem
Messages: 40
Registered: September 2014
Location: Karachi
Member
problem has been solved.
Previous Topic: Unable to run report from form button
Next Topic: Export data into Excel Template
Goto Forum:
  


Current Time: Sat Aug 15 10:00:03 CDT 2020