Re: [Q] Gupta & Oracle 7
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