Using Encrypted Data
Author: firstname.lastname@example.org (Iain Sharp)
So, I'm trying to store data in a particular field in the database in an encrypted manner, to prevent our report writer (crystal reports) from being able to report on it. I have written an encrypt and decrypt proc (cp_passwd) as per below, but I have two problems 1. From the documentation, it seems that to store data in a varchar I should be using the USTRING stuff to ensure there are no embedded nulls, but adding it in causes the whole thing to fail. 2. Putting this code <$fieldname>/init = cp_passwd("DECODE",<$fieldname>) in the decrypt trigger of the field, causes the data file to lock almost as soon as read (paranoid locking), I need it to stay as cautious locking (as is set) so is there any way to make the decryption not count as modifying the field?