>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement