It looks like Ted's VFP code is designed to connect to a PostgreSQL
database running in windows using PostgreSQL's ODBC driver. I have
written an example application of how VFP can be used as a
GUI/application to connect to a PostgreSQL database server, which can be
downloaded from the shopping cart on my website. However, the
PostgreSQL database to which this VFP application connects is no longer
available on my database server, but the application can be downloaded
from my website for free, if you want to take a look at the source
code. The name of the application is smsql.ZIP. If you had the time,
you could even create your own PostgreSQL database from the source code,
and then connect to it using VFP.
http://www.smvfp.com
If all that is involved is setting some flag in the main VFP A/R table
to indicate whether the monthly payment has been received or not, I
would have the web based perl script, that provides the downloads, use
perl's DBI and DBD::ODBC modules to read this flag in the VFP table and
respond accordingly. If the perl script accepts credit card payments
that need to be entered into the VFP application, it could be a separate
application from which monthly totals as summarized for enter into the
VFP application.
Regards,
LelandJ
Ted Roche wrote:
On 7/17/06, Ken McGinnis <[EMAIL PROTECTED]> wrote:
ok, so maybe I could update a Postgres with the values (instead of
creating a fox free table), then perl could read and write the
Postgres data. What if I only want to read/write 4 fields (maybe
20,000 records) into a single table? Do you know a URL reference
for
1. install Postgres on Win2000 pro
2. some simple code for vfp9 to read/write 4 fields in Postgres
3. some simple perl code to read/write the same fields in Postgres
Sry if this is something simple, but I have no experience with Postgres.
Leland can probably provide far more detailed answers than I.
The docs are at: http://www.postgresql.org/docs
The downloads are at http://www.postgresql.org/download/
sample code:
* Create a PostgreSQL Odbc driver called "Frank" (or a name of your
choosing)
liHandle = SQLCONNECT("Frank")
SQLExec(liHandle, "SELECT field1, field2, field3, field4 FROM
YourTable", "curResults")
* Gives you a cursor of results
* Update record 5:
SQLExec(liHandle, "UPDATE YourTable SET field1='a', field2=3,
field3='ostrich', field4='Ernest' WHERE YourTable.iYourTablePK=5")
The rest of the minor details of client-server occupy a couple of
books and some great white papers online. Let us know your level of
experience and we can suggest appropriate tools.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
