firebird-support - ODP: [firebird-support] Knowing the previous rows

Subject	ODP: [firebird-support] Knowing the previous rows
Author	liviuslivius
Post date	2015-08-07T05:32:14Z

Hi,

What about triggers?

Regards,

Karol Bieniaszewski

-------- Oryginalna wiadomość --------
Od: "'Walter R. Ojeda Valiente' sistemas2000profesional@... [firebird-support]" <firebird-support@yahoogroups.com>
Data: 06.08.2015 20:12 (GMT+01:00)
Do: firebird-support@yahoogroups.com
Temat: [firebird-support] Knowing the previous rows

Hello everbody

Always that a transaction that did an UPDATE ends with a COMMIT or a ROLLBACK this left back a row.

So, my question is: There is some way to know those previous rows?

This can be very useful for me because I shall know how many garbage a table has.

For example, if a row has the ID 1234, it would be great a SELECT which show me something like that:

1234 INSERT COMMIT

1234 UPDATE COMMIT

1234 UPDATE ROLLBACK

1234 UPDATE COMMIT

Saying me some "story" of that row.

Is that possible?

Thanks in advance.

Greetings.

Walter.