Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to interrupt a SQL Select?
Message
De
10/01/2000 16:54:36
 
 
À
10/01/2000 16:51:07
Jim Davis
Prospect Information Network
Chicago, Illinois, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00315612
Message ID:
00315783
Vues:
44
>According to the Help file (for SET ESCAPE):
>
>"If the user presses ESC during command or program execution, processing completes at the current program line, and an alert appears with the following three options:"
>
>(them being Cancel/Suspend/Ignore). Are you sure it is interrupting the SELECT? Or stopping just after the SELECT line?
>

It's definitely stopping. I'm doing a SELECT ... INTO CURSOR, and I do NOT have a cursor if I stop it.


>I haven;t been able to get the program to respond to the ESCAPE until after the SELECT is done, and by then it doesn;t matter.
>
>Anyway, per another response by Ed R., a DOEVENTS seems to be critical to intercepting the ESC. By only hitting the DOEVENTS every 2 seconds or so, I seem to be getting okay performance out of the SELECT.
>
>If anyone is interested in what I did, I can post it. It's mostly just a rehash of a couple of other suggestions found on UT.
>
>jd

Glad you've got something that works to your satisfaction.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform