Value "V1" (of the table "PS_T1") is encrypted in database (with the "encrypt" method). A field on a page is prompting on this table. I'd like to decrypt this value "V1" when the user access to the prompt. How can I do this ?
Replace the editbox prompt, with a dropdown on a derived record
On the rowinit of the dropdown (if on level 1>) or component (if on level 0) create a rowset that fetches the data from the prompt table..
Now populate the dropdown by looping trough the rowset and decrypt the encrypted data using buildin function Decrypt