>Hello,
>I am designing an application that continuously runs through a loop looking for new records on SQL Server. Whenever I seem to get into the loop, however, it seems that it is "stuck" in there and I cannot do anything else on the form. What I would like to do is place a checkbox that can be checked and the loop will stop on the next pass. Is there a way that the loop can run, but I can still do stuff on the form, such as checking the stop box?
You may want to write an SP or Trigger that will create a message in MSMQ rather than constantly polling the server. There are other ways you can notify from SQL also.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only