source (sql) missing new / blank lines formatting issue

[Users mailing list]

Hi all,

I am using Squirrel client 3.7.1

When i try to create a function which have new lines in source code and proper formatting of SQL statement, it execute successfully but remove all the white spaces. Some how squirrel removing formatting from actual script which execute on database.

Above result in poor format when some one see the source of function / procedure.

Please find two attachments as an example which is showing what happens in mysql.

In Oracle, semicolon (;) from previous line come at start of next line.

In MYSQL, all new line characters are missing

Best Regards,

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Users mailing list]

Hi guys,

Still waiting for reply. mean while i am using mysql-workbench for executing my functions/procedures to retain format of sql script.

Best Regards,

On Thursday, 15 June 2017, 14:42, rizwan Ishtiaq via Squirrel-sql-users <[hidden email]> wrote:

Hi all,

I am using Squirrel client 3.7.1

When i try to create a function which have new lines in source code and proper formatting of SQL statement, it execute successfully but remove all the white spaces. Some how squirrel removing formatting from actual script which execute on database.

Above result in poor format when some one see the source of function / procedure.

Please find two attachments as an example which is showing what happens in mysql.

In Oracle, semicolon (;) from previous line come at start of next line.

In MYSQL, all new line characters are missing

Best Regards,

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users