2005/6/16, clarionho <clarionho@...>:

> Can anyone told me, Which SQL statement in Firebird, can told me how
> many user connect to the FireBird database.
>
> In IB Expert, there is founction to know which user connect to the
> Firebird datbase and No. of user connect.

As Martijn already made clear, you can't do this via SQL.
You need to use the Firebird API. More precisely, it's the
isc_database_info function.
Check out the APIGUIDE.PDF file for further information (Page 54).

Bye,
Daniel

--
eat(this); // delicious suicide