Reported By: Tonis Argus Reported On: 4/21/2012 For: Version 2.08 Build 3
# 3583ExecutionResult Not Set Properly for TEDBQuery Component With the code below, qTemp.ExecutionResult seems never to be true. Database did not give corrupt table errors anymore and I suppose that table is repaired. LogMessage event will give information out but I cant figure out how to use ExecutionResult property.
If qTemp.Prepared Then
qTemp.UnPrepare;
qTemp.SQL.Text := Format('REPAIR TABLE "%s"', [rtbls[i]]);
qTemp.Prepare;
qTemp.ExecSQL;
if qTemp.ExecutionResult then
aLog.Add(FormatDateTime('dd.mm.yyyy tt', now) + #9 + tbls[i] + #9 + CSpecCmdResultArray[2]);
ResolutionFixed Problem on 4/21/2012 in version 2.09 build 1
Products AffectedElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial