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: 21592
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: Oracle Forms 10g and ORacle database 12C compatibility
Next Topic: Forms taking longer time to execute query / Fetch Data to another block
Goto Forum:
  


Current Time: Sat Sep 19 21:07:18 CDT 2020