Reported By: Jon Lloyd Duerdoth Reported On: 7/19/2000 For: Version 2.03 Build 1
# 605SQL ALTER TABLE Statement Removes Encryption of Encrypted Tables ALTER TABLE is removing the encryption from encrypted tables if the ENCRYPTED WITH clause is not present.
SQLstr := 'Select * ' +
' into "new" ' +
' from "Funds" ' +
' where FundYear = "1999" ' +
' order by FundID ' +
' encrypted with "xyz" ';
with dbiqTable do begin
SQL.add(SQLstr);
open;
close;
SQL.clear;
SQLstr := 'Alter Table "new" ' +
'add constraint "Dummy" PRIMARY KEY (FundID)';
SQL.add(SQLstr);
ExecSQL;
end;
Comments and WorkaroundsThe workaround is to always include the ENCRYPTED WITH clause.
ResolutionFixed Problem on 7/20/2000 in version 2.04 build 1