My two cents are this.
This is the kind of problems they invented transactions for. If you find
yourself doing this on non-transactional tables, you will need to use a lot of
error checking, triggers, application checks and post-cleanups to make it work
somehow. Likely, every once in a wh
Just adding an extra note to the already good Shawn response.
Theoretically this is just as any booking system that needs to be run in
transactions (db or not).
What you are doing is not trivial if that makes you feel better.
The problem is basically that the web interface is asynchronous so you h
Hello John,
On 1/11/2012 11:16, John G. Heim wrote:
I am working on an app to allow a committee to schedule classes. The
members of the committee can all update the database by changing the
time or the instructor for a class. I have to write an app to warn them
when they've scheduled an instruct
I am working on an app to allow a committee to schedule classes. The members
of the committee can all update the database by changing the time or the
instructor for a class. I have to write an app to warn them when they've
scheduled an instructor for 2 classes at the same time or if they've
sch
