How can we help you today? How can we help you today?

END highlight gets confused by BEGIN DIALOG

Version 6.4.1.164

Using a reformatted snippet from Denny Cherry's Blog, SQL Prompt mistakenly highlights the BEGIN of the BEGIN DIALOG when the cursor is clicked on the last END;

S/B highlighting the first BEGIN exhibited below.
IF CAST(RAND() * 100 AS int) = 0
      OR @DialogHandle IS NULL
         BEGIN
            IF @DialogHandle IS NOT NULL
               BEGIN
                  SEND ON CONVERSATION @DialogHandle
                       MESSAGE TYPE [MT_ConversationSwitch]
               END

            BEGIN DIALOG CONVERSATION @dialogHandle
             FROM SERVICE [Svc_ObjectDelete_Source]
               TO SERVICE 'Svc_ObjectDelete_Destination'
               ON CONTRACT [CT_ObjectDelete_Multi];

            UPDATE Setting
               SET DefaultValue = @DialogHandle
             WHERE SettingName = 'SSB_Session_Delete';

         END;
PDinCA
0

Comments

1 comment

Sort by
  • Aaron L
    Hi Stephen,

    Thanks for letting us know about this! We've been able to reproduce it here and we'll include a fix in our next release.

    Thanks,
    Aaron.

    EDIT: The latest 6.5 beta now correctly resolves the BEGIN/END pairs with BEGIN DIALOG in the pair
    Aaron L
    0

Add comment

Please sign in to leave a comment.