FireDAC Exception handling without driver info

[NamoRamana 3]

When I catch any DB exception arising upon an execution of a query/sp, the "e.message" contains driver info text in the starting the message.. Example: e.message comes as:

 

"[FireDAC][Phys][ODBC][Microsoft]

[SQL Server]Divide by zero error encountered."

 

Is there any way to suppress the driver info from the actual exception text?

 

[Brian 1]

Have you tried using regex?

 

uses
    ...
    System.RegularExpressions;
    
    
    ...
    
    try
      ...
      // some database function
    
    except
      on E: EFDDBEngineException do
      begin
        ShowMessage(TRegEx.Replace(E.Message, '\[[^\]]*\]', ''));
      end;
      on E: Exception do
      begin
        ShowMessage('An unexpected error occurred: ' + E.Message);
      end;
    end;

 

[Brian Evans 108]

That message comes from the underlying database so knowing which database is helpful in interpreting it. Seems counterproductive to be removing context from error messages.

[Anders Melander 1795]

It also tells which layer produced the error. For example, was it the DB server, the DB client library, or FireDAC itself.

It's technical info that provides important context to the developer/supporter. It's not meant to be presented to the user.

[weirdo12 20]

On 11/26/2024 at 2:02 PM, NamoRamana said:

 

Is there any way to suppress the driver info from the actual exception text?

 

There isn't a property or global setting that will do that.