----- 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.