Encrypting and Decrypting Existing data in a SQL Table



You may have an existing table that is being used by a List control in one of your UX components. Say that the table has field and you would like to encrypt the data in that field. In a previous video we have shown how you can enable encryption for a field in a List, but this only affects edits going forward. You might want to encrypt all of the existing data in that field in your table.

In this video we show how the a5_encrypt_table_field() function can be used to encrypt (or decrypt) existing data in a field in a SQL table.