Re: [PHP] PHP and FoxPro

2009-07-21 Thread Floyd Resler
Matt, Thanks for the information. I'll look into using ODBTP. I noticed you mentioned the problem with memos. I currently have that problem with the set up we're using and it is a pain! Thanks! Floyd On Jul 20, 2009, at 3:22 PM, Matt Neimeyer wrote: We currently use the Easysoft ODBC

Re: [PHP] PHP and FoxPro

2009-07-21 Thread Matt Neimeyer
What I did to handle memos... and it's a HACK... was to create a function DoMemo that took as arguments the table, the primary key field of the table, the value of said pk, the field to update, and the string. Take the first 200 characters of the string. Replace all newlines in that substring

Re: [PHP] PHP and FoxPro

2009-07-21 Thread Floyd Resler
Matt, Thanks for the tip on handling memos. I always thought, If I could just append to the end of the existing string... but never figured out how to do it. I'll give your method a shot. Thanks! Floyd On Jul 21, 2009, at 2:04 PM, Matt Neimeyer wrote: What I did to handle memos... and

Re: [PHP] PHP and FoxPro

2009-07-20 Thread Floyd Resler
Paul, Believe me I would like nothing more that to get rid of FoxPro and convert it to MySQL. Sadly, that's not possible right now. I'll check into dBase. Thanks! Floyd On Jul 19, 2009, at 4:53 PM, Paul M Foster wrote: On Sun, Jul 19, 2009 at 09:00:49AM -0400, Floyd Resler wrote: We

Re: [PHP] PHP and FoxPro

2009-07-20 Thread Matt Neimeyer
We currently use the Easysoft ODBC Bridge to connect to a remote FoxPro database. The problem is that the bridge, after a while, starts consuming a ton of system resources and we have to reboot the machine. Afterwards, it can take upwards to two hours before everything is running quickly

[PHP] PHP and FoxPro

2009-07-19 Thread Floyd Resler
We currently use the Easysoft ODBC Bridge to connect to a remote FoxPro database. The problem is that the bridge, after a while, starts consuming a ton of system resources and we have to reboot the machine. Afterwards, it can take upwards to two hours before everything is running quickly