Home » Developer & Programmer » Forms » ** Refresh another running form from another form, how to? (Developer 6i, Windows XP)
** Refresh another running form from another form, how to? [message #423254] Wed, 23 September 2009 02:34 Go to next message
hossain.dhaka
Messages: 7
Registered: September 2009
Location: Dhaka
Junior Member
Hi Experts,

Assume following scenario-
One from named 'fx' running in PC 'x'. Form 'fy' running in PC 'y'. I need , when user from PC 'y' will insert a new record in database/ or update a record using form 'fy' then running form 'fx' in PC 'x' will automatically show that new/ updated record.

Actually I need to display updated record in a running form, but the update will be done form anoter PC.

I am using Oracle 9i under XP with D2K form 6i

Thanks in advance
Hossain
Re: ** Refresh another running form from another form, how to? [message #423309 is a reply to message #423254] Wed, 23 September 2009 05:30 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps you might create a timer and EXECUTE_QUERY whenever timer expires.
Re: ** Refresh another running form from another form, how to? [message #423469 is a reply to message #423309] Thu, 24 September 2009 09:27 Go to previous messageGo to next message
hossain.dhaka
Messages: 7
Registered: September 2009
Location: Dhaka
Junior Member
Thanks for your response. Timer can solve if temporarily, it any event can do it then the problem can be solved permanently.

Hossain

[Updated on: Thu, 24 September 2009 09:27]

Report message to a moderator

Re: ** Refresh another running form from another form, how to? [message #423512 is a reply to message #423254] Thu, 24 September 2009 21:58 Go to previous messageGo to next message
Kevin Meade
Messages: 2098
Registered: December 1999
Location: Connecticut USA
Senior Member
Try database alerts (DBMS_ALERT). At this location they claim to offer a Comprehensive Example.

You should easily get your waiting form to display changed data this way.

Good luck, Kevin
Re: ** Refresh another running form from another form, how to? [message #423521 is a reply to message #423512] Fri, 25 September 2009 00:44 Go to previous messageGo to next message
hossain.dhaka
Messages: 7
Registered: September 2009
Location: Dhaka
Junior Member
Thanks a lot Kavin. It might solve my problem. I am trying using DBMS_ALERT.

Thanks Again.
Hossain
Re: ** Refresh another running form from another form, how to? [message #629642 is a reply to message #423521] Sat, 13 December 2014 09:38 Go to previous messageGo to next message
abukhalil
Messages: 1
Registered: December 2014
Location: Riyadh
Junior Member
Where is the Comprehensive Example
Re: ** Refresh another running form from another form, how to? [message #629644 is a reply to message #629642] Sat, 13 December 2014 11:35 Go to previous messageGo to next message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Sorry, broken link.
PM Kevin maybe he has another location.

[Updated on: Sat, 13 December 2014 11:36]

Report message to a moderator

Re: ** Refresh another running form from another form, how to? [message #629709 is a reply to message #423254] Mon, 15 December 2014 08:43 Go to previous message
Kevin Meade
Messages: 2098
Registered: December 1999
Location: Connecticut USA
Senior Member
The link is not mine. I found it years ago by doing a search on the web for DBMS_ALERT. I guess whereever it was hosted has taken it down.

No problem. You can search again yourself. Just look on the www for DBMS_ALERT.

good luck. Kevin
Previous Topic: Unable to sort on a non database column
Next Topic: Result of one column will input to next column
Goto Forum:
  


Current Time: Sat Oct 01 12:39:48 CDT 2016

Total time taken to generate the page: 0.10199 seconds