Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tables with Memos getting corrupted
Message
From
09/07/2015 18:52:49
 
 
To
09/07/2015 17:01:25
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Novell 6.x
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01613967
Message ID:
01621927
Views:
96
>Here is the solution I came up with and has worked ever since the last post.
>I have other tables which are fairly small with memo fields and none of them ever seemed to get the same kind of corruption as my notepad ones do. The notepad tables had one big table with a loan account field and 4 or 5 memo fields to each account number with an index on the loan account number to get to them when the application went to that certain account number.
>
>What I did was took the first four of our account number (which makes up a package for us) and made a folder called NP and in it I split up folders by the first four of the packages of the accounts. Within that I have each full 8 digit account number as a sub-folder. Within that I have an dbf and fpt for each account. No longer even a need for an index (cdx). I then use that table in the location based on the account I am in.
>
>This has worked without a single flaw since then. Anyone having issues with memos, I hope this helps.

Thanks for the follow-up.

Thomas was right to point out Novell 6. Casting my mind way back, there were some client-side settings that had to be configured for reliable operation for VFP apps. Some are still listed at http://fox.wikis.com/wc.dll?Wiki~NovellVFPIssues~WIN_COM_API . If I recall correctly the most important one was at the bottom, "SET CLIENT FILE CACHING ENABLED = OFF".

Sometimes what happens in legacy environments is PCs get replaced, client software for the legacy server(s) gets reinstalled but the critical client-tweaking step is missed. So, you end up with new machines on the network with unreliable client settings.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform