Home » Developer & Programmer » Forms » How to receive user input in oracle form at run-time? (Forms, 10g, Windows7)
How to receive user input in oracle form at run-time? [message #657510] Fri, 11 November 2016 03:49 Go to next message
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.
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 Go to previous messageGo to next message
Littlefoot
Messages: 21234
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.
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 Go to previous message
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: Global variable in menu module
Next Topic: Forms taking longer time to execute query / Fetch Data to another block
Goto Forum:
  


Current Time: Mon Nov 20 07:50:38 CST 2017

Total time taken to generate the page: 0.01607 seconds