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.
--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com
_______________________________________________
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.
