Hi,
I have an application in Westwind (I'll be posting a similar query there as well, but need the broadest reach possible), that when results are returned intermittently records that have the deleted flag set for them are showing.
It happens oftentimes when the users clicks to sort the column in the displayed grid or clicks on the very last page of a paged report. When it occurs, it will oftentimes revert back to displaying only non-deleted records.
The code for sorting and paging is unmodified Westwind framework code.
What's really weird is this is only happening to one client (to my knowledge) and only on his server. I downloaded his same data and without doing anything, not re-indexing or anything else, when I run the code on my development machine I don't get the deleted records showing.
In trying to debug the issue I tried in two browser sessions to run the same process on the "live" data and the same data on my development machine and then neither one displayed deleted records.
I've gone to other sites running the same version of the software and I don't see it happening there.
In stepping through the code at no time do I issue a SET DELETED OFF command.
The SET DELETED ON is set at the very beginning of the code as the user logs in, and only in specific spots is it turned off and back on, but again not anywhere in the sequence of code that produces this listing.
If I didn't see it for myself and have a screenshot emailed to me, I wouldn't have believed it, but unfortunately I must, and I have a very concerned client.
Thanks for anyone's help
Kevin
Kevin R. Hunt