pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedMS Access 2K Inform User on Record changes
2+ messages / 2 participants
[nested] [flat]
* MS Access 2K Inform User on Record changes
@ 2002-07-05 00:51 Stavros Karposilos <apcl79@dsl.pipex.com>
2002-07-05 16:10 ` Re: [INTERFACES] MS Access 2K Inform User on Record changes Leland F. Jackson, CPA <smvfp@mail.smvfp.com>
0 siblings, 1 reply; 2+ messages in thread
From: Stavros Karposilos @ 2002-07-05 00:51 UTC (permalink / raw)
To: pgsql-interfaces
I have been very troubled the last days trying various ways to notify the frontend MS Access 2K Client when a table on the Backend has changed.
All my attempts have resulted to a failure.
I realise now that the Notify/Listen solution is not going to work. I also tried to create an external C routine, callable by Trigger, which was using a TCP/IP socket to connect to each client but I didn't manage to convince it to work without crashing.
I would greatly appreciate a working example, or a point to a solution of whatever form.
I am using PostgreSQL 7.2 running on RedHat Linux 7 networked with 8 clients running Win9x and MSAccess2K on a plain 10MBps Ethernet Network.
Thanks in advance, Stavros
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] MS Access 2K Inform User on Record changes
2002-07-05 00:51 MS Access 2K Inform User on Record changes Stavros Karposilos <apcl79@dsl.pipex.com>
@ 2002-07-05 16:10 ` Leland F. Jackson, CPA <smvfp@mail.smvfp.com>
0 siblings, 0 replies; 2+ messages in thread
From: Leland F. Jackson, CPA @ 2002-07-05 16:10 UTC (permalink / raw)
To: Stavros Karposilos <apcl79@dsl.pipex.com>; +Cc: pgsql-general@postgresql.org
Hi Stavros,
I have written an example application using a VFP7 front-end to a Postgres
7.2.1 back-end server. It uses a timer control to call a sql_refresh method
in a VFP form. If the timer is off, the form can also be refreshed by
clicking on a refresh button. All transactions are timestapped at the time
of insert or update. Postgres maintains an index of the timestamp. An app
global variables hold the time of when the user starts the app, so only
transactions that have changed since the user began the app are selected
from Postgres via SQL to compare to existing front-end transactions to
update for any changes. If your interested and have Visual FoxPro 7, the
example app can be downloaded from:.
https://www.smvfp.com
It free and complete with all source After entering the site go to option
18.
----- Original Message -----
From: Stavros Karposilos
To: pgsql-interfaces@postgresql.org
Sent: Thursday, July 04, 2002 7:51 PM
Subject: [INTERFACES] MS Access 2K Inform User on Record changes
I have been very troubled the last days trying various ways to notify
the frontend MS Access 2K Client when a table on the Backend has changed.
All my attempts have resulted to a failure.
I realise now that the Notify/Listen solution is not going to work. I
also tried to create an external C routine, callable by Trigger, which was
using a TCP/IP socket to connect to each client but I didn't manage to
convince it to work without crashing.
I would greatly appreciate a working example, or a point to a solution
of whatever form.
I am using PostgreSQL 7.2 running on RedHat Linux 7 networked with 8
clients running Win9x and MSAccess2K on a plain 10MBps Ethernet Network.
Thanks in advance, Stavros
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-07-05 16:10 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-05 00:51 MS Access 2K Inform User on Record changes Stavros Karposilos <apcl79@dsl.pipex.com>
2002-07-05 16:10 ` Leland F. Jackson, CPA <smvfp@mail.smvfp.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox