END highlight gets confused by BEGIN DIALOG
PDinCA
Posts: 642 Silver 1
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.
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;
Jesus Christ: Lunatic, liar or Lord?
Decide wisely...
Decide wisely...
Comments
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