I have multiple statements in the SQL Editor, for example:
SET SCHEMA SAMPLEDB;
SELECT * FROM TABLE1 LEFT JOIN TABLE2 ON FIELD1=FIELD2;
Each statement is terminated by a semicolon — and the “Cmd Sep” drop-down box has a semicolon selected. When I right-click and select “Format”, the semicolons are removed from my statements. Unless I manually re-insert the semicolons, the statements won’t run.
Is there something I’m not doing correctly? Or should the “Format” option leave my semicolons as-is?
Thanks,
Curt