facebook

SQL Editor — Format Issue

  1. MyEclipse Archived
  2.  > 
  3. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #301304 Reply

    Curt King
    Participant

    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

    #301325 Reply

    Loyal Water
    Member

    Or should the “Format” option leave my semicolons as-is?

    The format option should leave your semi colon as it is. Thank you for bringing this up. Ill file a PR to fix this right away.

Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: SQL Editor — Format Issue

You must be logged in to post in the forum log in