Subject Re: [firebird-support] TMP$STATEMENTS - field "sql" in firebird ?
Author Helen Borrie
At 01:38 AM 20/06/2005 +0200, you wrote:

>Andi Voss schrieb:
> > Hi,
> >
> > is there a possibility to get the last query in text-form like in
> > Interbase TMP$STATEMENTS - field "sql" ?
> > I need the complete text-form query from a query for a replication of
> > the dataset which has changed at last. I thought it would be easy to
> > take this query from the tmp$table with a Trigger, but in firebird there
> > aren't tmp$tables ?
> >
> > Thanks for help.
> > Greets Andi
>
>Does nobody knows something about my problem?

The answer is No. Firebird doesn't have tmp$tables or tmp$statements. You
would need to set up your own system of triggers that could reconstruct the
statement from the operation and the 'new' variables and fire off
events. That said, there are various replication tools around that already
do all this stuff.

./heLen