Grid update problem with encryption
Posted: Wed 27 Feb 2019 11:26
Hi!
I hope someone will be able to help me. Everything work as expected when IBCEncryptor1 is not added to IBCQuery1. However with 'IBCQuery1.Encryption.Encryptor := IBCEncryptor1;' and records inserted to the database I have a problem. I also have 'IBCDatasource1.AutoEdit := True;' and I use TDBGrid as VCL data aware component. My problem when encryptor is added is the following: I change a cell in the TDBGrid and click on another row in the grid for it to update. I then disconnect from the firebird database. When I connect again and do a SELECT query the cell in the TDBGrid that was edited is filled with unreadable random numbers and letters. I do a select query via 'IBCQuery1.SQL.Text'.
I use Delphi Rio Community and IBDAC Professional 6.3.10. What do I do wrong? Thank you for your help!
I hope someone will be able to help me. Everything work as expected when IBCEncryptor1 is not added to IBCQuery1. However with 'IBCQuery1.Encryption.Encryptor := IBCEncryptor1;' and records inserted to the database I have a problem. I also have 'IBCDatasource1.AutoEdit := True;' and I use TDBGrid as VCL data aware component. My problem when encryptor is added is the following: I change a cell in the TDBGrid and click on another row in the grid for it to update. I then disconnect from the firebird database. When I connect again and do a SELECT query the cell in the TDBGrid that was edited is filled with unreadable random numbers and letters. I do a select query via 'IBCQuery1.SQL.Text'.
I use Delphi Rio Community and IBDAC Professional 6.3.10. What do I do wrong? Thank you for your help!