[dba-SQLServer] 2-minute window

How about setting it up so that the pick process schedules a job to run on the server in 2 minutes that adds the part back into the inventory.  If the user wanted to keep the item you would have to either cancel the job or set up a flag that the stored procedure checkls to cancel the addition back in.

-Chris Mackin

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Arthur
Fuller
Sent: Wednesday, December 08, 2004 3:57 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] 2-minute window


I have to create a situation in which the customer (web) selects an item 
and I want to put a 2-minute limit on the grab, so if the user fails to 
click Submit within two minutes the grab is cancelled.

I really have no idea how to implement this. In keeping with my general 
predilections, then I would much prefer that it occur in the db not in 
the front end, not least because in this app there will be both an 
Access FE and a web FE, so I would like both to fire a sproc or 
something to effect this 2-minute window.

Maybe I could write the grabs to a new table, but I would need to 
observe that in the real table the quantity is 10 and in the temp table 
4 grabs are currently active, i.e. there are only 2 items remaining... 
which could change if the 2-minute window expires or the user clicks Cancel.

I'm quite unsure how to go about this. Any advice? As stated above, I 
would much prefer to do it in the BE than the FEs.

Arthur

>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.289 / Virus Database: 265.4.7 - Release Date: 12/7/2004

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com