Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Updating a view column that is an expression
Versions des environnements
OS:
Windows Server 2012 R2
Network:
Windows Server 2012 R2
Virtual environment:
VMWare
Hi all,
Is there any way to mark updatable a column in a view that is an expression? i.e. the expression is:
PADR(DecryptString(Bank_Name),50) AS Bank_Name
but this does not show up in the view designer as a field that can be updated (2nd last tab).
Why would I want to do this - the bank info is encrypted and so I wanted to pull it out of the table into a view and decrypt the fields on the fly. Once in the view, the user can edit and then before posting back the results, I encrypt the fields).
I first did this by pulling the encrypted data into the view and then decrypting the fields before presenting to the user. But this dirties the view such that I don't know if the user made the changes or my code.
Any suggestions?
Albert
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