>
> We should offer a prize for the best suggestion as to why someone
> would do this!
>
> Dave

it's obviously not an important generator. not something to use as a primary
key - just something to start today's counting off. right?

Well if you connect with different names (i.e. each user logs on as a server
validated separate user), then IBX's admin components can tell you a list of
users. But I'm not sure it reliable. Can you be sure that your application
makes only one connection while active? no threads? no additional
connections? with the same credentials?

Alan

>
> --- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
> wrote:
> > > Hello:
> > >
> > > I work with Delphi 5, IBX and FireBird.
> > >
> > > I have a database which has a generator. I want that each time a
> > > user connects to the database, if at that moment, he is the only
> > > user connected, then it resets the generator.
> > >
> > > Is there a way to check if a user is the only user connected to a
> > > database?
> > >
> > > Thanks in advance
> > >
> > > Gustavo
> >
> > and please tell us what havoc and disaster you are determined to achieve
> > from this little mischief?
> > Alan