Beginning with 4D v12, SQL statments can be commented out, as described in Comments Within SQL Statements in 4D v12 and SQL comments in a built SQL statement.

Below is a 4D Macro that you can add to your Maros.xml file which will facilitate the rapid commenting out of a block of SQL code.

<macro name="SQL_Block_Cmnt" in_menu = "true"> <text>/* <selection/>--*/ </text> </macro>

Simply select the lines within the SQL statement to be commented,



then select this maro from the macros menu, from the method toolbar or from the contextual menu,



and the SQL code is commented out.