Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 207024769DC
	for <pgsql-general@postgresql.org>;
	Fri,  5 Jul 2002 13:23:36 -0400 (EDT)
Mailbox-Line: From smvfp@mail.smvfp.com  Fri Jul  5 13:23:36 2002
Received: from mail.smvfp.com (wsip68-15-242-97.dl.dl.cox.net [68.15.242.97])
	by postgresql.org (Postfix) with ESMTP id D17FA476B15
	for <pgsql-general@postgresql.org>;
	Fri,  5 Jul 2002 12:10:38 -0400 (EDT)
Received: from jackson (jackson.smvfp.com [192.168.1.116])
	by mail.smvfp.com (8.11.6/8.11.6) with SMTP id g65BCmU05431;
	Fri, 5 Jul 2002 11:12:48 GMT
Message-ID: <001201c2243e$826318e0$7401a8c0@smvfp.com>
From: "Leland F. Jackson, CPA" <smvfp@mail.smvfp.com>
To: "Stavros Karposilos" <apcl79@dsl.pipex.com>
Cc: <pgsql-general@postgresql.org>
References: <002c01c223be$1b033a70$5858fea9@server>
Subject: Re: [INTERFACES] MS Access 2K Inform User on Record changes
Date: Fri, 5 Jul 2002 11:10:40 -0500
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_000E_01C22414.991AA000"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Spam-Status: No, hits=3.1 required=5.0
	tests=MAILTO_TO_SPAM_ADDR,MAILTO_LINK,NO_MX_FOR_FROM
	version=2.30
X-Spam-Level: ***
X-Archive-Number: 200207/184
X-Sequence-Number: 26672

This is a multi-part message in MIME format.

------=_NextPart_000_000E_01C22414.991AA000
Content-Type: text/plain;
	charset="iso-8859-7"
Content-Transfer-Encoding: 7bit

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

------=_NextPart_000_000E_01C22414.991AA000
Content-Type: text/html;
	charset="iso-8859-7"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-7">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>Hi&nbsp;Stavros,</DIV>
<DIV>&nbsp;</DIV>
<DIV>I have written an example application using a VFP7 front-end to a Post=
gres=20
7.2.1 back-end server.&nbsp; It uses a timer control to call a sql_refresh=
=20
method in a VFP form.&nbsp; If the timer is off, the form can also be refre=
shed=20
by clicking on a refresh button.&nbsp; All transactions are timestapped at =
the=20
time of insert or update.&nbsp; Postgres maintains an index of the=20
timestamp.&nbsp; An app global variables hold the time of when the user sta=
rts=20
the app, so only transactions that have changed since the user began the ap=
p are=20
selected from Postgres via SQL to compare to existing front-end transaction=
s to=20
update for any changes.&nbsp;&nbsp; If your interested and have Visual FoxP=
ro 7,=20
the example app can be downloaded from:.</DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2><A=20
href=3D"https://www.smvfp.com">https://www.smvfp.com</A></FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2><FONT size=3D3>&nbsp; It free and complete with all sou=
rce&nbsp;=20
</FONT>After entering the site go to option 18.</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LE=
FT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
  <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>Fro=
m:</B>=20
  <A title=3Dapcl79@dsl.pipex.com href=3D"mailto:apcl79@dsl.pipex.com">Stav=
ros=20
  Karposilos</A> </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20
  title=3Dpgsql-interfaces@postgresql.org=20
  href=3D"mailto:pgsql-interfaces@postgresql.org">pgsql-interfaces@postgres=
ql.org</A>=20
  </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Thursday, July 04, 2002 7:51=
=20
  PM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> [INTERFACES] MS Access 2K=
 Inform=20
  User on Record changes</DIV>
  <DIV><BR></DIV>
  <DIV><FONT face=3DArial size=3D2>&nbsp; I have been very troubled the las=
t days=20
  trying various ways to notify the frontend MS Access 2K Client when a tab=
le on=20
  the Backend has changed.</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>&nbsp; All my attempts have resulted to =
a=20
  failure.</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>&nbsp; I realise now that the Notify/Lis=
ten=20
  solution is not going to work. I also tried to create&nbsp;an external C=
=20
  routine, callable by Trigger, which was using a TCP/IP socket to connect =
to=20
  each client but I didn't manage to convince it to work without=20
  crashing.</FONT></DIV>
  <DIV><FONT face=3D"Arial Greek" size=3D2>&nbsp; I would greatly appreciat=
e a=20
  working example, or a point to a solution of whatever form.</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3D"Arial Greek" size=3D2>&nbsp; I am using PostgreSQL 7.2=
 running=20
  on RedHat Linux 7 networked with 8 clients running Win9x and MSAccess2K o=
n a=20
  plain 10MBps Ethernet Network.</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3D"Arial Greek" size=3D2>&nbsp; Thanks in advance,=20
  Stavros</FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_000E_01C22414.991AA000--