Subject | Re: [firebird-support] TMP$STATEMENTS - field "sql" in firebird ? |
---|---|
Author | Helen Borrie |
Post date | 2005-06-20T02:40:32Z |
At 01:38 AM 20/06/2005 +0200, you wrote:
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
>Andi Voss schrieb:The answer is No. Firebird doesn't have tmp$tables or tmp$statements. You
> > 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?
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