OraFAQ Forum: Forms » How to receive user input in oracle form at run-time?

Home » Developer & Programmer » Forms » How to receive user input in oracle form at run-time? (Forms, 10g, Windows7)

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

How to receive user input in oracle form at run-time? [message #657510]

Fri, 11 November 2016 03:49

Sabe
Messages: 2
Registered: November 2016

Junior Member

I have a WHEN-BUTTON-PRESSED Trigger that process a sale transaction, inside the trigger there is a check that checks the sale transaction amount. If the amount is greater than 1000 the authorization code from the senior is needed. how will receive that authorization code while still inside the trigger. I tried to call a new canvas to receive the authorization code, but the WHEN-BUTTON-PRESSED trigger continues to execute.

Report message to a moderator

Re: How to receive user input in oracle form at run-time? [message #657521 is a reply to message #657510]

Sat, 12 November 2016 06:16

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

A new canvas won't do it; however, if you call another form (which accepts the authorization code), WBP trigger will wait until you return back from the called form and then continue its execution.

Report message to a moderator

Re: How to receive user input in oracle form at run-time? [message #657556 is a reply to message #657521]

Mon, 14 November 2016 02:54

Sabe
Messages: 2
Registered: November 2016

Junior Member

Thank you Littlefoot, It worked like a charm.

[Updated on: Mon, 14 November 2016 03:18]

Report message to a moderator

Previous Topic:	Oracle Forms 10g and ORacle database 12C compatibility
Next Topic:	Forms taking longer time to execute query / Fetch Data to another block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 06:01:08 CDT 2025