Subject Re: [firebird-support] Implementing dirty flag in a Firebird database
Author Lester Caine
nocsav wrote:

> I'm working on a Firebird application where the user can perform a
> backup (gbak) through our user interface. We'd like to save time by
> skipping the backup if the user hasn't made any changes to the
> database since the last backup.
>
> We're looking into ways of doing this in the application code, but I'm
> wondering if Firebird has anything built in to help us.

Add a few triggers?
Create a table with current and backup timestamp field, update the
current field every time there is an insert or update ( via the triggers
) and check it against the last backup date before doing a backup - at
which time you update both just before the backup.
A bit cumbersome but it works ;)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services