Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Use ESC To Interrupt a Runaway Query
Message
De
10/04/2005 21:54:07
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows 2000 SP4
Network:
Windows NT
Database:
Visual FoxPro
Divers
Thread ID:
01003264
Message ID:
01003267
Vues:
18
>I have a form that uses one of 20 or 30 views that query Foxpro 2.6 native tables. Which view is used is determined by which table the user wishes to search and by what criteria. I use the following syntax to either open the view with the specified criteria or Requery it.
>
>
> IF USED(srView)
>   REQUERY(srView)
> ELSE
>   USE (srView) IN 0
> ENDIF
>
>
>Is it possible to allow the user to hit the ESCAPE key to interrupt the command "cleanly"? I want them to be able to stop the query if they accidentally begin the search without specifying all their criteria. I set ESCAPE OFF by default in the setup program of my application.
>
>Thank you.

I think you should SET ESCAPE ON temporarily before running the query.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform