source (sql) missing new / blank lines formatting issue

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

actual-source-min.png (12K) Download Attachment
function-source-on-database-min.png (10K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: source (sql) missing new / blank lines formatting issue

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
Loading...