Home » Developer & Programmer » Forms » FORMS
FORMS [message #80032] Sun, 04 August 2002 23:09 Go to next message
nazar
Messages: 5
Registered: August 2002
Junior Member
1. Can we set Forms to refresh the record itself, let say after every 30 seconds during runtime to see any changes to the record? If possible, how to do it in details.

2. How to set automatic Outlook/SMS alert message in Oracle Forms whenever any condition is violated? The purpose is to automatically generate sms/outlook messages to prompt support people for any error round the clock.
Re: FORMS [message #80034 is a reply to message #80032] Mon, 05 August 2002 00:08 Go to previous messageGo to next message
Subhash
Messages: 105
Registered: October 2001
Senior Member
1. Create a timer which expires in every 30 seconds.In the 'When_Timer_Expired' triger write code for clearing the block and fecthing the data again.

2. Use UTL_SMTP
Re: FORMS [message #80037 is a reply to message #80032] Mon, 05 August 2002 19:03 Go to previous message
nazar
Messages: 5
Registered: August 2002
Junior Member
Managed to do the timer but it keeps on going back to first record in database instead of currently viewed record everytime it refresh.

For the sms, what trigger to fire to enable sms to be sent automatically whenever the any condition is violated.
Previous Topic: Installation Developer 2000 and Oracle8
Next Topic: How to navigate between records???
Goto Forum:
  


Current Time: Thu Mar 28 23:51:50 CDT 2024