Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Though I have never worked with deleted records in the view, I would use two separate views (for deleted and not deleted records) to handle separately problems if they arrived.
>Hi Yuri,
>
>>set dele off
>>1. select * from ... into cursor tmpcurs &&it must be the 'regular' cursor, >then it shows the deleted records as deleted.
>>2. select * from ... into cursor tmpcurs NOFILT &&it will show all records >WITHOUt deleted mark. The same is with select .. into table.
>
>
>Yes, it seems to me that "Create View" assumes the Nofilter behavior by default.
>
>Ill probably just create a logical delete flag field in my table to get the result I want.
>
>
>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