Add ParserLookBackDistance and ParserLookAheadDistance values to the Options menu
Due to the length of some of the queries I write, I have to edit the file RedGateSqlPromptEngine_EngineOptions.xml manually. It would be nice to be able to edit the values for ParserLookBackDistance and ParserLookAheadDistance in the Options menu. I understand the drawbacks of making these values too large. If they were in the Options menu I could adjust them for a long query and then set them back for shorter queries.
3
votes
These options have been superseded with a new system in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Adrian Sherwin
commented
This is misleading.
SQL Prompt 7.1.0.310 does not have ParserLookAheadDistance in the Options menu, and the default value of 3000 is too low.