07.10.2017 22:57, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com
[firebird-support] wrote:
> Which databases are connected, right now?
Use MON$ATTACHMENTS with SYSDBA rights.
--
WBR, SD.
Is there an official way to detect if a database has changed?
I have some expensive reports and backups to run, but if I know that the
database has not changed since I last ran them I can skip those.
fbstat (gstat) shows the next transaction number, but that changes even
when only read-only
Is there a way to include a column in a SELECT but substitute a value if
it doesn't? I need my code to work with different versions of my db schema.
eg I want to SELECT A, B, C, ... but C might not exist.
SELECT * would work of course, except it will fetch a bunch of columns I
don't need.
