Subject Re: [firebird-support] mon$sql_text
Author Mark Rotteveel
On Wed, 6 Nov 2013 14:32:25 +0200, "Bogdan Mihalache"
<bogdan.mihalache@...> wrote:
> 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
> I
> can extract the value and the name of that variable? It is possible?

You can't. Positional placeholders (question marks) are the only parameter
placeholders that Firebird supports in DSQL. Some drivers support named
parameters, but those drivers translate/transform from named parameters to
positional parameters before sending the query to the server.

The values used for the parameters can only be obtained using the trace
service. They can't be queried from a monitoring table.