VFP does NOT change a 2.6 table in any way. You just have to be sure that any table you create in VFP that needs to be accessed 2.6 uses COPY TO table26 TYPE FOX2X
Fred On Wed, Jul 15, 2015 at 1:47 PM, Kevin Cully <[email protected]> wrote: > Situation: I've created a proposal for a new client for upgrading an old > FPW2.6 application to a web based application using PostgreSQL as the DB. > The client likes my proposal but they're wondering that if they run out of > money during the project, could they create a way to pull the data down and > populate the portions of their FPW2.6 system that isn't converted yet. > This 'pull' would take place on a periodic basis. Every 30 minutes? > > I know that I can access PostgreSQL data via VFP, but I can't recall if > FPW2.6 can access PG data directly via ODBC. > > As a fall back, I could write a VFP application that could pull the data > down, and then kick off a process to populate the FP data tables. If I > remember correctly that if VFP accesses FP2.6 tables then VFP tries to > update the headers of the tables. > > This sounds like a major kludge. Best way to approach this backup plan? > > CULLY Technologies, LLC > http://cullytechnologies.com > http://cully.biz > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJCBksqFkcSugfAJVqucg-D2w3iOP=vzvq=trbj1ld5yqh5...@mail.gmail.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.

