Problem with search in decoded fields (sc_decode)

Scriptcase 9 Bugs
#1

Fields decoded with SC_decode in a grid appear fine, but when doing a search they still show encoded with sc_encode. How can I pass the decoded value to the search?. I use Scriptcase 9.5.003.

Thanks for your help.

#2

I don’t think this is possible with SC

With AES_ENCRYPT and AES_DECRYPT (instead of SC_DECODE) inside a SELECT of SELECT should work

SELECT T.encode_field, T.other.field, ... FROM (SELECT AES_DECRYPT(encode_field, 'AESKEY') AS encode_field, other_field, ... FROM table) AS T