Devart Forums

Posted: **Sat 18 Apr 2015 20:09**

I'm using LiteDAC's LiteSQL component to run SQLs to make database updates and have code set to rollback if an error occurs using try..except blocks. That seems to be working well, but I'd also like to capture what the SQL error was but can't find anything that appears to be the error. Is there a way, with LiteSQL or another LiteDAC component, to capture what caused the SQL failure?

Posted: **Mon 20 Apr 2015 10:58**

Hello,

You can use the onError event of the LiteConnection component and the ESQLiteError class:

Code: Select all

uses ..., LiteError;
...
procedure TForm1.LiteConnection1Error(Sender: TObject; E: EDAError;
  var Fail: Boolean);
begin
  ShowMessage(ESQLiteError(E).Message);
end;

Devart Forums

Capture SQL error

Capture SQL error

Re: Capture SQL error