Subject Re: [firebird-support] mon$sql_text
Author Thomas Steinmaurer
> Here is an example from the mon$sql_text field from mon$statement table
> Select aa.mon$timestamp, aa.mon$sql_text, aa.mon$state,
> ab.mon$remote_address
> Left Join MON$ATTACHMENTS ab on aa.mon$attachment_id =
> ab.mon$attachment_id
> Where aa.mon$state <> ?
> That question mark represents an variable. My question is from witch
> table I can extract the value and the name of that variable? It is
> possible?
> Thank you for your kind help!

This information is not available via MON$ tables. It might be available
in V3.

The parameters of a paramterized query is already exposed via the Trace
API though.

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.