Information générale
Catégorie:
Codage, syntaxe et commandes
Yes, it is possible, but I do not believe there exist any practical reason to allow user to do it.
I support the idea that View gives the user ability to modify, add and delete records. Recall is a special maintenance tool that should not be used regularly but in emergency situation and by the database professional.
Sometimes user needs to see records, which were removed for history/archive purposes. But in this case I believe that those records should not be recalled but only displayed because there is no reason for regular user to modify them.
Do you have any other special situation that I did not describe here?
>Thanks for answering, just wondering is it possible to use RECALL using a view?
>
>Thanks
>Nick Patel
>
>>Recall for...
>>
>>
>>>How do I recall a specific record in a table that has been deleted? My table has a primary key (e_id) that I need to lookup by, and then restore that record.
>>>
>>>Thanks
>>>Nick Patel
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