Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Re: can't disable SQLExec messaging
Message
De
29/07/2002 10:46:00
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Applications Internet
Titre:
Re: can't disable SQLExec messaging
Divers
Thread ID:
00683515
Message ID:
00683515
Vues:
65
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
Fil
Voir

Click here to load this message in the networking platform