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