Is there any way to edit the SQL in the query designer?

gregors

There is an option TppDesigner.DataSettings.AllowEditSQL which doesn't allow me to edit the final sql in the DADE query designer. Is this the option to use? ( I'm on 18.01 build 121 if that matters ),

Thanks,

nicocizik

Hi Greg,

From the "SQL" tab of the query designer, you can right click and select Edit SQL to manually edit the SQL code.

gregors

Excellent, thanks. I missed that in the docs, my mistake.