At 03:16 PM 12/6/2004, hopemedmike wrote:

>Lets suppose you issue a Delete or Update command, then commit.
>Firebird keeps the deleted records, and the old versions of the
>updated records, until a sweep is performed. Is there any way to use
>these records to revert back to old records and undo deletes and
>updates after they have been committed.

Unfortunately, no. Back versions of records are removed by
garbage collection which happens continuously as pages are
read, so there's no way to predict what parts of an update
remain in the database and which have already been removed.


Regards,


Ann