Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Suppressing OPEN dialog from SELECTs
Message
De
02/04/2002 18:27:57
Hermann Strijewski
Fast Track Business Solutions
Toronto, Ontario, Canada
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Suppressing OPEN dialog from SELECTs
Divers
Thread ID:
00640137
Message ID:
00640137
Vues:
66
I have an application where I want to allow users to enter SQL statements from the web, and then a VFP server application executes these SQLs.

That works all fine, UNLESS someone types in a SQL statement where the FROM ALIAS does not exist, e.g.

SELECT * FROM TRANACT

instead of

SELECT * FROM TRANSACT

and the TRANSACT table does not exist. Then my Server program stops serving because it comes up with the "OPEN FILE" dialog, and the server hangs, because nobody is sitting at it to close that dialog.

Is there some way to SUPPRESS the OPEN dialog when an invalid FROM Alias is specified in the SELECT command?

I figure there must be something better than KEYBOARD "{ESC}"

Thanks in advance for any suggestions!
Hermann Strijewski,
Clearwater, FL
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform