OraFAQ Forum: Forms » Issues regarding post-text-item

Home » Developer & Programmer » Forms » Issues regarding post-text-item

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

Issues regarding post-text-item [message #158975]

Wed, 15 February 2006 05:18

kritikverma
Messages: 22
Registered: January 2006
Location: Jamshedpur, India

Junior Member

Hi,
I am using oracle forms 6i. A procedure is called in key-next-item in each item. There are total 3 blocks- control, cost and taxes. The last two blocks are detail blocks. A procedure is called at key-next-item which is calculating some values and then transfering the control to the next navigable item. Now if the user uses the mouse this trigger is not fired. If I use the post-text-item trigger, a non-oracle exception is raise and the values are not calculated. Please help.. Immediate solution would be highly appreciated..

Report message to a moderator

Re: Issues regarding post-text-item [message #158981 is a reply to message #158975]

Wed, 15 February 2006 05:30

vban2000
Messages: 207
Registered: March 2005

Senior Member

Hi

what about when-validate-item?

regards
AnDy

Report message to a moderator

Re: Issues regarding post-text-item [message #158986 is a reply to message #158975]

Wed, 15 February 2006 05:40

kritikverma
Messages: 22
Registered: January 2006
Location: Jamshedpur, India

Junior Member

same issue.... as post-text-item

Report message to a moderator

Re: Issues regarding post-text-item [message #158989 is a reply to message #158986]

Wed, 15 February 2006 06:07

Maaher
Messages: 7065
Registered: December 2001

Senior Member

"a non-oracle error message"? Kind of vague. do you care to elaborate?

You could try the when-mouse-leave trigger (not sure about this though, it comes from memory)

MHE

Report message to a moderator

Re: Issues regarding post-text-item [message #159053 is a reply to message #158989]

Wed, 15 February 2006 18:41

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Yea ... tell use the message and show us the code.

David

Report message to a moderator

Re: Issues regarding post-text-item [message #159113 is a reply to message #159053]

Thu, 16 February 2006 04:47

ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai

Member

hi

may be you are using restricted builtin in post-text-item or in when validate item.

as u are previously trying this code in key-next-item
u must be using next_item builtin in that trigger, which is restricted builtin. try to avode that.

or may be u are using
raise form_trigger_failure;

exception
when others then
message(sqlerrm(sqlcode));message(sqlerrm(sqlcode));

and

hope this will work for u

Report message to a moderator

Re: Issues regarding post-text-item [message #159193 is a reply to message #158975]

Thu, 16 February 2006 11:19

RJ.Zijlstra
Messages: 104
Registered: December 2005
Location: Netherlands - IJmuiden

Senior Member

Impossible to answer:

Firstly,
If you use the key-next-item trigger, you get an error.
Ok, WHAT error? If I know this I might be able to help, otherwise I can point you to some nice URL's.

Secondly,
A when-validate-item trigger ALWAYS fires, so your issue has nothing to do with what kind of trigger you used, but again: WHAT error?

HTH,

Regards

Rob Zijlstra

Report message to a moderator

Previous Topic:	Trapping Oracle Error in Forms overriding Forms Error
Next Topic:	passing set of values to report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:35:38 CDT 2024