Apollo VCL Components > Apollo VCL Component Reference > TApolloQuery > TApolloQuery Properties

Declaration

property Password: String;

Description

Defines the default encoding key to be used in decrypting data within all encrypted tables within the SQL expression. If you define this value, it is assumed that all tables within the SQL expression have been encrypted with this same password. If some tables within the SQL expression are not encrypted, or some tables us a different password than others, you should predefine the tables using the TableNames property.

$image\tip.gif$ To turn off record-level encrypting, pass this parameter as a NULL string ('' or #0).

Delphi Example

// Browse an encrypted table

with ApolloQuery1 do

begin

SQL := 'SELECT * FROM Test WHERE Age > 50';

PassWord := 'EVH5150';

Open;

end;

C++Builder Example

// Browse an encrypted table

ApolloQuery1->SQL = "SELECT * FROM Test WHERE Age > 50";

ApolloQuery1->PassWord = "EVH5150";

ApolloQuery1->Open();