I have done some work with VFP and PostgreSQL, and found it to be quite easy to work with. My needs were quite simple, so I have not bothered to cut any of my commercial apps over to PostgreSQL for a back end. But for what I needed (large database tables using parameterized views in VFP against PostgreSQL tables) the solution worked well. That way I could look at the section of the database tables I needed without exceeding the VFP 2Gb limit for files (including temp cursor files). The largest PostgreSQL table I was accessing that was was over 16Gb. Worked like a charm.
Be certain to get some good books on PostgreSQL. The is one called PostgreSQL For Windows that I found most useful in the Windows OS platforms. All other books refer briefly to Windows, but focus more on Linux - which at the time was not of interst to me. Also be certain to get familiar with PGAdmin III to help manage and set up your database(s). My next large step is to migrate to PostgreSQL on a Linux Server just for the connectivity without the CAL pricing. Gil > -----Original Message----- > From: profoxtech-boun...@leafe.com > [mailto:profoxtech-boun...@leafe.com]on Behalf Of MB Software Solutions > General Account > Sent: Thursday, February 19, 2009 11:04 PM > To: profoxt...@leafe.com > Subject: Reading/writing to a Progress database from VFP9SP2 > > > Got a client who's got a Progress DB and he wants me to be able to make > changes (add/edit/delete) to it. Not structural changes...only data > changes (at least to start). > > Has anyone here ever worked with a Progress database from VFP? > > tia! > --Michael > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/ndbblhfmcdkpegpoiiapeedhbjab....@gilhale.com ** 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.
