Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Suppressing OPEN dialog from SELECTs
Message
From
02/04/2002 18:27:57
Hermann Strijewski
Fast Track Business Solutions
Toronto, Ontario, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Suppressing OPEN dialog from SELECTs
Miscellaneous
Thread ID:
00640137
Message ID:
00640137
Views:
65
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
Map
View

Click here to load this message in the networking platform