Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

autorespond

Status
Not open for further replies.
DanNorris2000

DanNorris2000

Technical User
Joined
Nov 10, 2000
Messages
186
Location
US
Is there a way to automatically respond in a program to the create SQL view prompt "already exists, overwrite it?"
 
Sort by date Sort by votes
Try SET SAFETY OFF before you run your query, then SET SAFETY ON, if you want, when you are done. Be sure and check the documentaion for "gotchas" on these commands though.
 
Upvote 0 Downvote
I believe if you
SET SAFETY OFF
before you create the view, you won't get the message. (You may want to set SAFETY back to it's previous value afterwards.)

Rick
 
Upvote 0 Downvote
I don't know if there is a way to repond to that but you can Set Safety Off in order that message does not appear.

You could try somewhat like this:

Procedure Recreate_View
Local lcSafety
lcSafety = Set("Safety")
IF lcSafety = "ON" then
Set Safety off
*!* Recreate your view here
Set Safety &lcSafety
EndIf
Return





Edwin Dalorzo
edalorzo@hotmail.com

 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top