Re: Bizarre scenario solved by READWRITE clause on end of SELECT SQL (SOLVED)

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?!?!?)