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
Steve Gibson