Regions quirk in dbForge 3.0 SQL Server Express

[barryseymour]

I just downloaded dbForge for SQL Server Express 3.0 and am blown away -- it's great!

However, in typically annoying fashion (I'm the annoying one, not your software ) I found a little hiccup right away.

I was unable to get the #region and #endregion commands to apply outlining. In one case, all I wanted to do was put a region around a block of comment notes (delimnited with /* and */) to let me hide them. Didn't work. In a second instance I tried to put a region around a block of CREATE SYNONYM commands, which also didn't work.

I tried to use a simple BEGIN..END construct:

BEGIN -- My notes
/*
All my notes are here
*/
END

or...

BEGIN -- Create synonyms
IF NOT EXISTS (SELECT * FROM SYSOBJECTS WHERE [name] = 'MasterProperties' AND XTYPE = 'SN')
CREATE SYNONYM MasterProperties for OtherDatabase..MasterProperties

IF NOT EXISTS (SELECT * FROM SYSOBJECTS WHERE [name] = 'Lease' AND XTYPE = 'SN')
CREATE SYNONYM Lease for OtherDatabase..Lease
END -- end of Create Synonyms

That worked for collapsing the section, but SQL considered it a syntax error.

Any thoughts? I hope you find this information useful.

Running on Windows XP, connecting to SQL Server 2005. (Someone get me into the current decade!)

Barry Seymour

[alexa]

That worked for collapsing the section, but SQL considered it a syntax error.

Could you please provide us a screenshot of the error?

You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you via e-mail.

Please note that #region does not exist in the T-SQL language. Please refer to the following article http://stackoverflow.com/questions/4386 ... ver-region

[barryseymour]

4.0 fixes this. I use --region and --endregion (no spaces, case sensitive) and it works fine. I can append descriptive text within carets after --region and that will display in the editor. Very nice.

One minor niggle: if I don't type it in *correctly* the first time the expand/collapse functionality doesn't appear until I close and reopen the script.

[alexa]

One minor niggle: if I don't type it in *correctly* the first time the expand/collapse functionality doesn't appear until I close and reopen the script.

Could you please provide us the full script and describe the steps to reproduce the issue step by step? Screenshots would be also of help.

You can send a reply straight to our support system at supportATdevartDOTcom

[barryseymour]

Well darnit, now I can't make it happen. If I stumble upon the steps I'll post them here and/or email them to you.

Barry

[alexa]

We will be looking forward to your reply.