Collapse All
AnyDAC
ContentsIndexHome
PreviousUpNext
EADDBEngineException.SQL Property
EADDBEngineException Class  EADDBEngineException Members  uADStanError Namespace  Example  public  See Also  Send Feedback

Return a failed SQL command text.

Group

public

Links
EADDBEngineException Class, EADDBEngineException Members, uADStanError Namespace, Example, public, See Also
Description

Use SQL property value to get a SQL command text, for which DBMS returned an error. 

This property together with the Params property may be used for the debugging purposes.

Syntax
property SQL: String;
See Also
Example
try
  Log('Removing records');
  ADQuery1.ExecSQL('delete from tab');
  ....
  Log('Inserting records');
  ADQuery1.ExecSQL('insert into tab ...');
except
  on E: EADDBEngineException do begin
    Log(E.Message);
    Log('Failed SQL: ' + E.SQL);
    Log('Failed params: ' + E.Params.Text);
    raise;
  end;
end;
What do you think about this topic? Send feedback!