OraFAQ Forum: Forms » ** Refresh another running form from another form, how to?

Home » Developer & Programmer » Forms » ** Refresh another running form from another form, how to? (Developer 6i, Windows XP)

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

** Refresh another running form from another form, how to? [message #423254]

Wed, 23 September 2009 02:34

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

Report message to a moderator

Re: ** Refresh another running form from another form, how to? [message #423309 is a reply to message #423254]

Wed, 23 September 2009 05:30

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

Senior Member
Account Moderator

Perhaps you might create a timer and EXECUTE_QUERY whenever timer expires.

Report message to a moderator

Re: ** Refresh another running form from another form, how to? [message #423469 is a reply to message #423309]

Thu, 24 September 2009 09:27

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

Kevin Meade
Messages: 2103
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

Report message to a moderator

Re: ** Refresh another running form from another form, how to? [message #423521 is a reply to message #423512]

Fri, 25 September 2009 00:44

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

Report message to a moderator

Re: ** Refresh another running form from another form, how to? [message #629642 is a reply to message #423521]

Sat, 13 December 2014 09:38

abukhalil
Messages: 1
Registered: December 2014
Location: Riyadh

Junior Member

Where is the Comprehensive Example

Report message to a moderator

Re: ** Refresh another running form from another form, how to? [message #629644 is a reply to message #629642]

Sat, 13 December 2014 11:35

Michel Cadot
Messages: 68645
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

Kevin Meade
Messages: 2103
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

Report message to a moderator

Previous Topic:	Unable to sort on a non database column
Next Topic:	Result of one column will input to next column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 10:32:40 CDT 2024