Re: [Q] Gupta & Oracle 7

From: Jimmy Cheong <eio_at_moe.ac.sg>
Date: 22 Dec 1994 04:48:42 GMT
Message-ID: <3db0fa$qrb_at_piaget.moe.ac.sg>


yuri_at_impar.aiva.lt wrote:
: îi!
: Working with GUPTA SQLWindows 5.0 and ORACLE 7.013 we found it difficult
: to realize on-line mode in our applications.
:
: Let's say, there are several users working on their clients' PCs with
: SQLWindows created applications; all of them use the same ORACLE database.
: If one of those users changes database, rest of them must immediately see
: result of this modification on their screens.
:
: So, as I understand, we are to write some ORACLE trigger to enforce
: server to send messages (containing information about changed item)
: to every clients' PC every time the DB has been modified.
:
: How can we do that ? Would you be so kind to send some information,
: example ?
:
:
 

: --
: Yuri Y. Zhuravel | A.Vivulskio str. 7
: Financial Consulting Consortium Impar | 2600 Vilnius, Lithuania
: System administrator | E-mail: yuri_at_impar.aiva.lt
: of | Tel.: (370 2) 262800,652700
: impar.aiva.lt | Fax.: (370 2) 262740

There is a simple way to implement this :-

Using Snapshots & trigger



Everytime a table is changed, a snapshot created will log this. (Refer to SQL Manual for the syntax.) U can program your updating of snapshot to be refresh on an hourly basis or whatsoever.

A trigger is then coded to ensure that once the snapshot receives new updates, it'll inform the client users about it. Or u can redirect all users to access to this snapshot view for most current change activities.

Cheers.  

--
===============================================================================
Jimmy CHEONG Chin Yeow				Education Data Centre
Systems Programmer				Ministry of Education
Telephone	:+65 4713949 (pager 2094375)	Kay Siang Road, S'pore (1024)	
Internet	:eio_at_moe.ac.sg               "Efficiency is <> Hard Work; 
Fax		:+65 4737513                  but = TIME MANAGEMENT" 
Received on Thu Dec 22 1994 - 05:48:42 CET

Original text of this message