On Mon, Sep 12, 2011 at 10:30, Olaf Kluge <olaf.kluge@...> wrote:

> I would like to send all 30 seconds an event to the connected client to
> confirm the connection. How can I realize that? There are different clients
> connected, for each I need this function.

Howdy,

AFAIK there is no functionality to do this from inside the database.
Can you tell us what you're trying to achieve? Maybe there is another
way to do what you want.

E.g. I needed to count the number of client applications already
connected to the database at application startup: The client which
needed that number would post an event for which all clients were
listening. When received every client would insert a record into a
table which could then be counted.

If you're just interested in all connections to the database you could
use the monitoring tables in newer versions of Firebird
(MON$ATTACHMENTS), see here:
http://www.ibphoenix.com/resources/documents/search/doc_3

Or maybe you could use an ON CONNECT trigger:
http://www.firebirdsql.org/refdocs/langrefupd21-ddl-trigger.html

HTH,
Markus