Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement