> 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
>
> From MON$STATEMENTS aa
>
> 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. http://tracker.firebirdsql.org/browse/CORE-2429

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



--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

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