UPDATE: Steve, do you think it could be because a filtered result set is what you got?... Do you get a different result with NOFILTER?
Well I'll be a .....!
I feel sure I got bitten with that expectation way back in FPD2.x and have acted according to my message ever since. Learn something new every day!!!
Thanks for that Steve.
>Jim,
>
>I was thinking the same thing, until I tried it. I normally have SET DELETED ON, so I had not observed this before.
>
>SET DELETED OFF
>SELECT * FROM buyers
>
>Then I used a view that is based on the same table, (still with deleted OFF), and none of the records are marked deleted.
>
>BTW, I'm still VFP6SP5. Hope to get 8 *real* soon.
>
>I'm not sure of the relevance of this, since I'm not generally concered about the deleted records. Todd, if you need to see which ones are deleted in your view, you can add a field to your view, so the SELECT looks something like:
>
>
>SELECT deleted() as lDeleted, * from table1
>
>
>
>>Todd,
>>
>>You are missing something, sort of... while it isn't intuitive, and I don't recoolect mention of it in the VFP docs, ALL records that appear in a SQL result set are "active" (i.e. not deleted) ALWAYS.
>>With a little (or more) thinking it does make sense - you are telling SQL that you are interested in them so it makes them readily available to you. At least I think that's the logic.
>>
>>cheers
>>
>>
>>>Greetings,
>>>
>>>My View is gathering deleted records from the underlying table as it should but is turning the deleted() flag off (recalling the records)in the view result cursor.
>>>
>>>Is this a bug in VFP or am I missing something?
>>>
>>>Many thanks,
>>>
>>>Todd