SELECT *
FROM MON$ATTACHMENTS c WHERE c.MON$ATTACHMENT_ID <> CURRENT_CONNECTION

if row_count > 0 exists other user connect

Best Regards
=========
|| ISMAEL ||
=========

----- Original Message -----
From: jacobhavkrog
To: firebird-support@yahoogroups.com
Sent: Wednesday, October 19, 2011 11:16 AM
Subject: [firebird-support] Programatically detect shutdown state of database? IBOAdmin?



Hi -

How can I from my Delphi application detect the shutdown state (normal/multi user maintenance/single user maintenance/full) of a database?

Like what the gstat command line tool can tell me.

I need it for a remote database too.

IBOAdmin can be used to do shut down a database and bring it back online, but can it also tell me the current state?

I want to do a programmatic restore, so I want to shut down the database before using gbak. But I cant find a way to make sure that a shut down has completed sucessfully..

Thanks
Jacob





[Non-text portions of this message have been removed]