Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Suppressing OPEN dialog from SELECTs
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
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