Information générale
Catégorie:
Applications Internet
Titre:
Re: can't disable SQLExec messaging
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)
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