How does that have anything to do with the price of tea in China? lol
It wasn't that an index was out of whack; it's that the attempt to fully optimize caused VFP to unfortunately filter the table instead of give me an inaccurate count of the cursor.
On 6/26/2020 11:06 AM, Man-wai Chang wrote:
Maybe your server should reindex all DBFs every night after office hours! That's what an 10-year-old FoxPro/DOS MIS system I used to maintain was doing.... :)
On Thu, Jun 25, 2020 at 10:33 AM MB Software Solutions, LLC mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
MYSTERY SOLVED! IT *WAS* THE DELETED INDEX THAT CAUSED THE CHANGE IN BEHAVIOR! I dropped the index, re-ran with the code as it's been the past 4 years, and it worked completely fine.
So much for my seeing if the DELETED() index helped. As I said...I don't think any very small performance gain would be worth the aggravation this caused. (Made me doubt other areas working for years too....you know, the things nobody yet noticed or told you about?!?!?)