Keep results entirely in database when possible option

[BaVe]

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.

[CaseySmith · Accepted solution]

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

[BaVe]

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.