Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Formatting of SQL-text after Reverse-Engineering
Wed, Mar 5 2008 11:14 AMPermanent Link

Uli Becker
Small wish: When reverse-engineering a database, the SQL-statements of SP's get an
additional indent of 22 blanks.

Original:
---------------------------------------------------------------------------------

BEGIN
DECLARE Result CURSOR WITH RETURN FOR Stmt;
if StatusID > 2 then /*BG-Posten*/
PREPARE Stmt FROM

Generated Script:
---------------------------------------------------------------------------------

  EXECUTE IMMEDIATE 'CREATE PROCEDURE "ShowPosten" (IN "RechnungenID" INTEGER, IN
"StatusID" INTEGER)
                                         BEGIN
                                         DECLARE Result CURSOR WITH RETURN FOR Stmt;
                                         if StatusID > 2 then /*BG-Posten*/
                                         PREPARE Stmt FROM

Result after executing the Script:
---------------------------------------------------------------------------------

                   BEGIN
                   DECLARE Result CURSOR WITH RETURN FOR Stmt;
                   if StatusID > 2 then /*BG-Posten*/
                   PREPARE Stmt FROM

It just would be nice to keep the formatting.

Regards Uli
Thu, Mar 6 2008 5:02 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Uli,

<< Small wish: When reverse-engineering a database, the SQL-statements of
SP's get an additional indent of 22 blanks. >>

Yes, this was intentional to make the formatting of the creation script be
more readable.  However, I forgot that this would cause the created script
to be improperly formatted.  I'll fix this for the 1.09 release.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image