It doesn't modify the Indexes; thanks for pointing that out. Modifying memo fields is fine. I'll look at the indexing, if i can find info on the structure...
I needed to rename a field in a foxpro table programatically and without touching the data. I wrote the following code which modifies the header information.
Disclaimer: Back up your data! This code uses low-level functions to manipulate the database header. I can't accept any responsibility...
Here's a quick snippet which converts long file name paths to foxpro compatible short file paths. e.g. 'c:\program files' becomes 'c:\progra~1'.
*************************************************
* This function will convert long path names to
* foxpro compatible short path names
* It...
Hi. We had exactly the same issues with our software, and found it was the foxpro FLUSH command that is causing the slowdown. At regular intervals in our code, we used FLUSH to save changes to the databases.
To resolve, we placed the FLUSH commands less frequently and more strategically!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.