Re: [Q] Gupta & Oracle 7
Date: Mon, 19 Dec 1994 14:39:45 GMT
Message-ID: <D12BE9.IAH_at_lanier.com>
In article <199412161124.AA06730_at_impar.aiva.lt>, <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 ?
>
I'm sure someone will have an answer for this, but there is an alternative
that may work just as well, depending on your application. Instead of
telling the client explicitly when a change has been made, you can just
have the clients *assume* a change has been made and re-query the database
at preset time intervals. A small number of clients re-querying every five
seconds, for example, might not put an inordinate load on the system, and
would be simpler than an asynchronous signaling system. Not as elegant,
but it may serve your purpose.
Donald E. Vick (dvick_at_lanier.com, dvick_at_crl.com) Voice: (404) 493-2194 Fax: (404) 493-2399 Received on Mon Dec 19 1994 - 15:39:45 CET