Page 1 of 1

Grid update problem with encryption

Posted: Wed 27 Feb 2019 11:26
by JacobusOpperman
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!

Re: Grid update problem with encryption

Posted: Wed 27 Feb 2019 12:12
by ViktorV
See more details about data encryption in the IBDAC documentation: https://www.devart.com/ibdac/docs/encryption.htm
If this does not help you in solving your issue, please compose a small sample demonstrating the specified behavior and send it to us using the contact form https://devart.com/company/contactform.html, including scripts for creating and filling database objects.

Re: Grid update problem with encryption

Posted: Wed 27 Feb 2019 12:15
by ViktorV
See more details about data encryption in the IBDAC documentation: https://www.devart.com/ibdac/docs/encryption.htm
If this does not help you in solving your issue, please compose a small sample demonstrating the specified behavior and send it to us using the contact form https://devart.com/company/contactform.html, including scripts for creating and filling database objects.

Re: Grid update problem with encryption

Posted: Wed 27 Feb 2019 20:05
by JacobusOpperman
Thank you ViktorV for the reply. Everything work as expected and my problem is solved - thank you!

Re: Grid update problem with encryption

Posted: Thu 28 Feb 2019 07:52
by ViktorV
It is good to see that the problem has been solved.
Feel free to contact us if you have any further questions about our products.