Desktop productivity for business analysts and programmers

Can I turn off prompt: "Query syntax is not valid. Would you like to display the log?"

Accepted Solution Solved
Reply
Contributor
Posts: 33
Accepted Solution

Can I turn off prompt: "Query syntax is not valid. Would you like to display the log?"

Question: Is there a way to turn off the prompt: "Query syntax is not valid. Would you like to display the log?"

Capture.PNG

Rationale: Sometimes I re-use a SAS Enterprise Guide query with a different data set and I know there will be several fields I need to update in addition to the join logic, the filters, and/or computed columns. As I start making my changes, after each update, I get the pop-up, "Query syntax is not valid. Would you like to display the log?" and I have to keep clicking "No" so that I can continue making my changes.

 

Is there a way I can just turn this prompt off? I can always go view the log anytime I want to without being prompted, and it would save me a lot of clicks if this prompt didn't keep re-appearing until all the errors are fixed. I am using SAS Enterprise Guide Version 7.1.

 

Thanks in advance for any help!

 

 


Accepted Solutions
Solution
‎04-17-2018 12:14 PM
Community Manager
Posts: 3,357

Re: Can I turn off prompt: "Query syntax is not valid. Would you like to display the log?"

Posted in reply to brookeewhite1

In the Tools menu (in the Query Builder), you have an option for "Automatically validate changes."  Uncheck it, and you should be good!

 

validate.png

View solution in original post


All Replies
Solution
‎04-17-2018 12:14 PM
Community Manager
Posts: 3,357

Re: Can I turn off prompt: "Query syntax is not valid. Would you like to display the log?"

Posted in reply to brookeewhite1

In the Tools menu (in the Query Builder), you have an option for "Automatically validate changes."  Uncheck it, and you should be good!

 

validate.png

Contributor
Posts: 33

Re: Can I turn off prompt: "Query syntax is not valid. Would you like to display the log?"

[ Edited ]
Posted in reply to ChrisHemedinger

ChrisHemedinger,

 

Aha, perfect! Thank you so much!

Super Contributor
Posts: 472

Re: Can I turn off prompt: "Query syntax is not valid. Would you like to display the log?"

Posted in reply to brookeewhite1

Not sure what exactly your trying to do. Are you using the "Query Builder" that was build with some tables to update with other tables?

 

Did you try unchecking these options:

Untitled.png

Thanks,
Suryakiran
Contributor
Posts: 33

Re: Can I turn off prompt: "Query syntax is not valid. Would you like to display the log?"

Posted in reply to SuryaKiran

SuryaKiran, yes, that is the fix, thank you!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 141 views
  • 1 like
  • 3 in conversation