Desktop productivity for business analysts and programmers

Keep results entirely in database when possible option

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

Keep results entirely in database when possible option

Hey,

 

I've been working with a code from a colleague (who's on vacation for the coming weeks), but at some point a normal query builder fails.

after some troubleshooting I've come to the conclusion that the cause is the option 'Keep results entirely in database when possible option', which is checked in the query builder's options (options --> pass-through). However, both 'checkable' options are locked for me to change. This causes the code to automatically add an 'Execute (' and a 'by con1;' statement in the code. Upon checking, this is not what my colleague did in his last submitted code.

 

Is there a way to uncheck this box?

 

Best regards,

 

BaVe.


Accepted Solutions
Solution
‎08-07-2017 03:08 AM
SAS Super FREQ
Posts: 326

Re: Keep results entirely in database when possible option

I'm pretty sure you are encountering a bug that was fixed in EG 7.12, where the EXECUTE statement was incorrectly added to the generated code.  (So, I assume you are using a EG 7.11 or 7.1.)  If you upgrade to EG 7.12 or later, the issue should be resolved.

 

Casey

View solution in original post


All Replies
Solution
‎08-07-2017 03:08 AM
SAS Super FREQ
Posts: 326

Re: Keep results entirely in database when possible option

I'm pretty sure you are encountering a bug that was fixed in EG 7.12, where the EXECUTE statement was incorrectly added to the generated code.  (So, I assume you are using a EG 7.11 or 7.1.)  If you upgrade to EG 7.12 or later, the issue should be resolved.

 

Casey

Occasional Contributor
Posts: 7

Re: Keep results entirely in database when possible option

Posted in reply to CaseySmith

Hi Casey,

 

Thanks for your reply. I do work in 7.11, but my employer has yet to become eager to upgrade to 7.12. Maybe this additional fix will persuade him.

☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 195 views
  • 0 likes
  • 2 in conversation