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