Carl, Yep, that's the idea. I'd envisaged leaving the VFP application alone then gradually moving it over to Dabo.
However, I think that I'll simply convert the VFP application to MySQL from native tables and continue from there with Dabo. The conversion should only take me a day - and it's been something I wanted to do a couple of years ago when I first wrote it. Dave -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carl Karsten Sent: 11 December 2007 17:35 To: Dabo Users list Subject: Re: [dabo-users] Dabo lift-off or crash and burn! Paul McNett wrote: > Carl Karsten wrote: > >>>> 5. Has anyone successfully managed to access VFP data (read and write) using >>>> anything other than the PHP ADODB software >>>> >>>> http://phplens.com/lens/adodb/adodb-py-docs.htm >>>> >>>> in addition to the mxODBC software >>>> >>>> http://www.egenix.com/products/python/mxODBC/ >>>> >>> if you need odbc support I would also try ceODBC package. >> I agree. I am using http://ceodbc.sourceforge.net with c-tree odbc drivers. the >> c-tree driver has a bug, and the ceodbc author (Anthony Tuininga) built in a >> work around in under a day. He also gave me some tips to make my code better. >> Did you know you could do: >> >> connection = connect... >> srcCur = connection.cursor() >> srcCur.execute('bla bla bla') >> >> for row in srcCur: >> rowNo = srcCur.rowcount >> >> I was doing: for rowNo, row in enumerate(srcCur.fetchall()) >> >> He is also the author of the Oracle db module. guessing that counts for something. >> >> However, I would put dbf access aside and look at changing the VFP app from dbf >> to postgresql or mysql. Although a dabo odbc module would more productive for >> the rest of the world. tough call. > > I think where you want to use DBF, you should use sqlite, especially if > it is single-user. For everything else, you should use PostgreSQL, > MySQL, or Firebird. I am assuming he wants to run the 2 systems in parallel. Is this correct? Carl K [excessive quoting removed by server] _______________________________________________ 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/dabo-users/[EMAIL PROTECTED]
