FIREDAC Logging SQL logs

FIREDAC Logging SQL logs

Tracking SQL logs can be used to facilitate the development of program debugging. SQL logging consumes service charges, and it is recommended to turn off SQL logging when you formally deploy the middleware.

FIREDAC records SQL logs by using the Tfdmoniflatfileclientlink control.

First USES FireDAC.Moni.FlatFile, then drag and drop the Tfdmoniflatfileclientlink control.

Main properties of the Tfdmoniflatfileclientlink control:

Set the directory and file name that SQL log saves:

Fdmoniflatfileclientlink1.filename: = Extractfilepath (application.exename) + ' SQL ' + formatdatetime (' YYYYMMDD ', now) + '. txt ';

To set tfdconnection control logging parameters:

Fdconnection1. Params.add (' Monitorby=flatfile ');

Start SQL logging:

Fdmoniflatfileclientlink1.tracing: = True;

Fdconnection1. Connectionintf.tracing: = True;

To stop SQL logging:

Fdmoniflatfileclientlink1.tracing: = false;

Fdconnection1. Connectionintf.tracing: = false;

FIREDAC Logging SQL logs