sql log file with sql statement and parameter value

[Packs]

I have lot of query with parameters .

can I log inside file with sql statement and it's parameter value .

how to achieve this.

[CharlyTango]

Yes, you can ;-)

Unfortunately, my crystal ball is currently being serviced and is therefore out of order.

For a qualified answer, it would be nice if you could also specify which Lazarus version, which FPC version you are using and which access path you have chosen (SQLDB, ZEOS, other) and perhaps also against which SQL database you are querying.
All this could have an influence on the answer.

Some SQL databases have a monitor option to see incoming and outgoing SQL statements.

For SQLDB, TSQLConnector.OnLog is your friend and for ZEOS, TZSQLMonitor might be helpful.
For other access paths ask the vendor ;-)

[Zvoni]

Yes, you can ;-)

Quoting Obama? 

Unfortunately, my crystal ball is currently being serviced and is therefore out of order.

I broke my ball last week....

Some SQL databases have a monitor option to see incoming and outgoing SQL statements.

SQLite has "expanded SQL" function, which does exactly that (returning the "parsed" SQL-Statement with the parameterized Values),
which i even managed to get to work (with a Class-Helper)

EDIT: Have to amend my "got to work": It involved some "edit" inside sqlite3conn, since we need the Cursor (=TSqlite3Cursor), and this type is under the implementation-section (for whatever reason), so it won't work with Class helper and/or derived class

Anyone know why it's under implementation in sqlite3conn, when its ancestor (TSQLCursor) is under Interface in sqldb?