Class CryptTable() Professional
Class function of the CryptTable() class
The CryptTable class manages encryption and decryption of database tables. A database table is encrypted by specifying the encryption type and which key to use. The key must be retained in a safe place and is required to open the table after closing. It is also required to use the same CryptProvider, of course.
Data is encrypted record-wise using the operation mode CBC/CTS by default. This mode requires an additional field to store the initialization vector (IV), which is a prerequisite for CBC. The IV is filled with random data, and serves as the first block to be XOR'ed with the following data block. This enhances the level of security for records containing data with minor differences, such as customer numbers, timestamp fields etc. It also prevents the record from being falsified by exchanging a block.
The method :setupStruct()will adapt a given table structure to comply with the encryption mode. If the length of the record is less than 1 block length, it will be extended.
SecureKey():destroy() can be called right after passing the key object.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.