General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only