OraFAQ Forum: Forms » EXECUTE_QUERY in pre-form trigger...urgent!!!!!!!

Home » Developer & Programmer » Forms » EXECUTE_QUERY in pre-form trigger...urgent!!!!!!!

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

EXECUTE_QUERY in pre-form trigger...urgent!!!!!!! [message #79514]

Wed, 19 June 2002 01:08

mani
Messages: 105
Registered: September 1999

Senior Member

hai.....
i need to use 'execute query' in pre-form trigger......

i have one data block in my form....whenever the form is loaded the data block should get values by using EXECUTE_QUERY......

i am getting Illegal restricted procedure error in PRE-FORM trigger.........

i need to get rid of this problem.....but the data block should be populated in the form load.....pls help me.....

Thanks in advance
mani

Report message to a moderator

Re: EXECUTE_QUERY in pre-form trigger...urgent!!!!!!! [message #79516 is a reply to message #79514]

Wed, 19 June 2002 01:20

Subhash
Messages: 105
Registered: October 2001

Senior Member

Try Execute_Trigger in the 'When-new-block-instance' trigger of the Block

Regards

Report message to a moderator

Re: EXECUTE_QUERY in pre-form trigger...urgent!!!!!!! [message #79519 is a reply to message #79514]

Wed, 19 June 2002 03:05

mani
Messages: 105
Registered: September 1999

Senior Member

hai subash....
thanks for ur reply......but here am disabling or enabling the block items according to some condition.....will it work?????i mean when the form is loaded according to the condition mentioned in the pre-form trigger the block should have fetched data and disabled or enabled according to the condition.....hope you got it...anyway i`ll try this.....

mani

Report message to a moderator

Re: EXECUTE_QUERY in pre-form trigger...urgent!!!!!!! [message #79521 is a reply to message #79514]

Wed, 19 June 2002 03:34

mani
Messages: 105
Registered: September 1999

Senior Member

Report message to a moderator

Re: EXECUTE_QUERY in pre-form trigger...urgent!!!!!!! [message #79554 is a reply to message #79514]

Fri, 21 June 2002 03:00

Anu
Messages: 82
Registered: May 2000

Member

Use create timer in when_new_form_instance
& run any restricted built_ins in when_timer_expired trigger.or use when_new_form_instance & use execute_query

Report message to a moderator

Previous Topic:	for loop inside block
Next Topic:	About forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 02 22:07:03 CDT 2025