I would probably set up a status table of some sort by user specifying that
the user is a) still entering or b) done entering.
Have user A,B and C hit a "done entering" button to update this table.
Something like that anyway....

Kevin

_____

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Matt Nielsen
Sent: Thursday, April 28, 2005 3:10 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Suggestions Please


I have an application that needs to prevent a user from performing an
action until all other users are out of a specific table. I can think
of several ways to accomplish this but not of which is resistant to
abnormal database disconnects. I would appreciate any suggestions.

Example:

User A, B, C are entering payroll numbers for the month.

User D processes those number, but as a failsafe the system needs to
make sure that users A, B, C are not still entering numbers into the
table that User D is going to process. I don't want to prevent users
A, B, C from entering number but I want to tell user D that they are
still doing so.

Thanks,

Matt





___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/


* To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com
<mailto:IBObjects-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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