Encrypting table field example at INSERT / UPADTE
Posted: Sun 18 Nov 2018 12:11
Hello,
Can anyone help me with an example of how to use IBCEncryptor at INSERT / UPADTE?
I tried this way, but the data in field 'NMN' left unencrypted after commit
Thank you
DELPHI2007
FB2.1
IBDAC6.1.7
Can anyone help me with an example of how to use IBCEncryptor at INSERT / UPADTE?
I tried this way, but the data in field 'NMN' left unencrypted after commit
Code: Select all
IBQuery1.Encryption.Encryptor := IBCEncryptor1;
IBQuery1.Encryption.Fields := 'NMN';
IBCEncryptor1.Password := '12345';
IBQuery1.SQL.Text := 'INSERT INTO T_NOM_5 (NUMBE,NMN) VALUES( :NUMBE, :NMN )';
IBQuery1.ParamByName('NUMBE').AsString := '1';
IBQuery1.ParamByName('NMN').AsString := 'text123';
IBQuery1.ExecSQL;
IBTransaction1.Commit;
DELPHI2007
FB2.1
IBDAC6.1.7