Hi,

I am creating an application which needs to
select the names of the database users very
often.

An example:
Every evening, the employees access the database
to insert the projects they worked for an the time
they needed into the table 'T_Work'.

Later, the boss should be able to mark certain names of employees
which are shown in a list an then click a button which shows him
a summary of their activity.

For now, my solution for this is:
1. Connect ISC4.GDB, select all user names
2. Show names in a list
3. Execute a query (using params) for each user to select the user's
activities from the production database

Of course, this does not seem to be very elegant and it is very slow.
In addition to that, I dislike having two connections for ISC4.GDB and
the production database. I would like to make it faster and more elegant.
My favourite solution would be to have a stored procedure for it, but I
don't know how this can be accomplished.

I am sure some of you had this problem too and I am curious if there is
a good solution.

Cheers and TIA,

Christian