OraFAQ Forum: Forms » Execution after process

Home » Developer & Programmer » Forms » Execution after process (window 8, Oracle form 11g)

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

Execution after process [message #634578]

Wed, 11 March 2015 10:13

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.

Report message to a moderator

Re: Execution after process [message #634581 is a reply to message #634578]

Wed, 11 March 2015 10:57

Littlefoot
Messages: 21807
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?

Report message to a moderator

Re: Execution after process [message #634609 is a reply to message #634578]

Thu, 12 March 2015 01:31

Nasir.azeem
Messages: 40
Registered: September 2014
Location: Karachi

Member

problem has been solved.

Report message to a moderator

Previous Topic:	Unable to run report from form button
Next Topic:	Export data into Excel Template

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 22:16:07 CDT 2024