Help - Timing Logic

I have a multi threaded VB.NET application (4 threads) that I use to send text messages to many, many employees via system.timer at a 5 second interval. Basically, I look in a SQL table (queue) to determine who needs to receive the text message then send the message to the address. Only problem is, the employee may receive up to 4 of the same messages because each thread gets the recors then sends the message. I need somehow to prevent this... just can't think of how. Somehow I need the other threads to know that another thread is already using that record and move on to the next record. I thought of getting the record then marking it (column value) as in use and writing the code to look for records only where not in use... problem is all 4 run fast enough to all use/mark the row. Any thoughts?

Thanks a lot.

Jay

.

Relevant Pages

  • Re: Page security
    ... well i guess you have to somehow do an access check in your application - simply changing the query string is lame of course:)) ... Change the architecture somehow that you will be able to link the task to a company and check that before retrieving the record... ... Dominick Baier - DevelopMentor ... has a number of employees, ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Dilbert
    ... have gotten much in our younger years. ... Somehow the ... facts may not be what everyone wants to know. ... Supervisors don't like to have knowlegeable employees who may ...
    (soc.retirement)
  • Re: The average weekly bbc wage
    ... It's the total wage bill divided by the number of employees. ... Unless it should somehow involve minus ... Jeff ...
    (uk.media.tv.misc)
  • Report on Number of Employees Clocked in
    ... I am looking for advise on a Report I wish to create that will show me total ... I have pulled from a database information per employee per day (for a 7 day ... Obviously not all employees are always clocked in i.e. days off etc, ... in Column C I am hoping (somehow) to show the number of Employees ...
    (microsoft.public.excel)
  • Re: handwritten notes
    ... You can also select the transcriber input option (arrow at bottom right) ... but the writing will be converted to text... ... feelings of Microsoft or any of its employees. ... I am not an employee of Microsoft. ...
    (microsoft.public.pocketpc)