> 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.
