Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Re: can't disable SQLExec messaging
Message
From
29/07/2002 10:46:00
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Internet applications
Title:
Re: can't disable SQLExec messaging
Miscellaneous
Thread ID:
00683515
Message ID:
00683515
Views:
67
I am building a project that runs on a company intranet. As a guide I am using Rick Strahl's book "Internet Applications with Visual FoxPro 6.0". I am loading the project as an .EXE not as a .DLL. The project runs fine except when I execute an SQLEXEC statement, which runs a very large stored procedure on our SQLserver. If this method is built into the project then I get an error message from the .exe that a UI is trying to display, which is illegal and blows the web app. If I block the method the project runs. How do I complete disable the system messaging that happens when an SQLEXEC runs? I use the following code to shut down the messages but it doesn't seem to apply to the SQLEXEC command.

* init routine
SET TALK OFF
SET SAFETY OFF
SET CONFIRM OFF
SET BELL OFF
SET EXCLUSIVE OFF
SET STATUS BAR OFF
SET DELETED ON
SET SAFETY OFF
SET SYSMENU TO
SET CARRY OFF


* this from rick strahl
SET RESOURCE OFF
SET EXCLUSIVE OFF
SET CPDIALOG OFF
SET DELETED ON
SET EXACT OFF
SET SAFETY OFF
SET REPROCESS TO 2 SECONDS

*** Force server into unattended mode – any dialog
*** will cause an error with error message
SYS(2335,0)

*** If you use a SQL backend use this to prevent login dialogs!
SQLSetProp(0,"DispLogin",3)
Next
Reply
Map
View

Click here to load this message in the networking platform