Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#643 Bug in FormatSql function

2.6.6
closed-fixed
Rob Manning
5
2008-07-20
2008-07-14
Anonymous
No

I'm exporting Sql from a tool that gives me the Sql in one long string. Squirrel has the FormatSql command which is great and formats the Sql nicely, the problem is it doesn't preserve the carriage return/line feeds at the end of each line.

What I end up doing is pasting into TEXTPAD and saving it there.

Is there a setting that will preserve the carriage returns so I don't have to take this extra step ?

per Robert Manning:
That appears to be a bug in the FormatSql command. It hard-codes "\n" instead of using the platform-dependent line separator.
FormatSQLCommand.java (line 64)

Discussion

  • Rob Manning
    Rob Manning
    2008-07-20

    Logged In: YES
    user_id=1287991
    Originator: NO

    Fixed in CVS. Available in the next snapshot release.

    Rob

     
  • Rob Manning
    Rob Manning
    2008-07-20

    Logged In: YES
    user_id=1287991
    Originator: NO

    Fixed in CVS. Available in the next snapshot release.

    Rob

     
  • Rob Manning
    Rob Manning
    2008-07-20

    • status: open --> closed-fixed
     
  • Rob Manning
    Rob Manning
    2008-07-20

    • labels: 796188 --> EditExtras Plugin
    • milestone: --> 2.6.6