From: Leland F. Jackson, CPA <smvfp@mail.smvfp.com>
To: Stavros Karposilos <apcl79@dsl.pipex.com>
Cc: pgsql-general@postgresql.org
Subject: Re: [INTERFACES] MS Access 2K Inform User on Record changes
Date: Fri, 5 Jul 2002 11:10:40 -0500
Message-ID: <001201c2243e$826318e0$7401a8c0@smvfp.com> (raw)
References: <002c01c223be$1b033a70$5858fea9@server>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: smvfp@mail.smvfp.com, apcl79@dsl.pipex.com, pgsql-general@postgresql.org
Subject: Re: [INTERFACES] MS Access 2K Inform User on Record changes
In-Reply-To: <001201c2243e$826318e0$7401a8c0@smvfp.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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