On Wed, 6 Nov 2013 14:32:25 +0200, "Bogdan Mihalache" <[email protected]> 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 > > 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?
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. Mark
