Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Quotes from heck and other format anomalies

How come if I type in code for a procedure, use 4-space indents and blank lines, that upon viewing the code in SQL Central the code is 2-space indented, the blank line is stripped out, and ALL identifiers are quoted (even though I told the editor to not quote identifiers)? There seems to be no way to create nice-looking, readable code. The code below was NOT the way it was typed in. Yes, the snippet was taken from a Toad screenshot, but SQL Central is similar.

SQL Anywhere 16

Message was edited by: Larry Molter

Former Member

When the stored procedure is processed by the server it is parsed and then 'unparsed' into a format that is more 'correct' to the server.  This removes most formatting and explains what you are seeing.

This typically isn't an issue because many (most?) development teams store their SQL as script files in their source control system and edit from there as opposed to from editing from the database definitions directly.

One final note. If you use Sybase Central to edit your stored procedures, it will preserve the formatting of the procedures for you.


0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question