On Tuesday, February 01, 2011 07:12:05 pm Ed Leafe wrote: > On Feb 1, 2011, at 8:11 PM, Adrian Klaver wrote: > > Here are two Python module with read/write on dbase files: > > http://dbfpy.sourceforge.net/ > > http://pypi.python.org/pypi/dbf/0.88.16 > > Remember that some of these programs are limited to Fox 2.x format, and > even the latter link you cited is limited to VFP 6 format, which is > probably a decade old by now. Many don't support .FPT memos, and I don't > know any that support .CDX indices. > > I've conversed with several of the authors of Python-DBF apps over the > years, and for most of them, they were simply a way of getting legacy data > out of either dBase or Fox 2.x applications. They were certainly not > intended to be an active interface to allow you to create apps that > dynamically work with DBFs. > > If you're trying to support a database system that both Fox apps and > Dabo > apps can access, your best bet is to convert the data to a real database > server, such as MySQL or PostgreSQL, both of which VFP can work with > easily. Using DBFs is simply not a good idea outside of Fox itself. > > > > -- Ed Leafe
I have used dbf.py with foxpro 9 - worked for reading and writing (that included the memo). Just a note file names must be in lower case. Also you can also use ODBC. I haven't tried it but it works for other database engines so I assume it will work with the MS FoxPro ODBC driver. Johnf _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
