Subject Re: [firebird-support] Detecting Database Changes
Author Andrew Gough
----- Original Message -----
From: "joeacunzo" <joeacunzo@...>
Sent: Friday, January 09, 2004 12:18 PM
> Therefore, I'm looking for a technique to determine if my database
> has been modified by another application. Here's what I've thought
> of so far, all having some hurdle to get over:

Maybe you could look at the DB header for the 'next transaction' field. You
cant do anything to a FB DB without starting (and hence incrementing) the
transaction ID.

gstat -h <db> shows it.

IBPP doesn't give it by default (I don't think), but you *should* be able to
get it via the 'isc_database_info' in fbclient.dll using the
'isc_info_next_transaction' flag. Or add it to one of the IBPP info calls.

Just a thought - I haven't tried this.

Andrew Gough
LiveNote Technologies Inc.