Grid update problem with encryption

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
JacobusOpperman
Posts: 9
Joined: Sun 24 Feb 2019 21:48

Grid update problem with encryption

Post by JacobusOpperman » 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!

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Grid update problem with encryption

Post by ViktorV » Wed 27 Feb 2019 12:12

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.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Grid update problem with encryption

Post by ViktorV » Wed 27 Feb 2019 12:15

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.

JacobusOpperman
Posts: 9
Joined: Sun 24 Feb 2019 21:48

Re: Grid update problem with encryption

Post by JacobusOpperman » Wed 27 Feb 2019 20:05

Thank you ViktorV for the reply. Everything work as expected and my problem is solved - thank you!

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Grid update problem with encryption

Post by ViktorV » Thu 28 Feb 2019 07:52

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.

Post Reply